StatusUpdates
A status update is an update on the progress of a particular object, and is sent out to all followers when created.
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.
- ParentId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM StatusUpdates SELECT * FROM StatusUpdates WHERE Id = '1126938837961834' SELECT * FROM StatusUpdates WHERE ParentId = '1126938837961834'
Insert
Text, StatusType and ParentId are mandatory columns for inserting into StatusUpdates table. For example:
INSERT INTO StatusUpdates(ParentId,Title,Text,StatusType) VALUES('1203125557018928','asd','tewr','on_track')
Delete
Following is an example of how to delete from StatusUpdates table:
DELETE FROM StatusUpdates WHERE Id = '1161963899354167'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique identifier of the resource, as a string. | |
| AuthorId | String | True |
A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. Globally unique identifier of the resource. | |
| AuthorName | String | True |
A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The user's name. | |
| AuthorResourceType | String | True |
A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The base type of this resource. | |
| CreatedAt | Datetime | True |
The time at which this resource was created. | |
| CreatedById | String | True |
A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. Globally unique identifier of the resource. | |
| CreatedByName | String | True |
A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The user's name. | |
| CreatedByResourceType | String | True |
A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. The base type of this resource. | |
| Liked | Boolean | True |
True if the status is liked by the authorized user, false if not. | |
| Likes | String | True |
Array of likes for users who have liked this status. | |
| ModifiedAt | Datetime | True |
The time at which this project status was last modified. | |
| NumLikes | Integer | True |
The number of users who have liked this status. | |
| ParentId | String | False |
Id of parent of the status update. | |
| ParentName | String | True |
Name of parent of the status update. | |
| ParentResourceType | String | True |
Resource type of parent of the status update. | |
| ResourceSubtype | String | True |
The subtype of this resource. | |
| ResourceType | String | True |
The base type of this resource. | |
| StatusType | String | False |
The type associated with the status update. The allowed values are on_track, at_risk, off_track, on_hold, complete, achieved, partial, missed, dropped. | |
| Text | String | False |
The text content of the status update. | |
| HTMLText | String | False |
The text content of the status update with formatting as HTML. | |
| Title | String | False |
The title of the status update. |