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
MemberId and ProjectId is a mandatory column for inserting into ProjectMembership table. For example:
INSERT INTO ProjectMembership (MemberId, ProjectId) VALUES ('1161963899354167', '1128092964672848')
Note : MemberId should be Id of a user for insert.
Delete
Following is an example of how to delete from ProjectMembership table:
DELETE FROM ProjectMembership WHERE MemberId = '1161963899354167' AND ProjectId = '1128092964672848'
Note : MemberId should be Id of a user for delete.
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. | |
| MemberId [KEY] | String | False |
The Id of user or team in the membership. | |
| ResourceType | String | True |
The resource type of this resource. | |
| MemberResourceType | String | True |
The resource type of the member (team or user). | |
| ResourceSubtype | String | True |
Type of the membership. |