TDV Adapter for Asana

Build 21.0.8137


To Create, Update and Query from Tags table. A tag is a label that can be attached to any task in Asana. It exists in a single workspace.

Table Specific Information


The adapter will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the adapter.

  • Id supports the '=' comparison.
  • WorkspaceId supports the '=' comparison.
  • TaskId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Tags WHERE Id = '1129517083601713'

SELECT * FROM Tags WHERE WorkspaceId = '1126938837961830'

SELECT * FROM Tags WHERE TaskId = '1128092964672854'


Workspaceid is a mandatory column for inserting into Tags table. For example:

INSERT INTO Tags (Name, Color, WorkspaceId, Notes) VALUES ('TestTag', 'dark-blue', '1126938837961830','sample notes')


Following is an example of how to update a Tags table:

UPDATE Tags SET Name='IT-1' WHERE Id='1158271967831255'


Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the tag.

Name String True

Name of the tag.

CreatedAt Datetime True

The time at which this tag was created.

Color String True

Color of the tag.

The allowed values are dark-pink, dark-green, dark-blue, dark-red, dark-teal, dark-brown, dark-orange, dark-purple, dark-warm-gray, light-pink, light-green, light-blue, light-red, light-teal, light-brown, light-orange, light-purple, light-warm-gray.

Notes String False

Notes of the tag

Followers String True

Followers for the tag

WorkspaceId String True


The workspace or organization this tag is associated with.

TaskId String True


The task this tag is mapped with.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137