Asana Connector
Documentation
Version: 1
Documentation
Home » API Integration Hub » Asana Connector » EndPoints > Get Projects

EndPoint Get Projects

Name

get_projects

Description

Parameters

Parameter Label Required Options Description
WorkspaceId Workspace Id NO
TeamId Team Id NO
Fields Fields NO
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

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
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

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.