How to export test results from Azure DevOps?

To export test results from Azure DevOps, you can use one of several methods depending on your specific needs. Here’s a step-by-step guide for the most common methods:

Method 1: Export Test Results via Excel

1. Access the Test Plans: Navigate to your Azure DevOps project and go to the Test Plans section.
2. Open the Desired Test Suite: Select the test suite or test plan from which you want to export results.
3. Export to Excel: Click on the ‘…’ (ellipsis) in the toolbar. Select ‘Export to Excel’. The test cases and results will be downloaded as an Excel file.

Note: This method primarily exports test cases and associated details, but might not include detailed test execution results.

Method 2: Use Reporting Features

1. Access Analytics: If your Azure DevOps project has Azure DevOps Analytics enabled, go to Dashboards or Analytics.
2. Create a Custom Report: Use Power BI or Excel to connect to Azure DevOps Analytics and create a custom report that includes the desired test result data.
3. Export Data: Once the report is created, export it as a CSV, Excel, or other desired formats.

Method 3: Use REST APIs

1. Access the Azure DevOps REST API: Use the Azure DevOps Test Results REST API to fetch test results programmatically.
2. Steps: Authenticate using a Personal Access Token (PAT) and make a GET request to the https://dev.azure.com/{organization}/{project}/_apis/test/runs/{runId}/results?api-version=7.0 endpoint.
3. Export Data: Parse the API response and save the data in your desired format (e.g., CSV, Excel).

This method is flexible and suitable for automation or detailed data extraction.

Method 4: Use a Marketplace Extension

1. Search for Export Tools: Go to the Azure DevOps Marketplace and look for extensions like: Excel Reports and [Azure DevOps Test Results Exporter](specific tool may vary).
2. Install the Extension: Install and configure the extension in your Azure DevOps organization.
3. Export Test Results: Follow the extension’s instructions to export test results.

Method 5: Export from Pipelines

1. Access Test Results in Pipelines: Go to the Pipelines section and open the pipeline run that contains the test results.
2. Download Test Results: Locate the test summary or logs and click on ‘Download Logs’, which may include test results in a .trx or another format.
3. Convert the Format: Use tools such as the Visual Studio Test Results Viewer or convert .trx files to a readable format such as CSV or Excel.

Enhancing Azure DevOps Workflow with QA Touch

QA Touch enhances your workflow with Azure DevOps by acting as a central hub for managing and analyzing test results. It integrates with Azure DevOps, allowing you to sync exported data and gain deeper insights with advanced reporting and analytics. With QA Touch, you can simplify collaboration across teams, link results to requirements, and ensure traceability. Its ability to centralize test management and integrate with other tools such as Jira and Trello makes QA Touch an invaluable asset for optimizing the software testing lifecycle.