Automate extracting Devops work Items

New Contributor

Hello there. 

Is there a way to automate the process of exporting all work items from a devops project out to csv’s  

Kind Regards 

Rob

2 Replies
You could use the Azure DevOps API. You can call the Get Backlog Level Work Items: https://docs.microsoft.com/en-us/rest/api/azure/devops/work/backlogs/get%20backlog%20level%20work%20... This will get all the Backlog Item IDs, but not the detail. You can then use Work Items - List to get all the details, but this only accepts 200 IDs per request. Therefore, you will need to batch the IDs from the first call. https://docs.microsoft.com/en-us/rest/api/azure/devops/wit/work%20items/list?view=azure-devops-rest-... This does reply back as JSON, so can use script like PowerShell to convert to CSV file. Hope this helps
Thank you very much, I shall look into your suggestions.

Stay safe

Regards Rob