TeamMembers
Retrieves a list of members for a specific team.
Table Specific Information
Select
The provider uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- TeamId supports the '=' operator.
The rest of the filter is executed client-side in the provider.
NOTE: TeamId is required in order to query TeamMembers.
For example:
SELECT * FROM TeamMembers WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40'
Columns
Name | Type | References | Description |
ProjectId | String | The Project Identifier to which this team belongs to. | |
TeamId | String |
Teams.Id | The Team Identifier to which this member belongs to. |
IdentityDescriptor | String | The descriptor is the primary way to reference the graph subject while the system is running. | |
IdentityDisplayName | String | This is the non-unique display name of the member. | |
IdentityId | String | Unique Id of the member. | |
IdentityUrl | String | This url is the full route to the source resource of this graph subject. | |
IsTeamAdmin | Boolean | Indicates if this member is admin of the team. |