Events
To view the events in projects and tasks.
Table Specific Information
Select
The connector will use the Asana API to process WHERE clause conditions built with the following column and operator. The resource id will be either Project or Task Id. The rest of the filter is executed client side within the connector.
- ResourceId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM Events WHERE ResourceId = '1128092964672854'
Columns
| Name | Type | References | Description |
| ResourceId [KEY] | String | The resource GID for the events were requested for. | |
| ResourceType | String | The resource type for the events were requested for. | |
| ResourceSubType | String | The resource sub type for the events were requested for. | |
| ResourceName | String | The resource name for the events were requested for. | |
| Parent | String | For added/removed events, the parent that resource was added to or removed from. null for other event types. | |
| CreatedAt | Datetime | The timestamp when the event occurred. | |
| UserId | String | The event may be triggered by a different user GID than the subscriber. | |
| UserFullname | String | The event may be triggered by a different user name than the subscriber. | |
| Action | String | The type of action taken that triggered the event. | |
| ChangeField | String | The name of the field that has changed in the resource. | |
| ChangeAction | String | The type of action taken on the field which has been changed. This can be one of changed, added, or removed depending on the nature of the change. | |
| ChangeNewValue | String | This property is only present when the value of the event's change.action is changed and the new_value is an Asana resource. This will be only the gid and resource_type of the resource when the events come from webhooks. | |
| ChangeAddedValue | String | This property is only present when the value of the event's change.action is added and the added_value is an Asana resource. This will be only the gid and resource_type of the resource when the events come from webhooks. | |
| ChangeRemovedValue | String | This property is only present when the value of the event's change.action is removed and the removed_value is an Asana resource. This will be only the gid and resource_type of the resource when the events come from webhook. |