Forum Discussion
masterdineen
Jan 13, 2021Copper Contributor
Automate extracting Devops work Items
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
- cpatemanCopper ContributorYou 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%20items?view=azure-devops-rest-6.1 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-6.1 This does reply back as JSON, so can use script like PowerShell to convert to CSV file. Hope this helps
- masterdineenCopper ContributorThank you very much, I shall look into your suggestions.
Stay safe
Regards Rob