Reference

Endpoint Get Workspace Tasks

Name

get_workspace_tasks

Description

Get tasks for all projects in a specified workspace (or default workspace).

Related Tables

WorkspaceTasks

Parameters

Parameter Required Options
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: WorkspaceId

Label: Workspace Id

The workspace to filter tasks on. Note: If you specify workspace.
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: 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
ProjectId DT_WSTR nvarchar(30) 30
ProjectName DT_WSTR nvarchar(255) 255
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 WorkspaceTasks 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
WorkspaceTasks
Optional Parameters
Fields
Workspace Id
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 WorkspaceTasks table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get workspace tasks:

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
WorkspaceTasks
Select
Optional Parameters
Fields
Workspace Id
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 Workspace Tasks (All Projects) 

SELECT * FROM WorkspaceTasks

get_workspace_tasks endpoint belongs to WorkspaceTasks 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 Workspace Tasks (All Projects) 

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

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

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