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 connector 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 connector.
- 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. 使用できる値は次のとおりです。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. |