ProjectMembership
To create, delete and query memberships in the Project.
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.
- 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. |