ado_query_analytics
Query Azure DevOps Analytics OData feed to retrieve reporting data from work items, pipeline runs, and builds. Use filters, selections, ordering, and aggregations for customized reports.
Instructions
Query the Analytics OData feed for reporting. Common entity sets: WorkItems, WorkItemSnapshot, PipelineRuns, Builds. Supports $filter/$select/$orderby/$top/$apply (aggregation).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | ||
| apply | No | $apply aggregation transform (e.g. groupby/aggregate) | |
| filter | No | $filter expression | |
| select | No | $select fields | |
| orderby | No | $orderby expression | |
| project | No | Project (defaults to ADO_DEFAULT_PROJECT) | |
| entitySet | Yes | OData entity set, e.g. "WorkItems", "WorkItemSnapshot", "PipelineRuns" |