Endpoint Get List of Teams

Name

get_teams

Description

Gets a list of teams in the default project within the organization. [API reference]

Related Tables

Teams

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Azure DevOps Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Teams table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Azure DevOps

Read and write Azure DevOps (Cloud or On-Premises) data effortlessly. Integrate, manage, and automate work items, projects, and teams — almost no coding required.

Azure DevOps

Teams

Required Parameters
Project Name	Fill-in the parameter...

API Destination

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

API Destination - Azure DevOps

Read and write Azure DevOps (Cloud or On-Premises) data effortlessly. Integrate, manage, and automate work items, projects, and teams — almost no coding required.

Azure DevOps

Teams

Select

Required Parameters
Project Name	Fill-in the parameter...

ODBC application

Use these SQL queries in your ODBC application data source:

List teams (default project)

<p>Returns all teams in the default project from the connection. Use this to discover team names and IDs for use in queries or when creating work items. Columns include Id, Name, ProjectId, ProjectName, Url, and Description.</p>

SELECT * FROM Teams

List teams for a project

<p>Returns all teams in a specific project by passing the project ID (or name) in the WITH clause. Use when the default project is not the one you need or when you are iterating over multiple projects.</p>

SELECT * FROM Teams WITH (Project='841e1641-325d-49b1-9c5e-22c11a61d4c4')

List teams (specific columns)

<p>Returns teams with only the columns you select (e.g. Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl). Use this to keep result sets small or to build pickers and reports that need a subset of team fields.</p>

SELECT Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl FROM Teams

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List teams (default project)

<p>Returns all teams in the default project from the connection. Use this to discover team names and IDs for use in queries or when creating work items. Columns include Id, Name, ProjectId, ProjectName, Url, and Description.</p>

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

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

List teams for a project

<p>Returns all teams in a specific project by passing the project ID (or name) in the WITH clause. Use when the default project is not the one you need or when you are iterating over multiple projects.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Teams WITH (Project=''841e1641-325d-49b1-9c5e-22c11a61d4c4'')';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

List teams (specific columns)

<p>Returns teams with only the columns you select (e.g. Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl). Use this to keep result sets small or to build pickers and reports that need a subset of team fields.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl FROM Teams';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];