PortfolioItems
To Create, delete, and Query Items in the Portfolio.
Table Specific Information
Select
The connector will use the Asana API to process WHERE clause conditions built with the following column and operator. The PortfolioId is required to make a request and rest of the filter is executed client side within the connector.
- PortfolioId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PortfolioItems WHERE PortfolioId = '1173026173301164'
Insert
ProjectId and PortfolioId is a mandatory column for inserting into PortfolioItems table. For example:
INSERT INTO PortfolioItems (ProjectId, PortfolioId) VALUES ('1173023668354420', '1173026173301164')
Delete
Following is an example of how to delete from PortfolioItems table:
DELETE FROM PortfolioItems WHERE ProjectId = '1173023668354420' AND PortfolioId = '1173026173301164'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Globally unique ID of the Portfolio Item. | |
| Name | String | True |
Name of the Item. | |
| PortfolioId [KEY] | String | True |
Portfolios.Id |
Globally unique ID of the portfolio. |
| OwnerId | String | True |
Globally unique ID of the Owner. | |
| StartOn | Date | True |
The day on which work for this project begins, or null if the project has no start date. | |
| DueOn | Date | True |
The day on which this project is due. This takes a date with format YYYY-MM-DD. | |
| ProjectId | String | True |
Projects.Id |
Globally unique ID of the Project. This column is a Pseudocolmn and its used for INSERT and UPDATE. |