Forum Discussion
Export Azure DevOps Pipelines Generated Work Items
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.
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.
Hi,
Is it possible to call more than 50 linked work items using the DevOps REST API?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.1Hi,
I assume you are referring to https://learn.microsoft.com/en-us/rest/api/azure/devops/build/builds/get-build-work-items-refs?view=azure-devops-rest-7.1 . The API has a $top parameter, which is implicitly set to 50, but you can exceed that if you explicitly use the parameter with a larger number in your call.
Hi,
I will take note of your suggestions.
Thank you for your assistance!Happy to help! :)
