Need to export manual test runs execution results from AzureDevOps to any Format

4.3k Views Asked by At

We need to export the latest run with every step and its attachments in AzureDevOps. It is a 300 Test Cases run/execution report that needs to be approved, as we have many use cases, it is not plausible to go one run by one run and download every attachment step and print it by hand.

I tried exporting TestPlans, the export from Test Plan does not apply in this case as it does not care about the runs steps and its attachments. I do not see a solution with the new AzureDevOps run Page,

Would like to know if I am missing any configuration option or if there is an API or even product to export the data. e.g. Example one of many Runs to save in Report Many

I saw other similar questions but still missing how to export runs reports with its steps and attachment. Image below,

Example of one of the 300 runs to export

Many Thanks

UPDATE: As I do not see any an out of the box solution I am trying to get the information from this API ResultsAPI but I am not able yet to get the ActionResultModel that includes the stepIdentifier. Also problems downloading the attachments.

2

There are 2 best solutions below

3
On

You have a try with the export option in Test Plans. First you need to create a test plan and add all your manual test cases using query to this test plan.

You can follow the detailed steps of Creating test plans and test suites.

Go to Test plans under Test Plans of your project. Then click the 3 dots beside your test plan and selet Export

enter image description here

Then check the options you to export.

enter image description here

Then you will get an export of all the manual test cases included in this test plan with their steps and attachments.

enter image description here

Hope above helps!

1
On

In this AzureDevOps version there is no way to export the run steps result. Also the results API is not retrieving the step result information, I did some test with the API and it is not possible to get the testActionResultModel in the response. The maximum that you can get is the iterations list, but there is no link between the iterations and the steps.

https://learn.microsoft.com/en-us/rest/api/azure/devops/test/action%20results/list?view=azure-devops-rest-5.1#testactionresultmodel

Thank you