Reference

Endpoint Get Project Custom Fields

Name

get_project_custom_fields

Description

Related Tables

ProjectCustomFields

Parameters

Parameter Required Options
Name: ProjectId

Label: Project 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
FieldId DT_WSTR nvarchar(50) 50
ProjectId DT_WSTR nvarchar(50) 50
ParentId DT_WSTR nvarchar(50) 50
ParentName DT_WSTR nvarchar(255) 255
ProjectName DT_WSTR nvarchar(255) 255
IsImportant DT_BOOL bit
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 ProjectCustomFields 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
ProjectCustomFields
Required Parameters
Project 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

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

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

Get ProjectCustomFields 

SELECT * FROM ProjectCustomFields

get_project_custom_fields endpoint belongs to ProjectCustomFields 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:

Get ProjectCustomFields 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM ProjectCustomFields';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

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