Tables

A table is a container for structured records (rows), with columns defined by custom field settings.

CustomFieldTableSetting

PropertyTypeDescription
gidstringGlobally unique identifier of the resource, as a string.
resource_typestringThe base type of this resource.
custom_fieldobjectThe custom field that is applied to the table.
custom_field.gidstringGlobally unique identifier of the resource, as a string.
custom_field.resource_typestringThe base type of this resource.
custom_field.namestringThe name of the custom field.
custom_field.typestringDeprecated: new integrations should prefer the resource_subtype field. The type of the custom field. Must be one of the given values.
Click to show all enum values
  • date
  • enum
  • multi_enum
  • number
  • people
  • reference
  • text
custom_field.enum_options[][object]Conditional. Only relevant for custom fields of type enum or multi_enum. This array specifies the possible values which an enum custom field can adopt. To modify the enum options, refer to working with enum options.
custom_field.enum_options[].gidstringGlobally unique identifier of the resource, as a string.
custom_field.enum_options[].resource_typestringThe base type of this resource.
custom_field.enum_options[].namestringThe name of the enum option.
custom_field.enum_options[].enabledbooleanWhether or not the enum option is a selectable value for the custom field.
custom_field.enum_options[].colorstringThe color of the enum option. Defaults to none.
custom_field.enabledbooleanConditional. This field applies only to custom field values and is not available for custom field definitions. Determines if the custom field is enabled or not. For more details, see the Custom Fields documentation.
custom_field.representation_typestringThis field tells the type of the custom field.
Click to show all enum values
  • custom_id
  • date
  • enum
  • formula
  • multi_enum
  • number
  • people
  • reference
  • text
custom_field.id_prefixstringThis field is the unique custom ID string for the custom field.
custom_field.input_restrictions[][string]Conditional. Only relevant for custom fields of type reference. This array of strings reflects the allowed types of objects that can be written to a reference custom field value.
Click to show all enum values
  • goal
  • portfolio
  • project
  • task
custom_field.is_formula_fieldbooleanConditional. This flag describes whether a custom field is a formula custom field.
custom_field.is_lookup_fieldbooleanConditional. This flag describes whether a custom field is a lookup custom field.
custom_field.date_valueobjectConditional. Only relevant for custom fields of type date. This object reflects the chosen date (and optionally, time) value of a date custom field. If no date is selected, the value of date_value will be null.
custom_field.date_value.datestringA string representing the date in YYYY-MM-DD format.
custom_field.date_value.date_timestringA string representing the date in ISO 8601 format. If no time value is selected, the value of date-time will be null.
custom_field.enum_valueobjectConditional. Only relevant for custom fields of type enum. This object is the chosen value of an enum custom field.
custom_field.enum_value.gidstringGlobally unique identifier of the resource, as a string.
custom_field.enum_value.resource_typestringThe base type of this resource.
custom_field.enum_value.namestringThe name of the enum option.
custom_field.enum_value.enabledbooleanWhether or not the enum option is a selectable value for the custom field.
custom_field.enum_value.colorstringThe color of the enum option. Defaults to none.
custom_field.multi_enum_values[][object]Conditional. Only relevant for custom fields of type multi_enum. This object is the chosen values of a multi_enum custom field.
custom_field.multi_enum_values[].gidstringGlobally unique identifier of the resource, as a string.
custom_field.multi_enum_values[].resource_typestringThe base type of this resource.
custom_field.multi_enum_values[].namestringThe name of the enum option.
custom_field.multi_enum_values[].enabledbooleanWhether or not the enum option is a selectable value for the custom field.
custom_field.multi_enum_values[].colorstringThe color of the enum option. Defaults to none.
custom_field.number_valuenumberConditional. This number is the value of a number custom field.
custom_field.text_valuestringConditional. This string is the value of a text custom field.
custom_field.display_valuestringA string representation for the value of the custom field. Integrations that don't require the underlying type should use this field to read values. Using this field will future-proof an app against new custom field types.
is_importantbooleanis_important is used in the Asana web application to determine if this custom field is displayed in the list/grid view of a table.

Example JSON for CustomFieldTableSetting:

