ODBC Driver for Asana

Build 23.0.8839


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 本製品 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 本製品.

  • 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.

使用できる値は次のとおりです。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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839