ADO.NET Provider for Asana

Build 23.0.8839


To Create, Delete and Query from ProjectStatuses table. A project status is an update on the progress of a particular project, and is sent out to all project followers when created.

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.
  • ProjectId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ProjectStatuses WHERE Id = '1127092449876445'

SELECT * FROM ProjectStatuses WHERE ProjectId = '1127092449876444'


ProjectId is a mandatory column for inserting into ProjectStatuses table. For example:

INSERT INTO projectstatuses (Color, Title, Text, ProjectId) VALUES ('red', 'Status1', 'StatusNotes', '1127092449876444')


Following is an example of how to delete from ProjectStatuses table:

DELETE FROM ProjectStatuses WHERE Id = '1127092449876445'


Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the project status update.

Color String True

The color associated with the status update.

使用できる値は次のとおりです。green, yellow, red

Title String True

The title of the project status update.

Text String True

The text content of the status update.

CreatedAt Datetime True

The time at which the status update was created.

CreatedBy String True

The creator of the status update.

ProjectId String True


Globally unique ID of the project.

ResourceType String True

The resource type of this resource. The value for this resource is always project_status.

HTMLText String True

The notes of the project with formatting as HTML.

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