Excel Add-In for Azure DevOps

Build 24.0.9060

Teams

List Teams

Table Specific Information

Select

The add-in 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 add-in.

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
TeamSK [KEY] String
ProjectSK String
TeamId String
TeamName String

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