Reference

Endpoint Get Memberships

Name

get_memberships

Description

Related Tables

Memberships

Parameters

Parameter Required Options
Name: ProjectId

Label: Project Id
Name: PortfolioId

Label: PortfolioId
Name: GoalId

Label: GoalId
Name: MemberId

Label: Member or Team Id (Use with Project OR Portfolio OR Goal)
Name: Fields

Label: Fields
Option Value
name name
resource_subtype resource_subtype
member member
member.name member.name
parent parent
parent.name parent.name
parent.owner parent.owner
parent.owner.name parent.owner.name
access_level access_level
portfolio.name portfolio.name
user.name user.name
Name: Limit

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
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 Memberships table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
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
SSIS API Source - Read from table or endpoint

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:

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
Memberships
Select
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
SSIS API Destination - Access table operation

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).