To view the events in projects and tasks
Table Specific Information
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'
|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.|