Asana Connector
Documentation
Version: 1
Documentation

EndPoint Get Sub Tasks


Name

get_subtasks

Description

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

Parameters

Parameter Label Required Options Description
QueryBy QueryBy YES
Option Value
project project
task task
tag tag
section section
user_task_list user_task_list
assignee_and_workspace assignee_and_workspace
TaskId Parent Task Id NO The parent task id for which you would like to fetch all sub tasks.
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
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
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

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:

Get Sub Tasks using API Source

Asana
Get Sub Tasks
SSIS API Source - Read from table or endpoint

Get Sub Tasks using API Destination

Asana
Get Sub Tasks
SSIS API Destination - Access table or endpoint