Reference

Endpoint Get Portfolios

Name

get_portfolios

Description

Related Tables

Portfolios

Parameters

Parameter Required Options
Name: OwnerId

Label: Owner Id

 YES
Name: WorkspaceId

Label: Workspace Id
Name: Fields

Label: Fields
Option Value
archived archived
resource_type resource_type
color color
created_by created_by
created_by.name created_by.name
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
project_templates project_templates
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
Color DT_WSTR nvarchar(50) 50
CreatedAt DT_DBTIMESTAMP datetime
CreatedById DT_WSTR nvarchar(50) 50
CreatedByName DT_WSTR nvarchar(255) 255
CustomFieldSettings DT_NTEXT nvarchar(MAX)
CurrentStatusUpdateId DT_WSTR nvarchar(50) 50
CurrentStatusUpdateTitle DT_WSTR nvarchar(100) 100
CurrentStatusUpdateResourceSubtype DT_WSTR nvarchar(100) 100
DueOn DT_WSTR nvarchar(50) 50
CustomFields DT_WSTR nvarchar(4000) 4000
Members DT_WSTR nvarchar(500) 500
OwnerId DT_WSTR nvarchar(50) 50
OwnerName DT_WSTR nvarchar(255) 255
StartOn DT_WSTR nvarchar(50) 50
WorkspaceId DT_WSTR nvarchar(50) 50
WorkspaceName DT_WSTR nvarchar(255) 255
PermalinkUrl DT_WSTR nvarchar(500) 500
Public DT_BOOL bit
DefaultAccessLevel DT_WSTR nvarchar(50) 50
PrivacySetting DT_WSTR nvarchar(50) 50
ProjectTemplates DT_WSTR nvarchar(500) 500
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 Portfolios 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
Portfolios
Required Parameters
Owner Id Fill-in the parameter...
Optional Parameters
Workspace Id
Continue On 404 Error (When record not found) False
SSIS API Source - Read from table or endpoint

API Destination

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

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
Portfolios
Select
Required Parameters
Owner Id Fill-in the parameter...
Optional Parameters
Workspace Id
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 Portfolios for a specified Owner

Read Portfolios for a specified Owner (Default Workspace). 

SELECT * FROM Portfolios WITH(OwnerId='1200442904128317')

Read Portfolios for a specified Owner and Workspace

Read Portfolios for a specified Owner Id and Workspace id. 

SELECT * FROM Portfolios WITH(OwnerId='1200442904128317', WorkspaceId='1200442900140748')

get_portfolios endpoint belongs to Portfolios 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 Portfolios for a specified Owner

Read Portfolios for a specified Owner (Default Workspace). 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Portfolios WITH(OwnerId=''1200442904128317'')';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

Read Portfolios for a specified Owner and Workspace

Read Portfolios for a specified Owner Id and Workspace id. 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Portfolios WITH(OwnerId=''1200442904128317'', WorkspaceId=''1200442900140748'')';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

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