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).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"entitySet": "<entitySet>"
},
"name": "ado_query_analytics"
}
}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" |