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

Label

Required

Options

Description

WorkspaceId

Workspace Id

YES

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

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	Raw
Id	`DT_WSTR`	`nvarchar(50)`	50	`False`
Name	`DT_WSTR`	`nvarchar(255)`	255	`False`
Description	`DT_NTEXT`	`nvarchar(MAX)`		`False`
HtmlDescription	`DT_NTEXT`	`nvarchar(MAX)`		`False`
OrganizationId	`DT_WSTR`	`nvarchar(50)`	50	`False`
OrganizationName	`DT_WSTR`	`nvarchar(255)`	255	`False`
PermalinkUrl	`DT_WSTR`	`nvarchar(500)`	500	`False`
Visibility	`DT_WSTR`	`nvarchar(50)`	50	`False`
EditTeamNameOrDescriptionAccessLevel	`DT_WSTR`	`nvarchar(100)`	100	`False`
EditTeamVisibilityOrTrashTeamAccessLevel	`DT_WSTR`	`nvarchar(100)`	100	`False`
MemberInviteManagementAccessLevel	`DT_WSTR`	`nvarchar(100)`	100	`False`
GuestInviteManagementAccessLevel	`DT_WSTR`	`nvarchar(100)`	100	`False`
JoinRequestManagementAccessLevel	`DT_WSTR`	`nvarchar(100)`	100	`False`
TeamContentManagementAccessLevel	`DT_WSTR`	`nvarchar(100)`	100	`False`
TeamMemberRemovalAccessLevel	`DT_WSTR`	`nvarchar(100)`	100	`False`

If the column you are looking for is missing, consider customizing Asana Connector.

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:

Read from WorkspaceTeams table using API Destination

This Endpoint belongs to WorkspaceTeams table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Asana

WorkspaceTeams

Select

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get workspace teams

SELECT * FROM get_workspace_teams
WITH
(
    "WorkspaceId" = 'abcd-1234-workspaceid'
)

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 workspace teams

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_workspace_teams
WITH
(
    "WorkspaceId" = ''abcd-1234-workspaceid''
)';

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