ODBC Driver for Asana

Build 23.0.8839


To Create, Delete and Query memberships in the Portfolio.

Table Specific Information


The 本製品 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 本製品.

  • 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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839