ODBC Driver for Azure DevOps

Build 24.0.9060

Teams

Retrieves a list of all teams and details of specified team.

Table Specific Information

Select

The driver uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • Id supports the '=' operator.
The rest of the filter is executed client-side in the driver.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060