Reference

Endpoint Get Sub Tasks

Name

get_subtasks

Description

Only enter TaskId if QueryBy=task else you may get error.

Related Tables

SubTasks

Parameters

Parameter Required Options
Name: QueryBy

Label: QueryBy

 YES
Option Value
project project
task task
tag tag
section section
user_task_list user_task_list
assignee_and_workspace assignee_and_workspace
Name: TaskId

Label: Parent Task Id

The parent task id for which you would like to fetch all sub tasks.
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
gid gid
name name
subtasks subtasks
subtasks.actual_time_minutes subtasks.actual_time_minutes
subtasks.approval_status subtasks.approval_status
subtasks.assignee subtasks.assignee
subtasks.assignee.name subtasks.assignee.name
subtasks.assignee_section subtasks.assignee_section
subtasks.assignee_section.name subtasks.assignee_section.name
subtasks.assignee_status subtasks.assignee_status
subtasks.completed subtasks.completed
subtasks.completed_at subtasks.completed_at
subtasks.completed_by subtasks.completed_by
subtasks.completed_by.name subtasks.completed_by.name
subtasks.created_at subtasks.created_at
subtasks.created_by subtasks.created_by
subtasks.created_by.name subtasks.created_by.name
subtasks.custom_fields subtasks.custom_fields
subtasks.custom_fields.asana_created_field subtasks.custom_fields.asana_created_field
subtasks.custom_fields.created_by subtasks.custom_fields.created_by
subtasks.custom_fields.created_by.name subtasks.custom_fields.created_by.name
subtasks.custom_fields.currency_code subtasks.custom_fields.currency_code
subtasks.custom_fields.custom_label subtasks.custom_fields.custom_label
subtasks.custom_fields.custom_label_position subtasks.custom_fields.custom_label_position
subtasks.custom_fields.date_value subtasks.custom_fields.date_value
subtasks.custom_fields.date_value.date subtasks.custom_fields.date_value.date
subtasks.custom_fields.date_value.date_time subtasks.custom_fields.date_value.date_time
subtasks.custom_fields.description subtasks.custom_fields.description
subtasks.custom_fields.display_value subtasks.custom_fields.display_value
subtasks.custom_fields.enabled subtasks.custom_fields.enabled
subtasks.custom_fields.enum_options subtasks.custom_fields.enum_options
subtasks.custom_fields.enum_options.color subtasks.custom_fields.enum_options.color
subtasks.custom_fields.enum_options.enabled subtasks.custom_fields.enum_options.enabled
subtasks.custom_fields.enum_options.name subtasks.custom_fields.enum_options.name
subtasks.custom_fields.enum_value subtasks.custom_fields.enum_value
subtasks.custom_fields.enum_value.color subtasks.custom_fields.enum_value.color
subtasks.custom_fields.enum_value.enabled subtasks.custom_fields.enum_value.enabled
subtasks.custom_fields.enum_value.name subtasks.custom_fields.enum_value.name
subtasks.custom_fields.format subtasks.custom_fields.format
subtasks.custom_fields.has_notifications_enabled subtasks.custom_fields.has_notifications_enabled
subtasks.custom_fields.id_prefix subtasks.custom_fields.id_prefix
subtasks.custom_fields.is_formula_field subtasks.custom_fields.is_formula_field
subtasks.custom_fields.is_global_to_workspace subtasks.custom_fields.is_global_to_workspace
subtasks.custom_fields.is_value_read_only subtasks.custom_fields.is_value_read_only
subtasks.custom_fields.multi_enum_values subtasks.custom_fields.multi_enum_values
subtasks.custom_fields.multi_enum_values.color subtasks.custom_fields.multi_enum_values.color
subtasks.custom_fields.multi_enum_values.enabled subtasks.custom_fields.multi_enum_values.enabled
subtasks.custom_fields.multi_enum_values.name subtasks.custom_fields.multi_enum_values.name
subtasks.custom_fields.name subtasks.custom_fields.name
subtasks.custom_fields.number_value subtasks.custom_fields.number_value
subtasks.custom_fields.people_value subtasks.custom_fields.people_value
subtasks.custom_fields.people_value.name subtasks.custom_fields.people_value.name
subtasks.custom_fields.precision subtasks.custom_fields.precision
subtasks.custom_fields.representation_type subtasks.custom_fields.representation_type
subtasks.custom_fields.resource_subtype subtasks.custom_fields.resource_subtype
subtasks.custom_fields.text_value subtasks.custom_fields.text_value
subtasks.custom_fields.type subtasks.custom_fields.type
subtasks.dependencies subtasks.dependencies
subtasks.dependents subtasks.dependents
subtasks.subtasks subtasks.subtasks
subtasks.due_at subtasks.due_at
subtasks.due_on subtasks.due_on
subtasks.external subtasks.external
subtasks.external.data subtasks.external.data
subtasks.followers subtasks.followers
subtasks.followers.name subtasks.followers.name
subtasks.hearted subtasks.hearted
subtasks.hearts subtasks.hearts
subtasks.hearts.user subtasks.hearts.user
subtasks.hearts.user.name subtasks.hearts.user.name
subtasks.html_notes subtasks.html_notes
subtasks.is_rendered_as_separator subtasks.is_rendered_as_separator
subtasks.liked subtasks.liked
subtasks.likes subtasks.likes
subtasks.likes.user subtasks.likes.user
subtasks.likes.user.name subtasks.likes.user.name
subtasks.memberships subtasks.memberships
subtasks.memberships.project subtasks.memberships.project
subtasks.memberships.project.name subtasks.memberships.project.name
subtasks.memberships.section subtasks.memberships.section
subtasks.memberships.section.name subtasks.memberships.section.name
subtasks.modified_at subtasks.modified_at
subtasks.name subtasks.name
subtasks.notes subtasks.notes
subtasks.num_hearts subtasks.num_hearts
subtasks.num_likes subtasks.num_likes
subtasks.num_subtasks subtasks.num_subtasks
subtasks.parent subtasks.parent
subtasks.parent.created_by subtasks.parent.created_by
subtasks.parent.name subtasks.parent.name
subtasks.parent.resource_subtype subtasks.parent.resource_subtype
subtasks.permalink_url subtasks.permalink_url
subtasks.projects subtasks.projects
subtasks.projects.name subtasks.projects.name
subtasks.resource_subtype subtasks.resource_subtype
subtasks.start_at subtasks.start_at
subtasks.start_on subtasks.start_on
subtasks.tags subtasks.tags
subtasks.tags.name subtasks.tags.name
subtasks.workspace subtasks.workspace
subtasks.workspace.name subtasks.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 SubTasks 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
SubTasks
Required Parameters
QueryBy Fill-in the parameter...
Optional Parameters
Parent Task Id
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 SubTasks table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get sub tasks:

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
SubTasks
Select
Required Parameters
QueryBy Fill-in the parameter...
Optional Parameters
Parent Task Id
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 Sub Tasks - First Level (default project)

Read all first level sub tasks for default project. If you sub tasks for 3rd, 4th level deep then this wont capture. 

SELECT * FROM SubTasks

Read Sub Tasks - First Level for specified project

Read all first level sub tasks for a specified project id. If you sub tasks for 3rd, 4th level deep then this wont capture. 

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

Read Sub Tasks for a specified parent task 

SELECT * FROM SubTasks  WITH(QueryBy='task', TaskId='1207150838176996')

get_subtasks endpoint belongs to SubTasks 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 Sub Tasks - First Level (default project)

Read all first level sub tasks for default project. If you sub tasks for 3rd, 4th level deep then this wont capture. 

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

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

Read Sub Tasks - First Level for specified project

Read all first level sub tasks for a specified project id. If you sub tasks for 3rd, 4th level deep then this wont capture. 

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

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

Read Sub Tasks for a specified parent task 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM SubTasks  WITH(QueryBy=''task'', TaskId=''1207150838176996'')';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

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