WorkspaceMembership
To Create, Delete and Query memberships in the Workspace.
Table Specific Information
Select
The add-in 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 add-in.
- Id supports the '=' comparison.
- UserId supports the '=' comparison.
- WorkspaceId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM WorkspaceMembership WHERE WorkspaceId = '1126938837961830' SELECT * FROM WorkspaceMembership WHERE UserId = '1126938691750986' SELECT * FROM WorkspaceMembership WHERE Id = '1126938837961834'
Insert
UserId and WorkspaceId is a mandatory column for inserting into WorkspaceMembership table. For example:
INSERT INTO WorkspaceMembership (UserId, WorkspaceId) VALUES ('1161963899354167', '1126938837961830')
Delete
Following is an example of how to delete from WorkspaceMembership table:
DELETE FROM WorkspaceMembership WHERE UserId = '1161963899354167' AND WorkspaceId = '1126938837961830'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Globally unique ID of the membership. | |
userId [KEY] | String | True |
Users.Id |
Globally unique ID of the user. |
userName | String | True |
The user`s name. | |
WorkspaceId [KEY] | String | True |
Workspaces.Id |
Globally unique ID of the workspace. |
WorkspaceName | String | True |
The Workspace name. | |
IsActive | Boolean | True |
Reflects if this user still a member of the workspace. | |
IsAdmin | Boolean | True |
Reflects if this user is an admin of the workspace. | |
IsGuest | Boolean | True |
Reflects if this user is a guest of the workspace. | |
UserTaskListId | String | True |
A user task list represents the tasks assigned to a particular user. | |
ResourceType | String | True |
The base type of this resource. | |
VacationStartDate | String | True |
The day on which the user's vacation in this workspace starts. | |
VacationEndDate | String | True |
The day on which the user's vacation in this workspace ends. |