Asana Connector
Documentation
Version: 1
Documentation

EndPoint Get Workspaces


Parameters

Parameter Label Required Options Description
Fields Fields NO
Option Value
resource_type resource_type
email_domains email_domains
is_organization is_organization
name name
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
Name DT_WSTR nvarchar(255) 255 False
EmailDomains DT_WSTR nvarchar(500) 500 False
IsOrganization DT_BOOL bit 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 Workspaces using API Source

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

Get Workspaces using API Destination

Asana
Get Workspaces
SSIS API Destination - Access table or endpoint