ADO.NET Provider for Asana

Build 20.0.7655

ProjectMembership

To Create, Delete and Query memberships in the Project

Table Specific Information

Select

The {i 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 {i.

  • 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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655