...
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 GSpreadSample should be deployed using the instructions in Samples Setupshould 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/dataservicesfolder. 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.
...
- 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 "getProductsgetCustomers" operation and click Send to execute the request. You will get a product list the customer details in the response as shown below.
