TeamMembers
Retrieves a list of members for a specific team.
Table Specific Information
Select
The connector 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 connector.
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. |