Overview
Configuration is provided for establishing connections with the Google Tasks 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.
Configuration
Base URL address: https://www.googleapis.com/tasks/v1
.
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}
.The authentication has the following user-defined parameters:
- Scope:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
Documentation: https://developers.google.com/google-apps/tasks/auth.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/@me/lists
.Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasklists/list.
- [Create] action
-
Endpoint URL address:
/users/@me/lists
.Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasklists/insert.
- [Update] action
-
Endpoint URL address:
/users/@me/lists/{{=item.id}}
.Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasklists/update.
- [Delete] action
-
Endpoint URL address:
/users/@me/lists/{{=item.id}}
.Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasklists/delete.
- id
A key field. Template: ShortText.
- title
Template: ShortText.
- selfLink
Template: LongText. A read-only field.
- updated
Template: DateTime. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/lists/{{=parameters.taskListId}}/tasks
.The action has the following user-defined parameters:
- taskListId: Required. Specifies task list identifier.
Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasks/list.
- [Create] action
-
Endpoint URL address:
/lists/{{=item.taskListId}}/tasks
.Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasks/insert.
- [Update] action
-
Endpoint URL address:
/lists/{{=item.taskListId}}/tasks/{{=item.id}}
.Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasks/update.
- [Delete] action
-
Endpoint URL address:
/lists/{{=item.taskListId}}/tasks/{{=item.id}}
.Documentation: https://developers.google.com/google-apps/tasks/v1/reference/tasks/delete.
- id
A key field. Template: ShortText.
- title
Template: ShortText.
- updated
Template: DateTime. A read-only field.
- selfLink
Template: LongText. A read-only field.
- parent
Template: ShortText. The value is sent to
/lists/{{=item.taskListId}}/tasks/{{=item.id}}/move
address.- position
Template: ShortText. The value is sent to
/lists/{{=item.taskListId}}/tasks/{{=item.id}}/move
address.- notes
Template: LongText.
- status
Template: ShortText.
- due
Template: DateTime.
- completed
Template: DateTime.
- deleted
Data type: DT_BOOL
- hidden
Data type: DT_BOOL
- links
An array field. Field components:
-
Uses template:
ShortText
. - Contains the following components: type, description, link.
-
Uses template:
- taskListId
Template: ShortText.
- [Read] action
-
The result is extracted from:{{=response.items}}
.
The result is paginated.The following request parameters will be automatically processed:
-
pageToken:
{{=parameters.iterator}}
-
maxResults:
{{=parameters.batchSize}}
-
fields:
nextPageToken, items({{=_.without(parameters.fields, 'taskListId').join()}})
-
_includeUserParameters:
{{=parameters}}
-
pageToken:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
application/json:
- [Delete] action
-
The action uses DELETE method.
- kind
Template: ShortText. A read-only field.
- etag
Template: ShortText. A read-only field.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
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.