Reference

Endpoint Get Workspace Teams

Name

get_workspace_teams

Description

Returns records for all teams in the workspace visible to the authorized user.

Related Tables

WorkspaceTeams

Parameters

Parameter Required Options
Name: WorkspaceId

Label: Workspace Id

 YES
Name: Fields

Label: Fields
Option Value
resource_type resource_type
description description
edit_team_name_or_description_access_level edit_team_name_or_description_access_level
edit_team_visibility_or_trash_team_access_level edit_team_visibility_or_trash_team_access_level
guest_invite_management_access_level guest_invite_management_access_level
html_description html_description
join_request_management_access_level join_request_management_access_level
member_invite_management_access_level member_invite_management_access_level
name name
organization organization
organization.name organization.name
permalink_url permalink_url
team_content_management_access_level team_content_management_access_level
team_member_removal_access_level team_member_removal_access_level
visibility visibility
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
Name DT_WSTR nvarchar(255) 255
Description DT_NTEXT nvarchar(MAX)
HtmlDescription DT_NTEXT nvarchar(MAX)
OrganizationId DT_WSTR nvarchar(50) 50
OrganizationName DT_WSTR nvarchar(255) 255
PermalinkUrl DT_WSTR nvarchar(500) 500
Visibility DT_WSTR nvarchar(50) 50
EditTeamNameOrDescriptionAccessLevel DT_WSTR nvarchar(100) 100
EditTeamVisibilityOrTrashTeamAccessLevel DT_WSTR nvarchar(100) 100
MemberInviteManagementAccessLevel DT_WSTR nvarchar(100) 100
GuestInviteManagementAccessLevel DT_WSTR nvarchar(100) 100
JoinRequestManagementAccessLevel DT_WSTR nvarchar(100) 100
TeamContentManagementAccessLevel DT_WSTR nvarchar(100) 100
TeamMemberRemovalAccessLevel DT_WSTR nvarchar(100) 100
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 WorkspaceTeams 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
WorkspaceTeams
Required Parameters
Workspace Id Fill-in the parameter...
Optional Parameters
Continue On 404 Error (When record not found) False
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the WorkspaceTeams table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get workspace teams:

API Destination - Asana
Read and write data related to Tasks, Projects, Workspaces, Portfolios, TimeEntries, Memberships and more.
Asana
WorkspaceTeams
Select
Required Parameters
Workspace Id Fill-in the parameter...
Optional Parameters
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:

Get WorkspaceTeams 

SELECT * FROM WorkspaceTeams

get_workspace_teams endpoint belongs to WorkspaceTeams 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:

Get WorkspaceTeams 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM WorkspaceTeams';

EXEC (@MyQuery) AT [LS_TO_ASANA_IN_GATEWAY];

get_workspace_teams endpoint belongs to WorkspaceTeams table(s), and can therefore be used via those table(s).