Overview
Configuration is provided for establishing connections with Google AppSheet REST service. The configuration is used in the REST Connection Manager.
Setup
Press icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
In this task, we will show you step-by-step how to create a connection to Google AppSheet REST API using COZYROC's REST Connection Manager.
Congratulations! You have now established a connection to your Google AppSheet instance.
In this guide, we will show how to read data from the Google AppSheet service resource using the COZYROC REST Source component.
Step 3. Double click on the "REST Source" component and select Google AppSheet connection from the combo. Select your desired table from available Google AppSheet resources listed in the second combo below.
query parameter is required. Optionally you can include selector parameter in the grid below if needed.
In this guide, we will show how to write data to the Google AppSheet service table using the COZYROC REST Destination component.
Step 3. Double click on the "REST Destination" component and select Google AppSheet connection from the combo. Also, select resource action and Google AppSheet resource or table you want to work on. In the Grid below specify the properties parameter in JSON format. Visit this url https://support.google.com/appsheet/answer/10104797?hl=en&ref_topic=10105767
to find out details about the Properties that will be added to the request. Below is the sample JSOn for properties parameter.
Note : Specify Action Find in the properties JSON as mention in below Payload.
{"Action": "Find","Properties": { "Locale": "en-US", "Location": "47.623098, -122.330184", "Timezone": "Pacific Standard Time", "UserSettings": { "Option 1": "value1", "Option 2": "value2" }}}
Configuration
Base URL address: https://api.appsheet.com/api/v2/apps/[AppId]
.
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- AccessKey: Required. Specify application access key.
The following request parameters will be automatically processed during the authentication process:
-
ApplicationAccessKey:
{{=connection.user.AccessKey}}
- [Read] action
-
Endpoint URL address:
/tables/{{=resource.external.name}}/Action
.
The result is extracted from:{{=response.Rows}}
.
The action uses POST method.The action has the following user-defined parameters:
- Properties: Please specify the Properties in JSON format. Optional.
- Selector: Please specify the Selector property. Optional.
The following request parameters will be automatically processed:
-
application/json:
{{={ Action: 'Find', Properties: _.extend(JSON.parse(parameters.get('Properties', '{}')), { Selector: parameters.get('Selector') }), } }}
Documentation: https://support.google.com/appsheet/answer/10105770?hl=en&ref_topic=10105767.
- [Create] action
-
Endpoint URL address:
/tables/{{=resource.external.name}}/Action
.
The result is extracted from:{{=undefined}}
.The action has the following user-defined parameters:
- Properties: Please specify the properties in JSON format. Optional.
The following request parameters will be automatically processed:
-
application/json:
{{=AppSheet.getActionQuery('Add', parameters, batch)}}
Documentation: https://support.google.com/appsheet/answer/10104797?hl=en&ref_topic=10105767.
- [Update] action
-
Endpoint URL address:
/tables/{{=resource.external.name}}/Action
.
The result is extracted from:{{=undefined}}
.The action has the following user-defined parameters:
- Properties: Please specify the properties in JSON format. Optional.
The following request parameters will be automatically processed:
-
application/json:
{{=AppSheet.getActionQuery('Edit', parameters, batch)}}
Documentation: https://support.google.com/appsheet/answer/10105002?hl=en&ref_topic=10105767.
- [Delete] action
-
Endpoint URL address:
/tables/{{=resource.external.name}}/Action
.
The result is extracted from:{{=undefined}}
.The action has the following user-defined parameters:
- Properties: Please specify the properties in JSON format. Optional.
The following request parameters will be automatically processed:
-
application/json:
{{=AppSheet.getActionQuery('Delete', parameters, batch)}}
Documentation: https://support.google.com/appsheet/answer/10105399?hl=en&ref_topic=10105767.
- [External]
-
The external fields URL address:
/tables/{{=resource.external.name}}/Action
. The external fields list is extracted from:{{=_.map(response[0] || {}, function(v, k) { return { name: k }; })}}
.- {{=external.name}}
Template: ShortText. ( length 255 )
The external resource list URL address: /tables
.
The external resource list is extracted from: {{=response.Tables}}
.
Based on resource template Base.
- [Read] action
-
The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
_includeUserParameters:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
application/json:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
application/json:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
application/json:
{{=item}}
-
_includeUserParameters:
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Date
Data type: DT_DBDATE
Knowledge Base
What's New
- New: Introduced connection.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.