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
.
- OAuth
-
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
Field components:
-
Uses template:
ShortText
. - Contains the following components: gid, name.
-
Uses template:
- [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}}
-
_includeUserParameters:
{{=parameters}}
-
limit:
- [Create] action
-
The result is extracted from:{{=response.data}}
.
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
item:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The result is extracted from:{{=response.data}}
.
The action uses PUT method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
item:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}}
-
_includeUserParameters:
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:
- gid
A key field. Data type: DT_UI8
- name
Template: ShortText.
- content
Data type: DT_IMAGE The value is gathered from
{{=connection.execute({ url: '/attachments/' + item.gid }).data.download_url}}
address.- taskId
Data type: DT_UI8
- [Read] action
-
Endpoint URL address:
/events
.
The result is paginated.The action has the following user-defined parameters:
- resource: Required. Specify resource id.
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.
For further information check here.
- [Read teamId] action
-
Endpoint URL address:
/teams/{{=parameters.teamId}}/projects
.The action has the following user-defined parameters:
- teamId: Required. Specify team identifier.
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.
The following request parameters will be automatically processed:
-
type:
project
-
count:
100
-
query:
{{=parameters.typeahead}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/projects
.For further information check here.
- [Update] action
-
Endpoint URL address:
/projects/{{=item.gid}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/projects/{{=item.gid}}
.For further information check here.
- gid
A key field. Data type: DT_UI8
- name
Template: ShortText.
- tasks
The value is gathered from
/projects/{{=item.gid}}/tasks
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
-
Uses template:
ShortRef
.
- sections
The value is gathered from
/projects/{{=item.gid}}/sections
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
-
Uses template:
ShortRef
.
- task_counts
The value is gathered from
/projects/{{=item.gid}}/task_counts
address. The gathered value is processed with{{=response.data}}
expression. Field components:- Contains the following components: num_completed_milestones, num_completed_tasks, num_incomplete_milestones, num_incomplete_tasks, num_milestones, num_tasks.
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.gid}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/sections/{{=item.gid}}
.For further information check here.
- gid
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.
For further information check here.
- [Create] action
-
Endpoint URL address:
/tasks/{{=item.target}}/stories
.For further information check here.
- [Update] action
-
Endpoint URL address:
/stories/{{=item.gid}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/stories/{{=item.gid}}
.For further information check here.
- gid
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}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/tags
.For further information check here.
- [Update] action
-
Endpoint URL address:
/tags/{{=item.gid}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/tags/{{=item.gid}}
.For further information check here.
- gid
A key field. Data type: DT_UI8
- name
Template: ShortText.
- tasks
The value is gathered from
/tags/{{=item.gid}}/tasks
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
-
Uses template:
ShortRef
.
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.
For further information check here.
- [Read tagId] action
-
Endpoint URL address:
/tags/{{=parameters.tagId}}/tasks
.The action has the following user-defined parameters:
- tagId: Required. Specify tag identifier.
For further information check here.
- [Read sectionId] action
-
Endpoint URL address:
/sections/{{=parameters.sectionId}}/tasks
.The action has the following user-defined parameters:
- sectionId: Required. Specify section identifier.
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:
task
-
count:
100
-
query:
{{=parameters.typeahead}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/tasks
.For further information check here.
- [Update] action
-
Endpoint URL address:
/tasks/{{=item.gid}}
.For further information check here.
- [Delete] action
-
Endpoint URL address:
/tasks/{{=item.gid}}
.For further information check here.
- gid
A key field. Data type: DT_UI8
- name
Template: ShortText.
- subtasks
A read-only field. The value is gathered from
/tasks/{{=item.gid}}/subtasks
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
-
Uses template:
ShortRef
.
- stories
A read-only field. The value is gathered from
/tasks/{{=item.gid}}/stories
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
-
Uses template:
ShortRef
.
- projects
The value is gathered from
/tasks/{{=item.gid}}/projects
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
-
Uses template:
ShortRef
.
- tags
The value is gathered from
/tasks/{{=item.gid}}/tags
address. The gathered value is processed with{{=response.data}}
expression. Field components:- An array.
-
Uses template:
ShortRef
.
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.
For further information check here.
- [Read userId] action
-
Endpoint URL address:
/users/{{=parameters.userId}}/teams
.The action has the following user-defined parameters:
- userId: Required. Specify user identifier.
For further information check here.
- gid
A key field. Data type: DT_UI8
- name
Template: ShortText.
- users
The value is gathered from
/teams/{{=item.gid}}/users
address. Field components:- An array.
-
Uses template:
ShortRef
.
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.
For further information check here.
- [Read teamId] action
-
Endpoint URL address:
/teams/{{=parameters.teamId}}/users
.The action has the following user-defined parameters:
- teamId: Required. Specify team identifier.
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:
user
-
count:
100
-
query:
{{=parameters.typeahead}}
For further information check here.
- [Create] action
-
Endpoint URL address:
/workspaces/{{=item.workspaceId}}/addUser
.The following request parameters will be automatically processed:
-
user:
{{=item.name}}
For further information check here.
-
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}}
For further information check here.
-
user:
- gid
A key field. Data type: DT_UI8
- name
Template: ShortText.
- workspaceId
A key field. Data type: DT_UI8
- workspace_memberships
The value is gathered from
/users/{{=item.gid}}/workspace_memberships
address. Field components:- An array.
- Contains the following components: gid, user, workspace.
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.gid}}
.For further information check here.
- gid
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.gid}}
.For further information check here.
- gid
A key field. Data type: DT_UI8
- name
Template: ShortText.
- is_organization
Data type: DT_BOOL
- workspace_memberships
The value is gathered from
/workspaces/{{=item.gid}}/workspace_memberships
address. Field components:- An array.
- Contains the following components: gid, user, workspace.
What's New
- Fixed: Various fixes and improvements (Thank you, Stewart).
- Fixed: Incorrect identifier field definition (Thank you, Stan).
- 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.