ADO.NET Provider for Asana

Build 22.0.8397


To Create, Delete and Query memberships in the Project.

Table Specific Information


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'


UserId and ProjectId is a mandatory column for inserting into ProjectMembership table. For example:

INSERT INTO ProjectMembership (UserId, ProjectId) VALUES ('1161963899354167','1128092964672848')


Following is an example of how to delete from ProjectMembership table:

DELETE FROM ProjectMembership WHERE UserId = '1161963899354167' AND ProjectId = '1128092964672848'


Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the project membership.

ProjectId [KEY] String False


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


The user in the membership.

ResourceType String True

The resource type of this resource.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8397