Forum Discussion
Get Azure DevOps work item daily historical data using OData query
Hi, I have a report where I need to get the daily historical data of a work item. At the moment, I use Azure DevOps's analytics views to get this data by setting the "granularity" to "daily". For...
artemus
Microsoft Employee
Microsoft EmployeeYour best bet is to just use the ADO rest APIs, it has additional operations that odata doesn't.
To use the REST api:
- Go here to craft the URL: Get started with the REST APIs for Azure DevOps Services and Team Foundation Server - Azure DevOps Services REST API | Microsoft Learn
- Use the Power Query formula: VSTS.Contents(url) where url is from step 1 (Web.Contents will not work).