How to export Sonarqube dashboards to excel format for multiple projects

How to export Sonarqube dashboards to excel format for multiple projects

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?