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 


2 Replies
You could use the Azure DevOps API. You can call the Get Backlog Level Work Items: 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. 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