SSIS Components for Azure DevOps

Build 24.0.9060

BuildPlans

Retrieves the list of orchestration plans associated with 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: BuildId is required in order to query BuildPlans.

For example:

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

Columns

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

Builds.Id

Id of the build for which this log was created.
OrchestrationType Integer The type of the plan.
PlanId String The Id of the plan.

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