Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

...

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

Image RemovedImage Added

Info

For more information on 'Advanced Configurations' in creating data servicesadvanced configurations, refer to section Transaction Handling   Advanced Data Service Configurations.

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

Info

For more information on 'Advanced Configurations' in creating data servicesadvanced configurations, refer to section Transaction Handling   Advanced Data Service Configurations.

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 RemovedImage Added

4. The "Queries" page appears.

...

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 RemovedImage Added

Queries Supported in the 'Query' Mode
Anchor
supQ
supQ

...