ProjectMembership
To Create, Delete and Query memberships in the Project.
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.
- ProjectId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM ProjectMembership WHERE Id = '1127092449876445' SELECT * FROM ProjectMembership WHERE ProjectId = '1127092449876444'
Insert
UserId and ProjectId is a mandatory column for inserting into ProjectMembership table. For example:
INSERT INTO ProjectMembership (UserId, ProjectId) VALUES ('1161963899354167', '1128092964672848')
Delete
Following is an example of how to delete from ProjectMembership table:
DELETE FROM ProjectMembership WHERE UserId = '1161963899354167' AND ProjectId = '1128092964672848'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Globally unique ID of the project membership. | |
ProjectId [KEY] | String | False |
Projects.Id |
The project the user is a member of. |
WriteAccess | String | True |
Whether the user has full access to the project or has comment-only access. | |
UserId [KEY] | String | False |
Users.Id |
The user in the membership. |
ResourceType | String | True |
The resource type of this resource. | |
MemberResourceType | String | True |
The resource type of the member (team or user). |