Google Spreadsheet Sample
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 .dbs file of this sample data service should be manually deployed in your server as explained below.Â
- Log in to the management console and select Upload under Data Service menu.
- Select the GSpreadSample.dbs file from theÂ
<DSS_HOME>/samples/dbs/gspread/
 folder and click Upload. - If the file is deployed successfully, the Deployed Services window appears with the new data service listed. Alternatively, copy the file to theÂ
<DSS_HOME>/repository/deployment/server/dataservices
 folder. It will be deployed instantly as hot deployment, which is enabled in Data Services Server by default.
See Creating and Deploying a Configuration File.
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 "getCustomers" operation and click Send to execute the request. You will get the customer details in the response as shown below.
Â