A data sharing format used often in the Internet is Google Spreadsheet.The WSO2 Data Services Server contains support for Google Spreadsheets as a data source.
About the sample
The spreadsheet contains data about the customers of a specific company. The GSpread sample service contains a single operation named getCustomers which returns all the customer information that is stored in the Google spreadsheet. There is also a resource defined as customers, which can be accessed using the following URL: "http://localhost:9763/services/GSpreadSample.HTTPEndpoint/customers".
See Data Services and Resources for a definition of data services and operations.
Building the sample
The sample data service GSpreadSample should be deployed using the instructions in Samples Setup.
Running the sample
The sample service can be run using the TryIt tool, which is bundled with the WSO2 Data Services Server, or a code-generated java client sample as discussed in the Data Services Clients section.
Follow the steps below to demonstrate this functionality using the TryIt tool:
- Log in to the management console of your server and click List under Services in the navigator. The GSpreadSample will be listed here.
- Click Try this service to open the TryIt tool.
- Select the "getProducts" operation and click Send to execute the request. You will get the customer details in the response as shown below.
