Reference

Endpoint Get Projects

Name

get_projects

Description

Related Tables

Projects

Parameters

Parameter Required Options
Name: WorkspaceId

Label: Workspace Id
Name: TeamId

Label: Team Id
Name: Fields

Label: Fields
Option Value
archived archived
resource_type resource_type
color color
completed completed
completed_at completed_at
completed_by completed_by
completed_by.name completed_by.name
created_at created_at
created_from_template created_from_template
created_from_template.name created_from_template.name
current_status current_status
current_status.author current_status.author
current_status.author.name current_status.author.name
current_status.color current_status.color
current_status.created_at current_status.created_at
current_status.created_by current_status.created_by
current_status.created_by.name current_status.created_by.name
current_status.html_text current_status.html_text
current_status.modified_at current_status.modified_at
current_status.text current_status.text
current_status.title current_status.title
current_status_update current_status_update
current_status_update.resource_subtype current_status_update.resource_subtype
current_status_update.title current_status_update.title
custom_field_settings custom_field_settings
custom_field_settings.custom_field custom_field_settings.custom_field
custom_field_settings.custom_field.asana_created_field custom_field_settings.custom_field.asana_created_field
custom_field_settings.custom_field.created_by custom_field_settings.custom_field.created_by
custom_field_settings.custom_field.created_by.name custom_field_settings.custom_field.created_by.name
custom_field_settings.custom_field.currency_code custom_field_settings.custom_field.currency_code
custom_field_settings.custom_field.custom_label custom_field_settings.custom_field.custom_label
custom_field_settings.custom_field.custom_label_position custom_field_settings.custom_field.custom_label_position
custom_field_settings.custom_field.date_value custom_field_settings.custom_field.date_value
custom_field_settings.custom_field.date_value.date custom_field_settings.custom_field.date_value.date
custom_field_settings.custom_field.date_value.date_time custom_field_settings.custom_field.date_value.date_time
custom_field_settings.custom_field.description custom_field_settings.custom_field.description
custom_field_settings.custom_field.display_value custom_field_settings.custom_field.display_value
custom_field_settings.custom_field.enabled custom_field_settings.custom_field.enabled
custom_field_settings.custom_field.enum_options custom_field_settings.custom_field.enum_options
custom_field_settings.custom_field.enum_options.color custom_field_settings.custom_field.enum_options.color
custom_field_settings.custom_field.enum_options.enabled custom_field_settings.custom_field.enum_options.enabled
custom_field_settings.custom_field.enum_options.name custom_field_settings.custom_field.enum_options.name
custom_field_settings.custom_field.enum_value custom_field_settings.custom_field.enum_value
custom_field_settings.custom_field.enum_value.color custom_field_settings.custom_field.enum_value.color
custom_field_settings.custom_field.enum_value.enabled custom_field_settings.custom_field.enum_value.enabled
custom_field_settings.custom_field.enum_value.name custom_field_settings.custom_field.enum_value.name
custom_field_settings.custom_field.format custom_field_settings.custom_field.format
custom_field_settings.custom_field.has_notifications_enabled custom_field_settings.custom_field.has_notifications_enabled
custom_field_settings.custom_field.id_prefix custom_field_settings.custom_field.id_prefix
custom_field_settings.custom_field.is_formula_field custom_field_settings.custom_field.is_formula_field
custom_field_settings.custom_field.is_global_to_workspace custom_field_settings.custom_field.is_global_to_workspace
custom_field_settings.custom_field.is_value_read_only custom_field_settings.custom_field.is_value_read_only
custom_field_settings.custom_field.multi_enum_values custom_field_settings.custom_field.multi_enum_values
custom_field_settings.custom_field.multi_enum_values.color custom_field_settings.custom_field.multi_enum_values.color
custom_field_settings.custom_field.multi_enum_values.enabled custom_field_settings.custom_field.multi_enum_values.enabled
custom_field_settings.custom_field.multi_enum_values.name custom_field_settings.custom_field.multi_enum_values.name
custom_field_settings.custom_field.name custom_field_settings.custom_field.name
custom_field_settings.custom_field.number_value custom_field_settings.custom_field.number_value
custom_field_settings.custom_field.people_value custom_field_settings.custom_field.people_value
custom_field_settings.custom_field.people_value.name custom_field_settings.custom_field.people_value.name
custom_field_settings.custom_field.precision custom_field_settings.custom_field.precision
custom_field_settings.custom_field.representation_type custom_field_settings.custom_field.representation_type
custom_field_settings.custom_field.resource_subtype custom_field_settings.custom_field.resource_subtype
custom_field_settings.custom_field.text_value custom_field_settings.custom_field.text_value
custom_field_settings.custom_field.type custom_field_settings.custom_field.type
custom_field_settings.is_important custom_field_settings.is_important
custom_field_settings.parent custom_field_settings.parent
custom_field_settings.parent.name custom_field_settings.parent.name
custom_field_settings.project custom_field_settings.project
custom_field_settings.project.name custom_field_settings.project.name
custom_fields custom_fields
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.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.id_prefix custom_fields.id_prefix
custom_fields.is_formula_field custom_fields.is_formula_field
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.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
default_access_level default_access_level
default_view default_view
due_date due_date
due_on due_on
followers followers
followers.name followers.name
html_notes html_notes
icon icon
members members
members.name members.name
minimum_access_level_for_customization minimum_access_level_for_customization
minimum_access_level_for_sharing minimum_access_level_for_sharing
modified_at modified_at
name name
notes notes
offset offset
owner owner
owner.name owner.name
path path
permalink_url permalink_url
privacy_setting privacy_setting
project_brief project_brief
public public
start_on start_on
team team
team.name team.name
uri uri
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
Archived DT_BOOL bit
Color DT_WSTR nvarchar(50) 50
CreatedAt DT_DBTIMESTAMP datetime
CurrentStatusId DT_WSTR nvarchar(50) 50
CurrentStatusTitle DT_WSTR nvarchar(100) 100
CurrentStatusText DT_NTEXT nvarchar(MAX)
CurrentStatusHtmlText DT_NTEXT nvarchar(MAX)
CurrentStatusColor DT_WSTR nvarchar(50) 50
CurrentStatusAuthorId DT_WSTR nvarchar(50) 50
CurrentStatusAuthorName DT_WSTR nvarchar(255) 255
CurrentStatusCreatedAt DT_DBTIMESTAMP datetime
CurrentStatusCreatedById DT_WSTR nvarchar(50) 50
CurrentStatusCreatedByName DT_WSTR nvarchar(255) 255
CurrentStatusModifiedAt DT_DBTIMESTAMP datetime
CurrentStatusUpdateId DT_WSTR nvarchar(50) 50
CurrentStatusUpdateTitle DT_WSTR nvarchar(100) 100
CurrentStatusUpdateResourceSubtype DT_WSTR nvarchar(100) 100
CustomFieldSettings DT_NTEXT nvarchar(MAX)
DefaultAccessLevel DT_WSTR nvarchar(50) 50
DefaultView DT_WSTR nvarchar(50) 50
DueDate DT_WSTR nvarchar(50) 50
DueOn DT_WSTR nvarchar(50) 50
HtmlNotes DT_NTEXT nvarchar(MAX)
Members DT_WSTR nvarchar(500) 500
ModifiedAt DT_DBTIMESTAMP datetime
Notes DT_NTEXT nvarchar(MAX)
Public DT_BOOL bit
StartOn DT_WSTR nvarchar(50) 50
WorkspaceId DT_WSTR nvarchar(50) 50
WorkspaceName DT_WSTR nvarchar(255) 255
CustomFields DT_WSTR nvarchar(4000) 4000
Completed DT_BOOL bit
CompletedAt DT_DBTIMESTAMP datetime
CompletedById DT_WSTR nvarchar(50) 50
CompletedByName DT_WSTR nvarchar(255) 255
Followers DT_WSTR nvarchar(500) 500
OwnerId DT_WSTR nvarchar(50) 50
OwnerName DT_WSTR nvarchar(255) 255
TeamId DT_WSTR nvarchar(50) 50
TeamName DT_WSTR nvarchar(255) 255
Icon DT_WSTR nvarchar(50) 50
PermalinkUrl DT_WSTR nvarchar(500) 500
ProjectBriefId DT_WSTR nvarchar(50) 50
CreatedFromTemplateId DT_WSTR nvarchar(50) 50
CreatedFromTemplateName 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 Projects 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
Projects
Optional Parameters
Workspace Id
Team Id
SSIS API Source - Read from table or endpoint

API Destination

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

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
Projects
Select
Optional Parameters
Workspace Id
Team Id
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read Projects

Read all projects 

SELECT * FROM Projects

get_projects endpoint belongs to Projects 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 Projects

Read all projects 

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

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

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