JDBC Driver for Asana

Build 23.0.8839

Portfolios

To Create, update, delete, and query from Portfolios table.

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 OwnerId] 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.
  • OwnerId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Portfolios WHERE WorkspaceId = '1172686716695308' AND OwnerId = '1172686741877880'

SELECT * FROM Portfolios WHERE Id = '1172684730399265'

Insert

WorkspaceId is a mandatory column for inserting into Portfolios table. For example:

INSERT INTO Portfolios (Name, Color, WorkspaceId)  VALUES ('Test', 'dark-pink', '1172686716695308'

Update

Following is an example of how to update a Portfolios table:

"UPDATE Portfolios SET Name = 'IT-Test' WHERE Id = '1173026173301164'

Delete

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

DELETE FROM Portfolios WHERE Id = '1172684730399265'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Globally unique ID of the portfolio.

Name String False

Name of the portfolio.

Color String False

Color of the portfolio.

The allowed values are dark-pink, dark-green, dark-blue, dark-red, dark-teal, dark-brown, dark-orange, dark-purple, dark-warm-gray, light-pink, light-green, light-blue, light-red, light-teal, light-brown, light-orange, light-purple, light-warm-gray.

CreatedAt Datetime True

The time at which this portfolio was created.

CreatorId String True

Globally unique ID of the user created this portfolio.

CreatorName String True

The users name.

Members String False

Array of users who are members of this portfolio.

OwnerId String False

Users.Id

Globally unique ID of the Owner.

OwnerName String True

The Owners Name.

ResourceType String True

The base type of this resource.

WorkspaceId String False

Workspaces.Id

The workspace or organization that the portfolio belongs to.

WorkspaceName String True

Name of the workspace.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839