{
  "gid": "12345",
  "resource_type": "custom_field_setting",
  "custom_field": {
    "gid": "12345",
    "resource_type": "custom_field",
    "name": "Status",
    "type": "example string",
    "enum_options": [
      {
        "gid": "12345",
        "resource_type": "enum_option",
        "name": "Low",
        "enabled": true,
        "color": "blue"
      }
    ],
    "enabled": true,
    "representation_type": "number",
    "id_prefix": "ID",
    "input_restrictions": [
      "task"
    ],
    "is_formula_field": false,
    "is_lookup_field": false,
    "date_value": {
      "date": "2024-08-23",
      "date_time": "2024-08-23T22:00:00.000Z"
    },
    "enum_value": {
      "gid": "12345",
      "resource_type": "enum_option",
      "name": "Low",
      "enabled": true,
      "color": "blue"
    },
    "multi_enum_values": [
      {
        "gid": "12345",
        "resource_type": "enum_option",
        "name": "Low",
        "enabled": true,
        "color": "blue"
      }
    ],
    "number_value": 5.2,
    "text_value": "Some Value",
    "display_value": "blue"
  },
  "is_important": true
}

TableCompact

PropertyTypeDescription
gidstringGlobally unique identifier of the resource, as a string.
resource_typestringThe base type of this resource.
namestringThe name of the table.

Example JSON for TableCompact:

{
  "gid": "12345",
  "resource_type": "table",
  "name": "Vendor contracts"
}

Table

PropertyTypeDescription
gidstringGlobally unique identifier of the resource, as a string.
resource_typestringThe base type of this resource.
namestringThe name of the table.
modified_atstring (date-time)The time at which this table was last modified.
created_atstring (date-time)The time at which this resource was created.
workspaceobjectCreate-only. The workspace or organization this table is associated with. Once created, tables cannot be moved to a different workspace. This attribute can only be specified at creation time.
workspace.gidstringGlobally unique identifier of the resource, as a string.
workspace.resource_typestringThe base type of this resource.
workspace.namestringThe name of the workspace.
custom_field_settings[][object]Array of custom field definitions that are enabled for the table. These represent which custom fields are available to records in the table, but do not include any values.
custom_field_settings[].gidstringGlobally unique identifier of the resource, as a string.
custom_field_settings[].resource_typestringThe base type of this resource.
custom_field_settings[].custom_fieldobjectThe custom field that is applied to the table.
custom_field_settings[].custom_field.gidstringGlobally unique identifier of the resource, as a string.
custom_field_settings[].custom_field.resource_typestringThe base type of this resource.
custom_field_settings[].custom_field.namestringThe name of the custom field.
custom_field_settings[].custom_field.typestringDeprecated: new integrations should prefer the resource_subtype field. The type of the custom field. Must be one of the given values.
Click to show all enum values
  • date
  • enum
  • multi_enum
  • number
  • people
  • reference
  • text
custom_field_settings[].custom_field.enum_options[][object]Conditional. Only relevant for custom fields of type enum or multi_enum. This array specifies the possible values which an enum custom field can adopt. To modify the enum options, refer to working with enum options.
custom_field_settings[].custom_field.enum_options[].gidstringGlobally unique identifier of the resource, as a string.
custom_field_settings[].custom_field.enum_options[].resource_typestringThe base type of this resource.
custom_field_settings[].custom_field.enum_options[].namestringThe name of the enum option.
custom_field_settings[].custom_field.enum_options[].enabledbooleanWhether or not the enum option is a selectable value for the custom field.
custom_field_settings[].custom_field.enum_options[].colorstringThe color of the enum option. Defaults to none.
custom_field_settings[].custom_field.enabledbooleanConditional. This field applies only to custom field values and is not available for custom field definitions. Determines if the custom field is enabled or not. For more details, see the Custom Fields documentation.
custom_field_settings[].custom_field.representation_typestringThis field tells the type of the custom field.
Click to show all enum values
  • custom_id
  • date
  • enum
  • formula
  • multi_enum
  • number
  • people
  • reference
  • text
custom_field_settings[].custom_field.id_prefixstringThis field is the unique custom ID string for the custom field.
custom_field_settings[].custom_field.input_restrictions[][string]Conditional. Only relevant for custom fields of type reference. This array of strings reflects the allowed types of objects that can be written to a reference custom field value.
Click to show all enum values
  • goal
  • portfolio
  • project
  • task
