Asana Connector
Documentation
Version: 1
Documentation

EndPoint Get Allocations


Parameters

Parameter Label Required Options Description
WorkspaceId Workspace Id NO
ProjectId Project Id NO
AssigneeId User Id NO
Limit Limit NO 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 Raw Description
Id DT_WSTR nvarchar(50) 50 False
ResourceSubtype DT_WSTR nvarchar(100) 100 False
AssigneeId DT_WSTR nvarchar(50) 50 False
AssigneeName DT_WSTR nvarchar(255) 255 False
ParentId DT_WSTR nvarchar(50) 50 False
ParentName DT_WSTR nvarchar(255) 255 False
StartDate DT_WSTR nvarchar(50) 50 False
EndDate DT_WSTR nvarchar(50) 50 False
CreatedById DT_WSTR nvarchar(50) 50 False
CreatedByName DT_WSTR nvarchar(255) 255 False
EffortType DT_WSTR nvarchar(50) 50 False
EffortValue DT_I4 int False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw 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 component to read data or in API Destination component to read/write data:

Get Allocations using API Source

Asana
Get Allocations
SSIS API Source - Read from table or endpoint

Get Allocations using API Destination

Asana
Get Allocations
SSIS API Destination - Access table or endpoint