ADO.NET Provider for Asana

Build 20.0.7655

Users

To view the users details

Table Specific Information

Select

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

  • Id supports the '=' comparison.
  • WorkspaceId supports the '=' comparison.
  • TeamId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Users WHERE Id = '1126938691750986'

SELECT * FROM Users WHERE WorkspaceId = '1126938837961835'

SELECT * FROM Users WHERE TeamId = '1129514033997892'

Columns

Name Type References Description
Id [KEY] String Globally unique ID of the user.
Name String The user`s name.
Email String The user`s email address.
ResourceType String The resource type of this resource.
WorkspaceId String

Workspaces.Id

The User access in workspaces
TeamId String

Teams.Id

Globally unique ID of the team

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