SSIS Components 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 component 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 component.


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