Asana Connector
Documentation
Version: 1
Documentation
Endpoint

Get Tasks

Name

get_tasks

Description

Related Tables

Tasks

Parameters

Parameter Label Required Options Description
QueryBy QueryBy YES
Option Value
project project
tag tag
section section
user_task_list user_task_list
assignee_and_workspace assignee_and_workspace
ProjectId Project Id NO The project to filter tasks on.
WorkspaceId Workspace Id NO The workspace to filter tasks on. Note: If you specify workspace, you must also specify the assignee to filter on.
AssigneeId Assignee Id NO The assignee to filter tasks on. If searching for unassigned tasks, assignee.any = null can be specified. Note: If you specify assignee, you must also specify the workspace to filter on.
SectionId Section Id NO The section to filter tasks on.
TagId Tag Id NO
UserTaskListId UserTaskListId NO
CompletedSince Completed Since NO
Option Value
2023-12-31 2023-12-31
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
now-24h now-24h
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Only return tasks that are either incomplete or that have been completed since this time.
ModifiedSince Modified Since NO
Option Value
2023-12-31 2023-12-31
2023-12-31T00:00:00 2023-12-31T00:00:00
now now
now-24h now-24h
today today
yesterday yesterday
yearstart-10y yearstart-10y
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
monthend+1d-1y monthend+1d-1y
Only return tasks that have been modified since the given time. Note: A task is considered “modified” if any of its properties change, or associations between it and other objects are modified (e.g. a task being added to a project). A task is not considered modified just because another object it is associated with (e.g. a subtask) is modified. Actions that count as modifying the task include assigning, renaming, completing, and adding stories.
Fields Fields NO
Option Value
actual_time_minutes actual_time_minutes
subtasks subtasks
approval_status approval_status
assignee assignee
assignee.name assignee.name
assignee_section assignee_section
assignee_section.name assignee_section.name
assignee_status assignee_status
completed completed
completed_at completed_at
completed_by completed_by
completed_by.name completed_by.name
created_at created_at
created_by created_by
created_by.name created_by.name
custom_fields custom_fields
custom_fields.asana_created_field custom_fields.asana_created_field
custom_fields.created_by custom_fields.created_by
custom_fields.created_by.name custom_fields.created_by.name
custom_fields.currency_code custom_fields.currency_code
custom_fields.custom_label custom_fields.custom_label
custom_fields.custom_label_position custom_fields.custom_label_position
custom_fields.date_value custom_fields.date_value
custom_fields.date_value.date custom_fields.date_value.date
custom_fields.date_value.date_time custom_fields.date_value.date_time
custom_fields.description custom_fields.description
custom_fields.display_value custom_fields.display_value
custom_fields.enabled custom_fields.enabled
custom_fields.enum_options custom_fields.enum_options
custom_fields.enum_options.color custom_fields.enum_options.color
custom_fields.enum_options.enabled custom_fields.enum_options.enabled
custom_fields.enum_options.name custom_fields.enum_options.name
custom_fields.enum_value custom_fields.enum_value
custom_fields.enum_value.color custom_fields.enum_value.color
custom_fields.enum_value.enabled custom_fields.enum_value.enabled
custom_fields.enum_value.name custom_fields.enum_value.name
custom_fields.format custom_fields.format
custom_fields.has_notifications_enabled custom_fields.has_notifications_enabled
custom_fields.id_prefix custom_fields.id_prefix
custom_fields.is_formula_field custom_fields.is_formula_field
custom_fields.is_global_to_workspace custom_fields.is_global_to_workspace
custom_fields.is_value_read_only custom_fields.is_value_read_only
custom_fields.multi_enum_values custom_fields.multi_enum_values
custom_fields.multi_enum_values.color custom_fields.multi_enum_values.color
custom_fields.multi_enum_values.enabled custom_fields.multi_enum_values.enabled
custom_fields.multi_enum_values.name custom_fields.multi_enum_values.name
custom_fields.name custom_fields.name
custom_fields.number_value custom_fields.number_value
custom_fields.people_value custom_fields.people_value
custom_fields.people_value.name custom_fields.people_value.name
custom_fields.precision custom_fields.precision
custom_fields.representation_type custom_fields.representation_type
custom_fields.resource_subtype custom_fields.resource_subtype
custom_fields.text_value custom_fields.text_value
custom_fields.type custom_fields.type
dependencies dependencies
dependents dependents
due_at due_at
due_on due_on
external external
external.data external.data
followers followers
followers.name followers.name
hearted hearted
hearts hearts
hearts.user hearts.user
hearts.user.name hearts.user.name
html_notes html_notes
is_rendered_as_separator is_rendered_as_separator
liked liked
likes likes
likes.user likes.user
likes.user.name likes.user.name
memberships memberships
memberships.project memberships.project
memberships.project.name memberships.project.name
memberships.section memberships.section
memberships.section.name memberships.section.name
modified_at modified_at
name name
notes notes
num_hearts num_hearts
num_likes num_likes
num_subtasks num_subtasks
parent parent
parent.created_by parent.created_by
parent.name parent.name
parent.resource_subtype parent.resource_subtype
permalink_url permalink_url
projects projects
projects.name projects.name
resource_subtype resource_subtype
start_at start_at
start_on start_on
tags tags
tags.name tags.name
workspace workspace
workspace.name workspace.name
Limit Limit NO Results per page. The number of objects to return per page. The value must be between 1 and 100.

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_WSTR nvarchar(50) 50 False
Name DT_WSTR nvarchar(255) 255 False
ActualTimeMinutes DT_I4 int False
ApprovalStatus DT_WSTR nvarchar(50) 50 False
AssigneeStatus DT_WSTR nvarchar(50) 50 False
Completed DT_BOOL bit False
CompletedAt DT_DBTIMESTAMP datetime False
CompletedById DT_WSTR nvarchar(50) 50 False
CompletedByName DT_WSTR nvarchar(255) 255 False
CreatedAt DT_DBTIMESTAMP datetime False
CreatedById DT_WSTR nvarchar(50) 50 False
CreatedByName DT_WSTR nvarchar(255) 255 False
Dependencies DT_WSTR nvarchar(500) 500 False
Dependents DT_WSTR nvarchar(500) 500 False
Subtasks DT_NTEXT nvarchar(MAX) False
DueAt DT_DBTIMESTAMP datetime False
DueOn DT_WSTR nvarchar(50) 50 False
ExternalData DT_WSTR nvarchar(100) 100 False
ExternalId DT_WSTR nvarchar(50) 50 False
Hearted DT_BOOL bit False
Hearts DT_WSTR nvarchar(1000) 1000 False
HtmlNotes DT_NTEXT nvarchar(MAX) False
IsRenderedAsSeparator DT_BOOL bit False
Liked DT_BOOL bit False
Likes DT_WSTR nvarchar(1000) 1000 False
Memberships DT_WSTR nvarchar(1000) 1000 False
ModifiedAt DT_DBTIMESTAMP datetime False
Notes DT_WSTR nvarchar(2000) 2000 False
NumHearts DT_I4 int False
NumLikes DT_I4 int False
NumSubtasks DT_I4 int False
ResourceSubtype DT_WSTR nvarchar(50) 50 False
StartAt DT_DBTIMESTAMP datetime False
StartOn DT_WSTR nvarchar(50) 50 False
AssigneeId DT_WSTR nvarchar(50) 50 False
AssigneeName DT_WSTR nvarchar(255) 255 False
AssigneeSectionId DT_WSTR nvarchar(50) 50 False
AssigneeSectionName DT_WSTR nvarchar(255) 255 False
CustomFields DT_NTEXT nvarchar(MAX) False
Followers DT_WSTR nvarchar(500) 500 False
ParentId DT_WSTR nvarchar(50) 50 False
ParentName DT_WSTR nvarchar(255) 255 False
ParentCreatedBy DT_WSTR nvarchar(255) 255 False
ParentResourceSubtype DT_WSTR nvarchar(50) 50 False
PermalinkUrl DT_WSTR nvarchar(500) 500 False
Projects DT_WSTR nvarchar(500) 500 False
Projects1Id DT_WSTR nvarchar(50) 50 False
Projects1Name DT_WSTR nvarchar(255) 255 False
Projects2Id DT_WSTR nvarchar(50) 50 False
Projects2Name DT_WSTR nvarchar(255) 255 False
Projects3Id DT_WSTR nvarchar(50) 50 False
Projects3Name DT_WSTR nvarchar(255) 255 False
Tags DT_WSTR nvarchar(500) 500 False
Tags1Id DT_WSTR nvarchar(50) 50 False
Tags1Name DT_WSTR nvarchar(255) 255 False
Tags2Id DT_WSTR nvarchar(50) 50 False
Tags2Name DT_WSTR nvarchar(255) 255 False
Tags3Id DT_WSTR nvarchar(50) 50 False
Tags3Name DT_WSTR nvarchar(255) 255 False
Tags4Id DT_WSTR nvarchar(50) 50 False
Tags4Name DT_WSTR nvarchar(255) 255 False
Tags5Id DT_WSTR nvarchar(50) 50 False
Tags5Name DT_WSTR nvarchar(255) 255 False
WorkspaceId DT_WSTR nvarchar(50) 50 False
WorkspaceName DT_WSTR nvarchar(255) 255 False
[Dynamic Column] DT_WSTR nvarchar(4000) 4000 False
If the column you are looking for is missing, consider customizing Asana Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Asana Connector in API Source component to read data or in API Destination component to read/write data:

Read from Tasks table using API Destination

This Endpoint belongs to Tasks table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Asana
Tasks
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get tasks 

SELECT * FROM get_tasks
WITH
(
    "QueryBy" = 'project'
)

Read Tasks (default project)

Read all tasks (default project) 

SELECT * FROM Tasks

Read Tasks for a specific project

Read all tasks for a specified project 

SELECT * FROM Tasks WITH (ProjectId='1200652735638082')

get_tasks endpoint belongs to Tasks table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get tasks 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_tasks
WITH
(
    "QueryBy" = ''project''
)';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

Read Tasks (default project)

Read all tasks (default project) 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Tasks';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

Read Tasks for a specific project

Read all tasks for a specified project 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Tasks WITH (ProjectId=''1200652735638082'')';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

get_tasks endpoint belongs to Tasks table(s), and can therefore be used via those table(s).