Page Comparison

...

2. The "Create Data Service" page appears. Fill in the fields and click "Next" . The Data Service name is mandatory.

Image RemovedImage Added

3. The "Data Sources" page appears. Click on the "Add New Data Source" link and add your Data Source details. Select the data source type as "Google Spread Sheet ".

...

If the spread sheet is Private, you will be prompted to enter the user name and the password. For example,

Image RemovedImage Added

Click "Save" . You have added a Data Source to your Web Service. Click "Next" to proceed.

...

Click on "Main Configuration" once you enter the output mappings and "Save" the query details. For information on adding validations to input mappings in the query, if any, refer to section Input Validators . Detailed information on writing queries can be found in section Data Service Queries.

5. After saving, the added data source page appears. You can edit or delete the Data Source. To proceed click "Next ".

Image RemovedImage Added

6. The "Operations" page appear s. Click the "Add new operation" link to c reate an operation. Select a query to be executed when this operation is called. For example,

Image RemovedImage Added

Click "Save" once done.

...

8. You will be navigated to the "Deployed Services" page .

Image RemovedImage Added

From here, you can manage your data service. For instructions, refer to section Service Management . For a demonstration on the usage of Google Spreadsheets as a data source, refer to Google Spreadsheet Sample . 

Google Data Sources in Query Mode

Anchor
Q Q

...

2. The "Create Data Service" page appears. Fill in the fields and click "Next" . The Data Service name is mandatory.

Image RemovedImage Added

3. The "Data Sources" page appears. Click on the "Add New Data Source" link and add your Data Source details. Select the data source type as "Google Spread Sheet ". Make sure you select the "Use Query Mode" check box.

...

If the spread sheet is Private, you will be prompted to enter the user name and the password. For example,

Image Removed

 Image Added

4. The "Queries" page appears. 

Initially your service does not include any queries. Click on "Add New Query" to add a new query, input/output mappings, events etc. to your Data Service. Enter query details according to the structure of the response you want.

Currently, the Query Mode supports only basic SELECT, INSERT, UPDATE and DELETE queries. Nested queries are not supported at the moment but will be facilitated in an upcoming release. For more information, refer to supported queries .

5. Once done, click "Next" to add operations.

6. Click on "Add Operation", and enter a name to the operation. Select the created query from the drop down list and click on "Add Query Params as Operation Params" to add the parameters to operation. Now save the operation. For example,

Image Removed

 Image Added

Queries Supported in the 'Query' Mode

Anchor
supQ supQ

Currently, only basic SELECT, INSERT, UPDATE and DELETE queries are supported by the 'Query' mode. Shown below are few example queries.

Sample 1:

SELECT customerNumber, customerName, phone, state, country
FROM customers

Image Added

Sample 2:

INSERT INTO customers (customerNumber, customerName, contactLastName)
VALUES(?,?,?)

Image Added

Sample 3:

UPDATE customers
SET contactFirstName=?, contactLastName=?
WHERE customerNumber=?

Image Added

Sample 4:

DELETE FROM customers
WHERE customerNumber=?

Image Added

You can also create new sheets in the Excel or drop existing sheets.

Sample 5:

CREATE SHEET ProductCategories (ProductCode, Category)

Image Added

Sample 6:

DROP SHEET ProductCategories

Image Added