Excel Add-In for Azure DevOps

Build 24.0.9060

Projects

List Projects

Table Specific Information

Select

The add-in uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

  • ProjectSK supports the '=,in' operator.
The rest of the filter is executed client-side in the add-in.

For example:

	SELECT * FROM Projects WHERE ProjectSK = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Projects WHERE ProjectSK IN ('837ccd31-8159-4db3-b8ce-de0c36d2a0bf', '837ccd31-8159-4db3-b8ce-de0c36d2a0hg')

Columns

Name Type References Description
ParentReference String
ProjectSK [KEY] String
ProjectId String
ProjectName String
ProjectVisibility String

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