Interactive data entry validation and problem correction in a table component in a spreadsheet driven by a web service
Implementations generally relate to a spreadsheet add-in that provides data entry validation. As described in more detail herein, the spreadsheet add-in integrates a spreadsheet-based table component with a remote web service. The spreadsheet add-in uses web service metadata to validate data that a user enters into the spreadsheet. The spreadsheet add-in provides immediate feedback on errors in an interactive fashion for the user. Furthermore, during a data upload process, any errors that are reported by the web service are displayed in context such that the user may quickly affect corrections.
1. A method for validating a user-provided data entry to a spreadsheet at a client device with web service metadata, the method comprising:
making a request, by the client device, for web service metadata from a representational state transfer (REST)-compliant web service, wherein data is populated into different fields of the spreadsheet sourced by various databases that pass such data through the REST-compliant web service;
determining one or more requirements of the REST-compliant web service based on the web service metadata, the one or more requirements including one or more of a field is required, a field is read-only, or a particular data type is needed, wherein at least one of the one or more requirements indicated by a visual feature of a respective column on a spreadsheet;
accepting the user-provided data entry into the spreadsheet;
validating if the user-provided data entry meets the one or more requirements of the web service metadata without an additional query to the REST-compliant web service;
backend validating, using the REST-compliant web service, if the user-provided data entry meets one or more requirements specified by the REST-compliant web service but not specified by the web service metadata, wherein the backend validating is initiated by a user-provided input; and
indicating an invalid data entry on the spreadsheet if the user-provided data entry does not meet one or more of the one or more requirements of the web service metadata.
2. The method of claim 1 , wherein validating the user-provided data entry occurs without being initiated by user-provided input.
3. The method of claim 1 , further comprising indicating a valid data entry if the user-provided data entry meets the one or more requirements of the web service metadata.
4. The method of claim 1 , further comprising indicating, by the visual feature, at least one read-only field in the spreadsheet based on the web service metadata.
5. The method of claim 1 , wherein a message about the backend validation of the user-provided data entry is shown next to the user-provided data entry in the spreadsheet.
6. The method of claim 1 , wherein a backend validation message about the user-provided data entry is shown in a status window.
7. A non-transitory computer-readable storage medium carrying program instructions thereon, the instructions when executed by one or more processors cause the one or more processors to perform operations comprising:
making a request, by a client device, for web service metadata from a representational state transfer (REST)-compliant web service, wherein data is populated into different fields of a spreadsheet sourced by various databases that pass such data through the REST-compliant web service
determining one or more requirements of the REST-compliant web service based on the web service metadata, the one or more requirements including one or more of a field is required, a field is read-only, or a particular data type is needed, wherein at least one of the one or more requirements is indicated by a visual feature of a respective column on a spreadsheet;
accepting a user-provided data entry into the spreadsheet;
validating if the user-provided data entry meets the one or more requirements of the web service metadata without an additional query to the REST-compliant web service;
backend validating, using the REST-compliant web service, if the user-provided data entry meets one or more requirements specified by the REST-compliant web service but not specified by the web service metadata, wherein the backend validating is initiated by a user-provided input; and
indicating an invalid data entry on the spreadsheet if the user-provided data entry does not meet one or more of the one or more requirements of the web service metadata.
8. The computer-readable storage medium of claim 7 , wherein validating the user-provided data entry occurs without being initiated by user-provided input.
9. The computer-readable storage medium of claim 7 , further comprising indicating a valid data entry if the user-provided data entry meets the one or more requirements of the web service metadata.
10. The computer-readable storage medium of claim 7 , further comprising indicating mandatory fields in the spreadsheet based on the web service metadata.
11. The computer-readable storage medium of claim 7 , further comprising indicating, by the visual feature, at least one read-only field in the spreadsheet based on the web service metadata.
12. The computer-readable storage medium of claim 7 , wherein a message about the backend validation of the user-provided data entry is shown next to the user-provided data entry in the spreadsheet.
13. The computer-readable storage medium of claim 7 , wherein a backend validation message about the user-provided data entry is shown in a status window.
14. An apparatus comprising:
one or more processors; and
logic encoded in one or more non-transitory computer-readable storage media for execution by the one or more processors and when executed operable to perform operations comprising:
making a request, by a client device, for web service metadata from a representational state transfer (REST)-compliant web service, wherein data is populated into different fields of a spreadsheet sourced by various databases that pass such data through the REST-compliant web service;
determining one or more requirements of the REST-compliant web service based on the web service metadata, the one or more requirements including one or more of a field is required, a field is read-only, or a particular data type is needed, wherein at least one of the one or more requirements is indicated by a visual feature of a respective column on a spreadsheet;
accepting a user-provided data entry into the spreadsheet;
validating if the user-provided data entry meets the one or more requirements of the web service metadata without an additional query to the REST-compliant web service;
backend validating, using the REST-compliant web service, if the user-provided data entry meets one or more requirements specified by the REST-compliant web service but not specified by the web service metadata, wherein the backend validating is initiated by a user-provided input; and
indicating an invalid data entry if the user-provided data entry does not meet one or more of the one or more requirements of the web service metadata.
15. The apparatus of claim 14 , wherein the operations further comprise indicating, by the visual feature, at least one read-only field in the spreadsheet based on the web service metadata.