Tags

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

Select

The add-in 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 add-in.

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'

Insert

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')

Update

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

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

Columns


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	False		Followers for the tag.
WorkspaceId	String	True	Workspaces.Id	The workspace or organization this tag is associated with.
TaskId	String	True	Tasks.Id	The task this tag is mapped with.