Endpoint Get Memberships
Name
get_memberships
Description
Related Tables
Parameters
Parameter | Required | Options | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Name:
Label: Project Id |
||||||||||||||||||||||||||
Name:
Label: PortfolioId |
||||||||||||||||||||||||||
Name:
Label: GoalId |
||||||||||||||||||||||||||
Name:
Label: Member or Team Id (Use with Project OR Portfolio OR Goal) |
||||||||||||||||||||||||||
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 | |
ResourceSubtype |
DT_WSTR
|
nvarchar(100)
|
100 | |
MemberId |
DT_WSTR
|
nvarchar(50)
|
50 | |
MemberName |
DT_WSTR
|
nvarchar(255)
|
255 | |
ParentId |
DT_WSTR
|
nvarchar(50)
|
50 | |
ParentName |
DT_WSTR
|
nvarchar(255)
|
255 | |
ParentOwnerId |
DT_WSTR
|
nvarchar(50)
|
50 | |
ParentOwnerName |
DT_WSTR
|
nvarchar(255)
|
255 | |
AccessLevel |
DT_WSTR
|
nvarchar(50)
|
50 | |
PortfolioId |
DT_WSTR
|
nvarchar(50)
|
50 | |
PortfolioName |
DT_WSTR
|
nvarchar(255)
|
255 | |
UserId |
DT_WSTR
|
nvarchar(50)
|
50 | |
UserName |
DT_WSTR
|
nvarchar(255)
|
255 |
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 Memberships table, therefore it is better to use it, instead of accessing the endpoint directly:
Optional Parameters | |
---|---|
Project Id | |
PortfolioId | |
GoalId | |
Member or Team Id (Use with Project OR Portfolio OR Goal) | |
Continue On 404 Error (When record not found) | False |

API Destination
This Endpoint belongs to the Memberships table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get memberships:
Optional Parameters | |
---|---|
Project Id | |
PortfolioId | |
GoalId | |
Member or Team Id (Use with Project OR Portfolio OR Goal) | |
Continue On 404 Error (When record not found) | False |

ODBC application
Use these SQL queries in your ODBC application data source:
Read Memberships for a project
Read Memberships for a specific project.
SELECT * FROM Memberships WITH(ProjectId=1206673375982078)
Read Memberships for a project
Read Memberships for a specific project.
SELECT * FROM Memberships WITH(PortfolioId=1206673375982077)
get_memberships
endpoint belongs to
Memberships
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:
Read Memberships for a project
Read Memberships for a specific project.
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Memberships WITH(ProjectId=1206673375982078)';
EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];
Read Memberships for a project
Read Memberships for a specific project.
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Memberships WITH(PortfolioId=1206673375982077)';
EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];
get_memberships
endpoint belongs to
Memberships
table(s), and can therefore be used via those table(s).