ADO.NET Provider for Asana

Build 20.0.7655

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

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.

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