Endpoint

Get Projects

Name

get_projects

Description

Related Tables

Projects

Parameters

Parameter

Label

Required

Options

Description

WorkspaceId

Workspace Id

TeamId

Team Id

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

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	Raw
Id	`DT_WSTR`	`nvarchar(50)`	50	`False`
Name	`DT_WSTR`	`nvarchar(255)`	255	`False`
Archived	`DT_BOOL`	`bit`		`False`
Color	`DT_WSTR`	`nvarchar(50)`	50	`False`
CreatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
CurrentStatusId	`DT_WSTR`	`nvarchar(50)`	50	`False`
CurrentStatusTitle	`DT_WSTR`	`nvarchar(100)`	100	`False`
CurrentStatusText	`DT_NTEXT`	`nvarchar(MAX)`		`False`
CurrentStatusHtmlText	`DT_NTEXT`	`nvarchar(MAX)`		`False`
CurrentStatusColor	`DT_WSTR`	`nvarchar(50)`	50	`False`
CurrentStatusAuthorId	`DT_WSTR`	`nvarchar(50)`	50	`False`
CurrentStatusAuthorName	`DT_WSTR`	`nvarchar(255)`	255	`False`
CurrentStatusCreatedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
CurrentStatusCreatedById	`DT_WSTR`	`nvarchar(50)`	50	`False`
CurrentStatusCreatedByName	`DT_WSTR`	`nvarchar(255)`	255	`False`
CurrentStatusModifiedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
CurrentStatusUpdateId	`DT_WSTR`	`nvarchar(50)`	50	`False`
CurrentStatusUpdateTitle	`DT_WSTR`	`nvarchar(100)`	100	`False`
CurrentStatusUpdateResourceSubtype	`DT_WSTR`	`nvarchar(100)`	100	`False`
CustomFieldSettings	`DT_NTEXT`	`nvarchar(MAX)`		`False`
DefaultAccessLevel	`DT_WSTR`	`nvarchar(50)`	50	`False`
DefaultView	`DT_WSTR`	`nvarchar(50)`	50	`False`
DueDate	`DT_WSTR`	`nvarchar(50)`	50	`False`
DueOn	`DT_WSTR`	`nvarchar(50)`	50	`False`
HtmlNotes	`DT_NTEXT`	`nvarchar(MAX)`		`False`
Members	`DT_WSTR`	`nvarchar(500)`	500	`False`
ModifiedAt	`DT_DBTIMESTAMP`	`datetime`		`False`
Notes	`DT_NTEXT`	`nvarchar(MAX)`		`False`
Public	`DT_BOOL`	`bit`		`False`
StartOn	`DT_WSTR`	`nvarchar(50)`	50	`False`
WorkspaceId	`DT_WSTR`	`nvarchar(50)`	50	`False`
WorkspaceName	`DT_WSTR`	`nvarchar(255)`	255	`False`
CustomFields	`DT_WSTR`	`nvarchar(4000)`	4000	`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`
Followers	`DT_WSTR`	`nvarchar(500)`	500	`False`
OwnerId	`DT_WSTR`	`nvarchar(50)`	50	`False`
OwnerName	`DT_WSTR`	`nvarchar(255)`	255	`False`
TeamId	`DT_WSTR`	`nvarchar(50)`	50	`False`
TeamName	`DT_WSTR`	`nvarchar(255)`	255	`False`
Icon	`DT_WSTR`	`nvarchar(50)`	50	`False`
PermalinkUrl	`DT_WSTR`	`nvarchar(500)`	500	`False`
ProjectBriefId	`DT_WSTR`	`nvarchar(50)`	50	`False`
CreatedFromTemplateId	`DT_WSTR`	`nvarchar(50)`	50	`False`
CreatedFromTemplateName	`DT_WSTR`	`nvarchar(255)`	255	`False`

If the column you are looking for is missing, consider customizing Asana Connector.

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:

Read from Projects table using API Destination

This Endpoint belongs to Projects table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Asana

Projects

Select

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get projects

SELECT * FROM get_projects

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:

Get projects

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

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_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).