ODBC Driver for Asana

Build 23.0.8839


To view the Custom Fields in the project.

Table Specific Information


The 本製品 uses the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side in the 本製品.

  • ProjectId supports the '=' comparison.

For example, the following query is processed server side:

SELECT * FROM CustomFields WHERE ProjectId = '1126938691750986'


Name Type References Description
Id String Globally unique identifier of the resource.
Name String The name of the custom field.
Description String The description of the custom field.
Type String The type of the custom field. It must be one of the given values.
ProjectId String Globally unique Id of the project.
ProjectName String Name of the project.
IsImportant Boolean Name of the project.
Format String The format of the custom field.
TextValue String The value of a text custom field.
NumberValue Double The value of a number custom field.
Precision Integer Only relevant for custom fields of type 'Number'. This field specifies the number of digits after the decimal to round to.
CurrencyCode String The currency code for this custom field. The value is null if the format is not currency.
EnumOptions String Array of projects this task is associated with and the section it is in.
CreatedBy String Globally unique user identifier.
CreatedByName String The user's name.
IsGlobaltoWorkspace Boolean A flag that specifies whether this custom field is available to every container in the workspace.
HasNotificationsEnabled Boolean A flag that specifies whether a follower of a task with this field should receive inbox notifications about changes in this field.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839