Asana Connection
Overview
Configuration is provided for establishing connections with the Asana 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://app.asana.com/api/1.0.
- Token
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}.The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
-
Authorization:
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- ShortRef
Contains the following components: id, name.
- [Read] action
-
The result is extracted from:{{=response.data}}.
The result is paginated.The following request parameters will be automatically processed:
-
limit:
{{=parameters.batchSize}} -
offset:
{{=parameters.iterator}} -
params:
{{=parameters}}
-
limit:
- [Create] action
-
The result is extracted from:{{=response.data}}.
The action uses POST method.The following request parameters will be automatically processed:
-
params:
{{=parameters}} -
item:
{{=item}}
-
params:
- [Update] action
-
The result is extracted from:{{=response.data}}.
The action uses PUT method.The following request parameters will be automatically processed:
-
params:
{{=parameters}} -
item:
{{=item}}
-
params:
- [Delete] action
-
The action uses DELETE method.The following request parameters will be automatically processed:
-
params:
{{=parameters}}
-
params:
Based on resource template Base.
- [ Read taskId] action
-
Endpoint URL address:
/tasks/{{=parameters.taskId}}/attachments.The action has the following user-defined parameters:
- taskId: Required. Specify task identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/tasks/{{=item.taskId}}/attachments.The following request parameters will be automatically processed:
-
attachment:
{{=item.content}}
For further information check here.
-
attachment:
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
- content
Data type: DT_IMAGE
- taskId
Data type: DT_UI8
- [ Read projectId] action
-
Endpoint URL address:
/project/{{=parameters.projectId}}/events.
The result is paginated.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
The following request parameters will be automatically processed:
-
sync:
{{=parameters.iterator}}
For further information check here.
- [ Read taskId] action
-
Endpoint URL address:
/task/{{=parameters.taskId}}/events.
The result is paginated.The action has the following user-defined parameters:
- taskId: Required. Specify task identifier.
The following request parameters will be automatically processed:
-
sync:
{{=parameters.iterator}}
For further information check here.
- user
Template: ShortRef.
- resource
Template: ShortRef.
- type
Template: ShortText.
- action
Template: ShortText.
- parent
Template: ShortRef.
- created_at
Template: DateTime.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/projects.For further information check here.
- [ Read workspaceId] action
-
Endpoint URL address:
/workspaces/{{=parameters.workspaceId}}/projects.The action has the following user-defined parameters:
- workspaceId: Required. Specify workspace identifier.
- [ Read teamId] action
-
Endpoint URL address:
/teams/{{=parameters.teamId}}/projects.The action has the following user-defined parameters:
- teamId: Required. Specify team identifier.
- [ Read typeahead] action
-
Endpoint URL address:
/workspaces/{{=parameters.workspaceId}}/typeahead.The action has the following user-defined parameters:
- workspaceId: Required. Specify workspace identifier.
- typeahead: Required. Specify typeahead query.
The following request parameters will be automatically processed:
-
type:
project -
count:
100 -
query:
{{=parameters.typeahead}}
- [Create] action
-
Endpoint URL address:
/projects.For further information check here.
- [Update] action
-
Endpoint URL address:
/projects/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/projects/{{=item.id}}.For further information check here.
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
- tasks
Template: ShortRef. An array field.
- sections
Template: ShortRef. An array field.
Based on resource template Base.
- [ Read projectId] action
-
Endpoint URL address:
/projects/{{=parameters.projectId}}/sections.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/projects/{{=item.project}}/sections.For further information check here.
- [Update] action
-
Endpoint URL address:
/sections/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sections/{{=item.id}}.For further information check here.
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
Based on resource template Base.
- [ Read taskId] action
-
Endpoint URL address:
/tasks/{{=parameters.taskId}}/stories.The action has the following user-defined parameters:
- taskId: Required. Specify task identifier.
- [Create] action
-
Endpoint URL address:
/tasks/{{=item.target}}/stories.For further information check here.
- id
A key field. Data type: DT_UI8
- created_at
Template: DateTime. A read-only field.
- created_by
Template: ShortRef. A read-only field.
- text
Template: LongText.
- type
Template: ShortText. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/tags.For further information check here.
- [ Read typeahead] action
-
Endpoint URL address:
/workspaces/{{=parameters.workspaceId}}/typeahead.The action has the following user-defined parameters:
- workspaceId: Required. Specify workspace identifier.
- typeahead: Required. Specify typeahead query (alias for "query").
The following request parameters will be automatically processed:
-
type:
tag -
count:
100 -
query:
{{=parameters.typeahead}}
- [Create] action
-
Endpoint URL address:
/tags.For further information check here.
- [Update] action
-
Endpoint URL address:
/tags/{{=item.id}}.For further information check here.
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
- tasks
Template: ShortRef. An array field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/tasks.For further information check here.
- [ Read projectId] action
-
Endpoint URL address:
/projects/{{=parameters.projectId}}/tasks.The action has the following user-defined parameters:
- projectId: Required. Specify project identifier.
- [ Read tagId] action
-
Endpoint URL address:
/tags/{{=parameters.tagId}}/tasks.The action has the following user-defined parameters:
- tagId: Required. Specify tag identifier.
- [ Read sectionId] action
-
Endpoint URL address:
/sections/{{=parameters.sectionId}}/tasks.The action has the following user-defined parameters:
- sectionId: Required. Specify section identifier.
- [ Read typeahead] action
-
Endpoint URL address:
/workspaces/{{=parameters.workspaceId}}/typeahead.The action has the following user-defined parameters:
- workspaceId: Required. Specify workspace identifier.
- typeahead: Required. Specify typeahead query (alias for "query").
The following request parameters will be automatically processed:
-
type:
task -
count:
100 -
query:
{{=parameters.typeahead}}
- [Create] action
-
Endpoint URL address:
/tasks.For further information check here.
- [Update] action
-
Endpoint URL address:
/tasks/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/tasks/{{=item.id}}.For further information check here.
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
- subtasks
Template: ShortRef. An array field. A read-only field.
- stories
Template: ShortRef. An array field. A read-only field.
- projects
Template: ShortRef. An array field.
- tags
Template: ShortRef. An array field.
Based on resource template Base.
- [ Read organizationId] action
-
Endpoint URL address:
/organizations/{{=parameters.organizationId}}/teams.The action has the following user-defined parameters:
- organizationId: Required. Specify organization identifier.
- [ Read userId] action
-
Endpoint URL address:
/users/{{=parameters.userId}}/teams.The action has the following user-defined parameters:
- userId: Required. Specify user identifier.
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
- users
Template: ShortRef. An array field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users.For further information check here.
- [ Read workspaceId] action
-
Endpoint URL address:
/workspaces/{{=parameters.workspaceId}}/users.The action has the following user-defined parameters:
- workspaceId: Required. Specify workspace identifier.
- [ Read teamId] action
-
Endpoint URL address:
/teams/{{=parameters.teamId}}/users.The action has the following user-defined parameters:
- teamId: Required. Specify team identifier.
- [ Read typeahead] action
-
Endpoint URL address:
/workspaces/{{=parameters.workspaceId}}/typeahead.The action has the following user-defined parameters:
- workspaceId: Required. Specify workspace identifier.
- typeahead: Required. Specify typeahead query (alias for "query").
The following request parameters will be automatically processed:
-
type:
user -
count:
100 -
query:
{{=parameters.typeahead}}
- [Create] action
-
Endpoint URL address:
/workspaces/{{=item.workspaceId}}/addUser.The following request parameters will be automatically processed:
-
user:
{{=item.name}}
-
user:
- [Delete] action
-
Endpoint URL address:
/workspaces/{{=item.workspaceId}}/removeUser.
The action uses POST method.The following request parameters will be automatically processed:
-
user:
{{=item.name}}
-
user:
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
- workspaceId
A key field. Data type: DT_UI8
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/webhooks.For further information check here.
- [Create] action
-
Endpoint URL address:
/webhooks.For further information check here.
- [Delete] action
-
Endpoint URL address:
/webhooks/{{=item.id}}.For further information check here.
- id
A key field. Data type: DT_UI8
- resource
Template: ShortRef. A read-only field.
- target
Template: ShortText. A read-only field.
- active
Data type: DT_BOOL
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/workspaces.For further information check here.
- [Update] action
-
Endpoint URL address:
/workspaces/{{=item.id}}.For further information check here.
- id
A key field. Data type: DT_UI8
- name
Template: ShortText.
- is_organization
Data type: DT_BOOL
What's New
- New: Introduced connection.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.