Users
To view the users details.
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.
- 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. | |
| 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. |