Reference

Endpoint Create Team

Name

add_team

Description

Creates a new team in the default project within the organization. [API reference]

Related Tables

Teams

Parameters

Parameter	Required	Options
Name: Name Label: Team Name The name of the team.	YES
Name: Description Label: Team Description The description of the team.	YES

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length
Id	`DT_WSTR`	`nvarchar(200)`	200
PluginId	`DT_WSTR`	`nvarchar(200)`	200
Status	`DT_WSTR`	`nvarchar(100)`	100
Url	`DT_WSTR`	`nvarchar(2048)`	2048

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

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Description
Name	`DT_WSTR`	`nvarchar(200)`	200	The name of the team.
Description	`DT_WSTR`	`nvarchar(500)`	500	The description of the team.

Required columns that you need to supply are bolded.

Examples

SSIS

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

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 create team:

API Destination - Azure DevOps

Azure DevOps Connector can be used to integrate Azure DevOps data in your App / BI Tools. You can create, read, query, modify, and delete WorkItems, Projects, Teams and more.

Azure DevOps

Teams

Insert

There are no parameters to configure.

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

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')

add_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:

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

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