custom_field_settings[].custom_field.is_formula_fieldbooleanConditional. This flag describes whether a custom field is a formula custom field.
custom_field_settings[].custom_field.is_lookup_fieldbooleanConditional. This flag describes whether a custom field is a lookup custom field.
custom_field_settings[].custom_field.date_valueobjectConditional. Only relevant for custom fields of type date. This object reflects the chosen date (and optionally, time) value of a date custom field. If no date is selected, the value of date_value will be null.
custom_field_settings[].custom_field.date_value.datestringA string representing the date in YYYY-MM-DD format.
custom_field_settings[].custom_field.date_value.date_timestringA string representing the date in ISO 8601 format. If no time value is selected, the value of date-time will be null.
custom_field_settings[].custom_field.enum_valueobjectConditional. Only relevant for custom fields of type enum. This object is the chosen value of an enum custom field.
custom_field_settings[].custom_field.enum_value.gidstringGlobally unique identifier of the resource, as a string.
custom_field_settings[].custom_field.enum_value.resource_typestringThe base type of this resource.
custom_field_settings[].custom_field.enum_value.namestringThe name of the enum option.
custom_field_settings[].custom_field.enum_value.enabledbooleanWhether or not the enum option is a selectable value for the custom field.
custom_field_settings[].custom_field.enum_value.colorstringThe color of the enum option. Defaults to none.
custom_field_settings[].custom_field.multi_enum_values[][object]Conditional. Only relevant for custom fields of type multi_enum. This object is the chosen values of a multi_enum custom field.
custom_field_settings[].custom_field.multi_enum_values[].gidstringGlobally unique identifier of the resource, as a string.
custom_field_settings[].custom_field.multi_enum_values[].resource_typestringThe base type of this resource.
custom_field_settings[].custom_field.multi_enum_values[].namestringThe name of the enum option.
custom_field_settings[].custom_field.multi_enum_values[].enabledbooleanWhether or not the enum option is a selectable value for the custom field.
custom_field_settings[].custom_field.multi_enum_values[].colorstringThe color of the enum option. Defaults to none.
custom_field_settings[].custom_field.number_valuenumberConditional. This number is the value of a number custom field.
custom_field_settings[].custom_field.text_valuestringConditional. This string is the value of a text custom field.
custom_field_settings[].custom_field.display_valuestringA string representation for the value of the custom field. Integrations that don't require the underlying type should use this field to read values. Using this field will future-proof an app against new custom field types.
custom_field_settings[].is_importantbooleanis_important is used in the Asana web application to determine if this custom field is displayed in the list/grid view of a table.
default_access_levelstringThe default access level for users who join or are added as members of the table.
Click to show all enum values
  • admin
  • commenter
  • editor
  • viewer

Example JSON for Table:

{
  "gid": "12345",
  "resource_type": "table",
  "name": "Vendor contracts",
  "modified_at": "2012-02-22T02:06:58.147Z",
  "created_at": "2012-02-22T02:06:58.147Z",
  "workspace": {
    "gid": "12345",
    "resource_type": "workspace",
    "name": "My Company Workspace"
  },
  "custom_field_settings": [
    {
      "gid": "12345",
      "resource_type": "custom_field_setting",
      "custom_field": {
        "gid": "12345",
        "resource_type": "custom_field",
        "name": "Status",
        "type": "example string",
        "enum_options": [
          {
            "gid": "12345",
            "resource_type": "enum_option",
            "name": "Low",
            "enabled": true,
            "color": "blue"
          }
        ],
        "enabled": true,
        "representation_type": "number",
        "id_prefix": "ID",
        "input_restrictions": [
          "task"
        ],
        "is_formula_field": false,
        "is_lookup_field": false,
        "date_value": {
          "date": "2024-08-23",
          "date_time": "2024-08-23T22:00:00.000Z"
        },
        "enum_value": {
          "gid": "12345",
          "resource_type": "enum_option",
          "name": "Low",
          "enabled": true,
          "color": "blue"
        },
        "multi_enum_values": [
          {
            "gid": "12345",
            "resource_type": "enum_option",
            "name": "Low",
            "enabled": true,
            "color": "blue"
          }
        ],
        "number_value": 5.2,
        "text_value": "Some Value",
        "display_value": "blue"
      },
      "is_important": true
    }
  ],
  "default_access_level": "viewer"
}