ADO.NET Provider for Asana

Build 22.0.8397


To Create, Delete and Query memberships in the Portfolio.

Table Specific Information


The {i will use the Asana API to process WHERE clause conditions built with the following column and operator. The [WorkspaceId AND UserId] OR PortfolioId OR Id is required to make a request and rest of the filter is executed client side within the {i.

  • Id supports the '=' comparison.
  • WorkspaceId supports the '=' comparison.
  • UserId supports the '=' comparison.
  • PortfolioId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PortfolioMembership WHERE WorkspaceId='1172686716695308' AND UserId='1172686741877880'

SELECT * FROM PortfolioMembership WHERE PortfolioId='1172684730399265'

SELECT * FROM PortfolioMembership WHERE Id='1172684730399266'


PortfolioId and UserId is a mandatory column for inserting into PortfolioMembership table. For example:

INSERT INTO PortfolioMembership (PortfolioId, UserId)  VALUES ('1172684730399265', '1172686741877880')


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

DELETE FROM PortfolioMembership WHERE PortfolioId='1172684730399265' AND UserId='1172686741877880'


Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the portfoolio membership.

PortfolioId [KEY] String True


The portfolio the user is a member of.

PortfolioName String True

The name of the portfolio.

UserId [KEY] String True


Globally unique ID of the user.

UserName String True

The users name.

ResourceType String True

The resource type of this resource.

WorkspaceId String True


Globally unique ID of the workspace. This column is a Pseudocolmn and its used in SELECT Query.

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