Teams
Retrieves a list of all teams and details of specified team.
Table Specific Information
Select
The connector 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。 特に指定がない限り、擬似カラムでフィルタリングを行う場合は = 演算子のみ使用できます。
| 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. |