Endpoint

Get Team Details

Name

get_team

Description

Gets the details of the specified team in the default project within the organization by its team Id or team name. [API reference]

Related Tables

Teams

Parameters

Parameter

Label

Required

Options

Description

ApiVersion

API Version

YES

Option	Value
7.0-preview	7.0-preview
7.1-preview.2	7.1-preview.2

Team Id or Name

YES

Project

Project Name

YES

The Name of the project.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_WSTR`	`nvarchar(200)`	200	`False`
Name	`DT_WSTR`	`nvarchar(200)`	200	`False`
ProjectId	`DT_WSTR`	`nvarchar(200)`	200	`False`
ProjectName	`DT_WSTR`	`nvarchar(200)`	200	`False`
Url	`DT_WSTR`	`nvarchar(2048)`	2048	`False`
Description	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
IdentityUrl	`DT_WSTR`	`nvarchar(2048)`	2048	`False`

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

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_WSTR`	`nvarchar(300)`	300	`False`

Required columns that you need to supply are bolded.

Examples

SSIS

Use Azure DevOps Connector in API Source component to read data or in API Destination component to read/write data:

Lookup a row in Teams table using API Destination

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

Azure DevOps

Teams

Lookup

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get team details

SELECT * FROM get_team
WHERE Id = 'abcd-1234-id'
WITH
(
    "ApiVersion" = '7.0-preview',
    "Project" = 'abcd-1234-project'
)

Get details about a specific team within your default project by its team Id

SELECT * FROM Teams WHERE Id='a0aa750f-1550-44af-a056-223696077df6'

get_team endpoint belongs to Teams 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 team details

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_team
WHERE Id = ''abcd-1234-id''
WITH
(
    "ApiVersion" = ''7.0-preview'',
    "Project" = ''abcd-1234-project''
)';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

Get details about a specific team within your default project by its team Id

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Teams WHERE Id=''a0aa750f-1550-44af-a056-223696077df6''';

EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];

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