EndPoint Get Portfolio Custom Fields

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

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

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

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.