Endpoint Get Portfolios
Name
get_portfolios
Description
Related Tables
Parameters
| Parameter | Required | Options | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Name:
Label: Owner Id |
YES | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Name:
Label: Workspace Id |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Name:
Label: Fields |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Name:
Label: Limit Results per page. The number of objects to return per page. The value must be between 1 and 100. |
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
|---|---|---|---|---|
| Id |
DT_WSTR
|
nvarchar(50)
|
50 | |
| Name |
DT_WSTR
|
nvarchar(255)
|
255 | |
| Color |
DT_WSTR
|
nvarchar(50)
|
50 | |
| CreatedAt |
DT_DBTIMESTAMP
|
datetime
|
||
| CreatedById |
DT_WSTR
|
nvarchar(50)
|
50 | |
| CreatedByName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| CustomFieldSettings |
DT_NTEXT
|
nvarchar(MAX)
|
||
| CurrentStatusUpdateId |
DT_WSTR
|
nvarchar(50)
|
50 | |
| CurrentStatusUpdateTitle |
DT_WSTR
|
nvarchar(100)
|
100 | |
| CurrentStatusUpdateResourceSubtype |
DT_WSTR
|
nvarchar(100)
|
100 | |
| DueOn |
DT_WSTR
|
nvarchar(50)
|
50 | |
| CustomFields |
DT_WSTR
|
nvarchar(4000)
|
4000 | |
| Members |
DT_WSTR
|
nvarchar(500)
|
500 | |
| OwnerId |
DT_WSTR
|
nvarchar(50)
|
50 | |
| OwnerName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| StartOn |
DT_WSTR
|
nvarchar(50)
|
50 | |
| WorkspaceId |
DT_WSTR
|
nvarchar(50)
|
50 | |
| WorkspaceName |
DT_WSTR
|
nvarchar(255)
|
255 | |
| PermalinkUrl |
DT_WSTR
|
nvarchar(500)
|
500 | |
| Public |
DT_BOOL
|
bit
|
||
| DefaultAccessLevel |
DT_WSTR
|
nvarchar(50)
|
50 | |
| PrivacySetting |
DT_WSTR
|
nvarchar(50)
|
50 | |
| ProjectTemplates |
DT_WSTR
|
nvarchar(500)
|
500 |
If the column you are looking for is missing, consider customizing Asana Connector.
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Description | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Asana Connector in API Source or in API Destination SSIS Data Flow components to read or write data.
API Source
This Endpoint belongs to the Portfolios table, therefore it is better to use it, instead of accessing the endpoint directly:
API Source - Asana
Read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required.
Asana
Portfolios
| Required Parameters | |
|---|---|
| Owner Id | Fill-in the parameter... |
| Optional Parameters | |
| Workspace Id | |
| Continue On 404 Error (When record not found) | False |
API Destination
This Endpoint belongs to the Portfolios table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get portfolios:
API Destination - Asana
Read and write Asana data effortlessly. Integrate, manage, and automate tasks, projects, workspaces, and time entries — almost no coding required.
Asana
Portfolios
Select
| Required Parameters | |
|---|---|
| Owner Id | Fill-in the parameter... |
| Optional Parameters | |
| Workspace Id | |
| Continue On 404 Error (When record not found) | False |
ODBC application
Use these SQL queries in your ODBC application data source:
List portfolios by owner
<p>Returns portfolios for a specified owner (user) in the default workspace. Supply the owner's user ID. Portfolios group projects for high-level tracking and goals. You can optionally scope to a specific workspace when you have more than one.</p>
SELECT * FROM Portfolios WITH(OwnerId='1200442904128317')List portfolios by owner and workspace
<p>Returns portfolios for a specified owner and workspace. Supply both the owner's user ID and the workspace ID. Use this when you have multiple workspaces and need portfolios scoped to a single workspace.</p>
SELECT * FROM Portfolios WITH(OwnerId='1200442904128317', WorkspaceId='1200442900140748')
get_portfolios endpoint belongs to
Portfolios
table(s), and can therefore be used via those table(s).
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
List portfolios by owner
<p>Returns portfolios for a specified owner (user) in the default workspace. Supply the owner's user ID. Portfolios group projects for high-level tracking and goals. You can optionally scope to a specific workspace when you have more than one.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Portfolios WITH(OwnerId=''1200442904128317'')';
EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];List portfolios by owner and workspace
<p>Returns portfolios for a specified owner and workspace. Supply both the owner's user ID and the workspace ID. Use this when you have multiple workspaces and need portfolios scoped to a single workspace.</p>
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Portfolios WITH(OwnerId=''1200442904128317'', WorkspaceId=''1200442900140748'')';
EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];
get_portfolios endpoint belongs to
Portfolios
table(s), and can therefore be used via those table(s).