To Create, Delete and Query memberships in the Workspace
Table Specific Information
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.
- 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'
UserId and WorkspaceId is a mandatory column for inserting into WorkspaceMembership table. For example:
INSERT INTO WorkspaceMembership (UserId, WorkspaceId) VALUES ('1161963899354167','1126938837961830')
Following is an example of how to delete from WorkspaceMembership table:
DELETE FROM WorkspaceMembership WHERE UserId = '1161963899354167' AND WorkspaceId = '1126938837961830'
Globally unique ID of the membership.
Globally unique ID of the user.
The user`s name.
Globally unique ID of the workspace.
The Workspace name
Reflects if this user still a member of the workspace.
Reflects if this user is an admin of the workspace.
Reflects if this user is a guest of the workspace.
A user task list represents the tasks assigned to a particular user.
The base type of this resource.