SSIS Components for Asana

Build 25.0.9434

CustomFields

To view the Custom Fields in the project or workspace.

Table Specific Information

Select

The component 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 component.

  • 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

Projects.Id

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.
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. This will be 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 boolean flag that specifies whether this custom field is available to every container in the workspace.
HasNotificationsEnabled Boolean A boolean flag that specifies whether a follower of a task with this field should receive inbox notifications about changes in this field.
WorkspaceId String

Workspaces.Id

Globally unique ID of the workspace.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434