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'
Globally unique ID of the tag.
Name of the tag.
The time at which this tag was created.
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 of the tag
Followers for the tag
The workspace or organization this tag is associated with.
The task this tag is mapped with.