Editable table in a spreadsheet integrated with a web service
Implementations generally relate to an editable table in a spreadsheet integrated with a web service. In some implementations, a method includes obtaining web service metadata from a web service. The method further includes determining one or more capabilities of the web service based on the web service metadata. The method further includes configuring a table component in a spreadsheet based on the one or more capabilities and the web service metadata. The method further includes retrieving data from the web service. The method further includes converting the data to a predetermined format. The method further includes tracking data changes in the spreadsheet based on user input. The method further includes sending the data changes from the spreadsheet to the web service.
1. A non-transitory computer-readable storage medium carrying program instructions thereon, the program instructions when executed by one or more processors of a client computing device cause the one or more processors to perform operations comprising:
obtaining web service metadata from a web service;
determining spreadsheet attributes of the web service based on the web service metadata;
configuring, by the client computing device, a table component in the spreadsheet based on the spreadsheet attributes;
retrieving, by the client computing device, data from the web service including a data value in a web service encoded format;
converting, by the client computing device, the data value to a corresponding display value in a spreadsheet encoding format by using mappings of display values to data values, wherein the mappings are stored in the spreadsheet;
converting, by the client computing device, user inputted data changes of the display value in the spreadsheet, to a corresponding data value in the web service encoded format by using the mappings; and
sending the converted data changes from the spreadsheet to the web service.
2. The computer-readable storage medium of claim 1 , wherein the corresponding data value is a non-human readable format and the display value is a human readable format.
3. The computer-readable storage medium of claim 1 , wherein the mappings are stored in a hidden worksheet of the spreadsheet.
4. The computer-readable storage medium of claim 1 , wherein the data from the web service is sourced from a plurality of databases to the web service for populating fields of the spreadsheet.
5. The computer-readable storage medium of claim 4 , wherein the web service is a representational state transfer (REST) service.
6. The computer-readable storage medium of claim 1 , wherein the mappings include that at least two display values are mapped to a single data value.
7. The computer-readable storage medium of claim 1 , wherein the table component maps attributes, fields, and associated properties with columns and cells of the spreadsheet.
8. A computer-implemented method for editing a spreadsheet by a client computing device, the method comprising:
obtaining web service metadata from a web service;
determining spreadsheet attributes of the web service based on the web service metadata;
configuring, by the client computing device, a table component in the spreadsheet based on the spreadsheet attributes;
retrieving, by the client computing device, data from the web service including a data value in a web service encoded format;
converting, by the client computing device, the data value to a corresponding display value in a spreadsheet encoding format by using mappings of display values to data values, wherein the mappings are stored in the spreadsheet;
converting, by the client computing device, user inputted data changes of the display value in the spreadsheet, to a corresponding data value in the web service encoded format by using the mappings; and
sending the converted data changes from the spreadsheet to the web service.
9. The method of claim 8 , wherein the corresponding data value is a non-human readable format and the display value is a human readable format.
10. The method of claim 8 , wherein the mappings are stored in a hidden worksheet of the spreadsheet.
11. The method of claim 8 , wherein the data from the web service is sourced from a plurality of databases to the web service for populating fields of the spreadsheet.
12. The method of claim 11 , wherein the web service is a representational state transfer (REST) service.
13. The method of claim 8 , wherein the mappings include that at least two display values are mapped to a single data value.
14. The method of claim 8 , wherein the table component maps attributes, fields, and associated properties with columns and cells of the spreadsheet.
15. A system comprising:
one or more processors of a client computing device; 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:
obtaining web service metadata from a web service;
determining spreadsheet attributes of the web service based on the web service metadata;
configuring, by the client computing device, a table component in the spreadsheet based on the spreadsheet attributes;
retrieving, by the client computing device, data from the web service including a data value in a web service encoded format;
converting, by the client computing device, the data value to a corresponding display value in a spreadsheet encoding format by using mappings of display values to data values, wherein the mappings are stored in the spreadsheet;
converting, by the client computing device, user inputted data changes of the display value in the spreadsheet, to a corresponding data value in the web service encoded format by using the mappings; and
sending the converted data changes from the spreadsheet to the web service.
16. The system of claim 15 , wherein the corresponding data value is a non-human readable format and the display value is a human readable format.
17. The system of claim 15 , wherein the mappings are stored in a hidden worksheet of the spreadsheet.
18. The system of claim 15 , wherein the web service is a representational state transfer (REST) service and the data from the web service is sourced from a plurality of databases to the REST web service for populating fields of the spreadsheet.
19. The system of claim 15 , wherein the mappings include that at least two display values are mapped to a single data value.
20. The system of claim 15 , wherein the table component maps attributes, fields, and associated properties with columns and cells of the spreadsheet.