CustomFields
To view the Custom Fields in the project.
Table Specific Information
Select
The connector 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 connector.
- ProjectId supports the '=' comparison.
For example, the following query is processed server side:
SELECT * FROM CustomFields WHERE ProjectId = '1126938691750986'
Columns
| 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. |