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

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 [LS_TO_AZURE_DEVOPS_IN_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 [LS_TO_AZURE_DEVOPS_IN_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 [LS_TO_AZURE_DEVOPS_IN_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 [LS_TO_AZURE_DEVOPS_IN_GATEWAY];