Asana Connector
Documentation
Version: 1
Documentation

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

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.