ADO.NET Provider for Asana

Build 20.0.7655

Events

To view the events in projects and tasks

Table Specific Information

Select

The provider 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 provider.

  • 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655