How to export Sonarqube dashboards to excel format for multiple projects

How to export Sonarqube dashboards to excel format for multiple projects

1 Like

Hi Amansyed931. Welcome to the SonarSource community!

SonarQube provides a RESTful web API to extract data for your projects. The services composing the web API are documented within your SonarQube instance itself through the URL /web_api.

The API format is json, so you can write a script or program to read what you want and format it into csv format.

Our requirement is to extract the sonarqube project metrics like Bug,Vulnerability,Coverage and Quality gate status into a CSV file for all the projects

I have used Powershell to extract the data but unfortunately it’s not giving the complete data

What requests you are making to the SonarQube web API for these?

1 Like