[Download] | [Documentation Home] | [Release Note]

Google Spreadsheet Sample

Introduction

An often used data sharing format in the internet is using Google Spreadsheet. WSO2 Data Services Server contains support for using a Google Spreadsheet as a data source.

Prerequisites

The sample data service "GSpreadSample" should be deployed as per the instructions mentioned in Deploying Samples section.

Running the Sample

The sample service can be run using the "tryit" tool, which is bundled with WSO2 Data Services Server, or a code-generated java client sample using this service is demonstrated in the Data Services Clients Sample section.

Google Spreadsheet Contents

The spreadsheet contains data about the customers of a specific company.

Service Definition

The GSpread sample service contains a single operation named "getCustomers" which returns all the customer information that are stored in the google spreadsheet. There is also a resource defined as "customers", which can be accessed with the following URL, http://localhost:9763/services/GSpreadSample.HTTPEndpoint/customers.

Sample Run

A sample run of the service using the "tryit" tool is shown below.


Figure 1: Google Spreadsheet data source based service invocation.