Azure DevOps Connector
Documentation
Version: 2
Documentation
Home » API Integration Hub » Azure DevOps Connector » Tables » Teams

Table Teams

Description

No description available

Parameters

Parameter Label Required Options Description Help
There are no parameters

Supported Operations

Below section contains supported CRUD operations. Each operation is executed by some EndPoint behind the scene.
Method Supported Reference EndPoint
SELECT get_teams
INSERT add_team
UPDATE update_team
UPSERT
DELETE delete_team
LOOKUP get_team

Examples

SSIS

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

Read from Teams table using API Source

Azure DevOps
Teams
SSIS API Source - Read from table or endpoint

Read/write to Teams table using API Destination

Azure DevOps
Teams
Select
SSIS API Destination - Access table operation

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 details about a specific team within your default project by its team Id. 

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

Create a team within the default project for the organization. 

INSERT INTO Teams (Name, Description) VALUES
('PosProject Team', 'This is the team who will be working on the Point of Service project.')

Create a team within the specified project for the organization. 

INSERT INTO Teams (Name, Description) VALUES
('PosProject Team', 'This is the team who will be working on the Point of Service project.')
WITH (ProjectId='85kd1641-5555-49b1-9c5e-22c22a61d4c4')

Update a team within the default project for the organization by its team Id. 

UPDATE Teams SET	Name = 'PointOfServiceProject Team' WHERE Id='8djr4d07-5555-5555-9552-0b6d7je99w7f'

Delete the specified team by its Id. 

DELETE FROM Teams WHERE Id='8djr4d07-5555-5555-9552-0b6d7je99w7f'

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 [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_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 [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_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 [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_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 [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Create a team within the default project for the organization. 

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Teams (Name, Description) VALUES
(''PosProject Team'', ''This is the team who will be working on the Point of Service project.'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Create a team within the specified project for the organization. 

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO Teams (Name, Description) VALUES
(''PosProject Team'', ''This is the team who will be working on the Point of Service project.'')
WITH (ProjectId=''85kd1641-5555-49b1-9c5e-22c22a61d4c4'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Update a team within the default project for the organization by its team Id. 

DECLARE @MyQuery NVARCHAR(MAX) = 'UPDATE Teams SET	Name = ''PointOfServiceProject Team'' WHERE Id=''8djr4d07-5555-5555-9552-0b6d7je99w7f''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];

Delete the specified team by its Id. 

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Teams WHERE Id=''8djr4d07-5555-5555-9552-0b6d7je99w7f''';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_AZURE_DEVOPS_IN_DATA_GATEWAY];