JDBC Driver for Asana

Build 23.0.8839

PortfolioMembership

To Create, Delete and Query memberships in the Portfolio.

Table Specific Information

Select

The driver 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 driver.

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

Insert

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

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

Delete

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

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

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the portfoolio membership.

PortfolioId [KEY] String True

Portfolios.Id

The portfolio the user is a member of.

PortfolioName String True

The name of the portfolio.

UserId [KEY] String True

Users.Id

Globally unique ID of the user.

UserName String True

The users name.

ResourceType String True

The resource type of this resource.

WorkspaceId String True

Workspaces.Id

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