Teams
List Teams
Table Specific Information
Select
The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- TeamSK supports the '=,in' operator.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM Teams WHERE TeamSK = '66eb7414-f622-4eff-88da-3ad681f19073'
SELECT * FROM Teams WHERE TeamSK IN ('4dbc0cec-c473-652b-972f-f42587b4494d', '6ddc3cee-c232-634b-342f-f84325b4494d')
Columns
| Name | Type | References | Description |
| ParentReference | String | Parent reference. Only available if IncludeReferenceColumn=true. | |
| TeamSK [KEY] | String | Team surrogate key. | |
| AnalyticsUpdatedDate | Datetime | Watermark that indicates the last time the Analytics data was updated. | |
| ProjectSK | String | Project surrogate key. | |
| TeamId | String | Unique ID assigned to the team at creation. | |
| TeamName | String | Team name. |