Reference

Endpoint Get Portfolio Custom Fields

Name

get_portfolio_custom_fields

Description

Parameters

Parameter Required Options
Name: PortfolioId

Label: Portfolio Id

 YES
Name: Fields

Label: Fields
Option Value
custom_field custom_field
custom_field.asana_created_field custom_field.asana_created_field
custom_field.created_by custom_field.created_by
custom_field.created_by.name custom_field.created_by.name
custom_field.currency_code custom_field.currency_code
custom_field.custom_label custom_field.custom_label
custom_field.custom_label_position custom_field.custom_label_position
custom_field.date_value custom_field.date_value
custom_field.date_value.date custom_field.date_value.date
custom_field.date_value.date_time custom_field.date_value.date_time
custom_field.description custom_field.description
custom_field.display_value custom_field.display_value
custom_field.enabled custom_field.enabled
custom_field.enum_options custom_field.enum_options
custom_field.enum_options.color custom_field.enum_options.color
custom_field.enum_options.enabled custom_field.enum_options.enabled
custom_field.enum_options.name custom_field.enum_options.name
custom_field.enum_value custom_field.enum_value
custom_field.enum_value.color custom_field.enum_value.color
custom_field.enum_value.enabled custom_field.enum_value.enabled
custom_field.enum_value.name custom_field.enum_value.name
custom_field.format custom_field.format
custom_field.has_notifications_enabled custom_field.has_notifications_enabled
custom_field.id_prefix custom_field.id_prefix
custom_field.is_formula_field custom_field.is_formula_field
custom_field.is_global_to_workspace custom_field.is_global_to_workspace
custom_field.is_value_read_only custom_field.is_value_read_only
custom_field.multi_enum_values custom_field.multi_enum_values
custom_field.multi_enum_values.color custom_field.multi_enum_values.color
custom_field.multi_enum_values.enabled custom_field.multi_enum_values.enabled
custom_field.multi_enum_values.name custom_field.multi_enum_values.name
custom_field.name custom_field.name
custom_field.number_value custom_field.number_value
custom_field.people_value custom_field.people_value
custom_field.people_value.name custom_field.people_value.name
custom_field.precision custom_field.precision
custom_field.representation_type custom_field.representation_type
custom_field.resource_subtype custom_field.resource_subtype
custom_field.text_value custom_field.text_value
custom_field.type custom_field.type
is_important is_important
parent parent
parent.name parent.name
project project
project.name project.name
portfolio portfolio
portfolio.name portfolio.name
workspace workspace
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
Type DT_WSTR nvarchar(50) 50
Description DT_NTEXT nvarchar(MAX)
AsanaCreatedField DT_WSTR nvarchar(50) 50
CreatedById DT_WSTR nvarchar(50) 50
CreatedByName DT_WSTR nvarchar(255) 255
RepresentationType DT_WSTR nvarchar(100) 100
CustomLabel DT_WSTR nvarchar(50) 50
CustomLabelPosition DT_WSTR nvarchar(50) 50
Enabled DT_BOOL bit
EnumOptions DT_WSTR nvarchar(1000) 1000
Format DT_WSTR nvarchar(50) 50
HasNotificationsEnabled DT_BOOL bit
IsGlobalToWorkspace DT_BOOL bit
IsFormulaField DT_BOOL bit
IsValueReadOnly DT_BOOL bit
Precision DT_I4 int
ResourceSubtype DT_WSTR nvarchar(50) 50
IdPrefix DT_WSTR nvarchar(100) 100
ValuePath DT_WSTR nvarchar(50) 50
Id DT_WSTR nvarchar(50) 50
ProjectId DT_WSTR nvarchar(50) 50
ProjectName DT_WSTR nvarchar(255) 255
IsImportant DT_BOOL bit
ParentId DT_WSTR nvarchar(50) 50
ParentName 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

API Source - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
Get Portfolio Custom Fields
Required Parameters
Portfolio Id Fill-in the parameter...
Optional Parameters
Continue On 404 Error (When record not found) False
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
Get Portfolio Custom Fields
Required Parameters
Portfolio Id Fill-in the parameter...
Optional Parameters
Continue On 404 Error (When record not found) False
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get portfolio custom fields 

SELECT * FROM get_portfolio_custom_fields
WITH
(
    "PortfolioId" = 'abcd-1234-portfolioid'
)

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get portfolio custom fields 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_portfolio_custom_fields
WITH
(
    "PortfolioId" = ''abcd-1234-portfolioid''
)';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];