Excel Add-In for Azure DevOps

Build 24.0.9060

BuildDemands

Retrieves a list of demands that represents the agent capabilities required by the build.

Table Specific Information

Select

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

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


NOTE: To improve performance, a single BuildId should be specified in the WHERE clause of the query.

For example:

    SELECT * FROM BuildDemands WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND BuildId = 6

Columns

Name Type References Description
ProjectId String Id of the project.
BuildId [KEY] Integer

Builds.Id

Id of the build.
Name [KEY] String The name of the capability referenced by the demand.
Value String The demanded value.

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