JDBC Driver for Asana

Build 23.0.8839

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

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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839