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. 

1. Log in to the management console and select Upload under Data Service menu.
2. Select the GSpreadSample.dbs file from the <DSS_HOME>/samples/dbs/gspread/ folder and click Upload. 
3. 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:

1. Log in to the management console of your server and click List under Services in the navigator. The GSpreadSample will be listed here.
2. Click Try this service to open the TryIt tool.
3. Select the "getProducts" operation and click Send to execute the request. You will get the customer details in the response as shown below.