Teams
Retrieves a list of all teams and details of specified team.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' operator.
For example:
SELECT * FROM Teams WHERE ProjectId = '837ccd31-8159-4db3' AND Id = '7f1d8582-a070-4d2b'
Insert
The following is an example of inserting into the Teams table:
INSERT INTO Teams (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'TestTeam')
Update
The following is an example of updating the Teams table:
UPDATE Teams SET Name='cdata2' WHERE ProjectId='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id='619e870e-5242-4218-bedd-c52d8c003591'
Delete
Due to the fact that there is no way to distinguish between the API response for a successful and a failed DELETE for this table, the affected row count is always -1.
The following is an example of deleting from the Teams table:
DELETE FROM Teams WHERE ProjectId='b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id ='619e870e-5242-4218-bedd-c52d8c003591'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Unique Identifier of the team. | |
Description | String | False |
The description of the team. | |
IdentityCustomDisplayName | String | True |
The custom display name fro the identity. | |
IdentityId | String | True |
Id of the identity. | |
IdentityIsActive | Boolean | True |
Indicates whether the identity is active. | |
IdentityIsContainer | Boolean | True |
Indicates whether the identity is a container. | |
IdentityMasterId | String | True |
Master Id. | |
IdentityMetaTypeId | Integer | True |
Meta Type Id. | |
IdentityProviderDisplayName | String | True |
The display name for the identity as specified by the source identity provider. | |
IdentityResourceVersion | Integer | True |
Resource version. | |
IdentitySubjectDescriptor | String | True |
Subject descriptor. | |
IdentityUrl | String | True |
Identity REST API URL to this team. | |
Name | String | False |
The name of the team. | |
ProjectId | String | True |
The Unique Identifier of the project this team belongs to. | |
ProjectName | String | True |
The name of the project this team belongs to. | |
Url | String | True |
Team REST API URL. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements, and offer a more granular control over the tuples that are returned from the data source. Unless otherwise specified, only the = operator is permitted when filtering on pseudocolumns.
Name | Type | Description |
ExpandIdentity | Boolean |
A value indicating whether or not to expand Identity information in the result WebApiTeam object. |
Mine | Boolean |
Return all teams requesting user is member. Otherwise return all teams user has read access. |