Create Team
Name
add_team
Description
Creates a new team in the default project within the organization. [API reference]
Related Tables
Parameters
Parameter | Label | Required | Options | Description |
---|---|---|---|---|
Name | Team Name | YES | The name of the team. | |
Description | Team Description | YES | The description of the team. |
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
PluginId |
DT_WSTR
|
nvarchar(200)
|
200 | False |
|
Status |
DT_WSTR
|
nvarchar(100)
|
100 | False |
|
Url |
DT_WSTR
|
nvarchar(2048)
|
2048 | False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Name |
DT_WSTR
|
nvarchar(200)
|
200 | False |
The name of the team. |
Description |
DT_WSTR
|
nvarchar(500)
|
500 | False |
The description of the team. |
Examples
SSIS
Use Azure DevOps Connector in API Source component to read data or in API Destination component to read/write data:
Insert into 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:

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