Forum Discussion
Export Azure DevOps Pipelines Generated Work Items
Hi,
Is there a way to export the work items linked to the Build or Release pipelines into an Excel file?
Hi,
there is an Azure DevOps Office Integration (Plugin), which allows to edit work items directly in Excel: https://learn.microsoft.com/en-us/azure/devops/boards/backlogs/office/bulk-add-modify-work-items-excel?view=azure-devops&tabs=agile-process.
But tbh, I never used or worked with that.Alternatively, you can use the DevOps REST API to execute your tasks programmatically (e.g. with a python script). There are calls available to get builds and their linked work items.
9 Replies
- MoritzGIron Contributor
Hi,
there is an Azure DevOps Office Integration (Plugin), which allows to edit work items directly in Excel: https://learn.microsoft.com/en-us/azure/devops/boards/backlogs/office/bulk-add-modify-work-items-excel?view=azure-devops&tabs=agile-process.
But tbh, I never used or worked with that.Alternatively, you can use the DevOps REST API to execute your tasks programmatically (e.g. with a python script). There are calls available to get builds and their linked work items.
- gemberbarrosoCopper Contributor
Hi,
Is it possible to call more than 50 linked work items using the DevOps REST API?- gemberbarrosoCopper Contributor
Hi,
I have already called more than 50. The maximum is 200.
https://learn.microsoft.com/en-us/rest/api/azure/devops/build/builds/get-work-items-between-builds?view=azure-devops-rest-6.1
- gemberbarrosoCopper Contributor
Hi,
I will take note of your suggestions.
Thank you for your assistance!- MoritzGIron Contributor
Happy to help! :)
- gemberbarrosoCopper Contributor
Hi,
I was just wondering if that’s the only available option to export the work items? I’ve tried applying detailed filters—such as title, state, assigned to, and date—to help exclude unrelated or unlinked items.
For now, I’ve been copying and pasting the work items directly into Excel, as I find it more convenient than managing the filters through the query. - gemberbarrosoCopper Contributor
Hi, thank you so much for your response!
I was just wondering if that’s the only available option to export the work items? I’ve tried applying detailed filters—such as title, state, assigned to, and date—to help exclude unrelated or unlinked work items.
For now, I've been copying and pasting the work items directly into Excel, as it is more convenient than filtering them through the query. - MoritzGIron Contributor
Hi,
you could use a DevOps Query to get the work items and then export the results of the query to excel. To do so:
- In Azure DevOps, go to Boards > Queries.
- Create a new query that filters work items based on the linked builds
- Run the query, then use the "Export to Excel" option.