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
Parameters
Parameter | Required | Options |
---|---|---|
Name:
Label: Project Name The Name of the project. |
YES |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Description |
---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(200)
|
200 | |
Name |
DT_WSTR
|
nvarchar(200)
|
200 | |
ProjectId |
DT_WSTR
|
nvarchar(200)
|
200 | |
ProjectName |
DT_WSTR
|
nvarchar(200)
|
200 | |
Url |
DT_WSTR
|
nvarchar(2048)
|
2048 | |
Description |
DT_WSTR
|
nvarchar(4000)
|
4000 | |
IdentityUrl |
DT_WSTR
|
nvarchar(2048)
|
2048 |
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 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:
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:
Required Parameters | |
---|---|
Project Name | Fill-in the parameter... |

ODBC application
Use these SQL queries in your ODBC application data source:
Get a list of all teams associated with your organization and default project
SELECT * FROM Teams
Get a list of all teams associated with your organization and the specified project Id
SELECT * FROM Teams WITH (Project='841e1641-325d-49b1-9c5e-22c11a61d4c4')
Get specific columns of a list of all teams associated with your organization and default project
SELECT Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl FROM Teams
get_teams
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 a list of all teams associated with your organization and default project
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Teams';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];
Get a list of all teams associated with your organization and the specified project Id
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Teams WITH (Project=''841e1641-325d-49b1-9c5e-22c11a61d4c4'')';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];
Get specific columns of a list of all teams associated with your organization and default project
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT Id, Name, ProjectId, ProjectName, Url, Description, IdentityUrl FROM Teams';
EXEC (@MyQuery) AT [LS_TO_AZURE_DEVOPS_IN_GATEWAY];
get_teams
endpoint belongs to
Teams
table(s), and can therefore be used via those table(s).