FireDAC Components for Azure DevOps

Build 21.0.7930


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

Table Specific Information


The component will use the Azure DevOps API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • Id supports the '=' operator.
  • ProjectId supports the '=' operator.
  • ExpandIdentity supports the '=' operator.
  • Mine supports the '=' operator.
For example:
	SELECT * FROM Teams WHERE ProjectId='66eb7414-f622-4eff-88da-3ad681f19073' AND Id='717f1ce9-ee4f-4009-9622-4d22f46e5af2'
	SELECT * FROM Teams WHERE ExpandIdentity=true


Name Type References Description
Id [KEY] String Unique Identifier of the team.
Description String The description of the team.
IdentityId String Id of the identity.
IdentityIsActive Boolean Indicates whether the identity is active.
IdentityIsContainer Boolean Indicates whether the identity is a container.
IdentityMasterId String Master Id.
IdentityMetaTypeId Integer Meta Type Id.
IdentityProviderDisplayName String The display name for the identity as specified by the source identity provider.
IdentityResourceVersion Integer Resource version.
IdentitySubjectDescriptor String Subject descriptor.
IdentityUrl String Identity REST API URL to this team.
Name String The name of the team.
ProjectId String


The Unique Identifier of the project this team belongs to.
ProjectName String The name of the project this team belongs to.
Url String Team REST API URL.


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.

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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930