Endpoint

Get Portfolio Custom Fields

Name

get_portfolio_custom_fields

Description

Parameters

Parameter

Label

Required

Options

Description

PortfolioId

Portfolio Id

YES

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

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`
Type	`DT_WSTR`	`nvarchar(50)`	50	`False`
Description	`DT_NTEXT`	`nvarchar(MAX)`		`False`
AsanaCreatedField	`DT_WSTR`	`nvarchar(50)`	50	`False`
CreatedById	`DT_WSTR`	`nvarchar(50)`	50	`False`
CreatedByName	`DT_WSTR`	`nvarchar(255)`	255	`False`
RepresentationType	`DT_WSTR`	`nvarchar(100)`	100	`False`
CustomLabel	`DT_WSTR`	`nvarchar(50)`	50	`False`
CustomLabelPosition	`DT_WSTR`	`nvarchar(50)`	50	`False`
Enabled	`DT_BOOL`	`bit`		`False`
EnumOptions	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
Format	`DT_WSTR`	`nvarchar(50)`	50	`False`
HasNotificationsEnabled	`DT_BOOL`	`bit`		`False`
IsGlobalToWorkspace	`DT_BOOL`	`bit`		`False`
IsFormulaField	`DT_BOOL`	`bit`		`False`
IsValueReadOnly	`DT_BOOL`	`bit`		`False`
Precision	`DT_I4`	`int`		`False`
ResourceSubtype	`DT_WSTR`	`nvarchar(50)`	50	`False`
IdPrefix	`DT_WSTR`	`nvarchar(100)`	100	`False`
ValuePath	`DT_WSTR`	`nvarchar(50)`	50	`False`
Id	`DT_WSTR`	`nvarchar(50)`	50	`False`
ProjectId	`DT_WSTR`	`nvarchar(50)`	50	`False`
ProjectName	`DT_WSTR`	`nvarchar(255)`	255	`False`
IsImportant	`DT_BOOL`	`bit`		`False`
ParentId	`DT_WSTR`	`nvarchar(50)`	50	`False`
ParentName	`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:

Get Portfolio Custom Fields using API Source

Asana

Get Portfolio Custom Fields

SSIS API Source - Read from table or endpoint

Get Portfolio Custom Fields using API Destination

Asana

Get Portfolio Custom Fields

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