Reference

Endpoint Get Tasks

Name

get_tasks

Description

Related Tables

Tasks

Parameters

Parameter Required Options
Name: QueryBy

Label: QueryBy

 YES
Option Value
project project
tag tag
section section
user_task_list user_task_list
assignee_and_workspace assignee_and_workspace
Name: ProjectId

Label: Project Id

The project to filter tasks on.
Name: WorkspaceId

Label: Workspace Id

The workspace to filter tasks on. Note: If you specify workspace, you must also specify the assignee to filter on.
Name: AssigneeId

Label: Assignee Id

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.
Name: SectionId

Label: Section Id

The section to filter tasks on.
Name: TagId

Label: Tag Id
Name: UserTaskListId

Label: UserTaskListId
Name: CompletedSince

Label: Completed Since

Only return tasks that are either incomplete or that have been completed since this time.
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
Name: ModifiedSince

Label: Modified Since

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.
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
Name: Fields

Label: Fields
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
Name: Limit

Label: Limit

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

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Tasks table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
Tasks
Required Parameters
QueryBy Fill-in the parameter...
Optional Parameters
Project Id
Workspace Id
Assignee Id
Section Id
Tag Id
UserTaskListId
Completed Since
Modified Since
Continue On 404 Error (When record not found) False
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Tasks table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get tasks:

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
Tasks
Select
Required Parameters
QueryBy Fill-in the parameter...
Optional Parameters
Project Id
Workspace Id
Assignee Id
Section Id
Tag Id
UserTaskListId
Completed Since
Modified Since
Continue On 404 Error (When record not found) False
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

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:

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).