Excel Add-In for Azure DevOps

Build 24.0.9060

BuildDefinitionMetrics

Retrieves metadata for the specific 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:

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


NOTE: DefinitionId is required in order to query BuildDefinitionMetrics.

For example:

    SELECT * FROM BuildDefinitionMetrics WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND DefinitionId = 2

Columns

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

BuildDefinitions.Id

Id of the build definition.
Date Datetime The date for the scope.
IntValue Integer The value.
Name String The name of the metric.
Scope String The scope.

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