Utility for retrieving and combining paginated results from the Sonar APIs
The Sonar API Getter is a utility for retrieving and combining paginated results from the Sonar APIs. Specifically, it is intended to retrieve Issues and Hotspots.
These APIs both have a limit of 500 results per page. This utility will retrieve all pages of results (up to the API max of 10000 results total) and combine them into a single JSON file that can be uploaded to Pixee for triage and remediation.
This utility requires Python 3.10 or later.
From GitHub repository over SSH (recommended):
pip install git+ssh://[email protected]/pixee/sonar-api-getter
From GitHub repository over HTTPS:
pip install git+https://github.com/pixee/sonar-api-getter
Once installed, run the following command for a full list of options:
sonar-api-getter --help
To retrieve both hotspots and issues in a single combined result file, use the following command:
sonar-api-getter MyOrg_MyRepo
You'll see output like this:
Retrieved 2713 issues from 6 pages
Retrieved 98 hotspots from 1 pages
Results written to sonar_combined_MyOrg_MyRepo.json
To retrieve only hotspots, use the following command:
sonar-api-getter --hotspots-only MyOrg_MyRepo
To retrieve only issues, use the following command:
sonar-api-getter --issues-only MyOrg_MyRepo
By default files are saved to a file in the current working directory. An additional argument can be provided to specify the output file:
sonar-api-getter MyOrg_MyRepo my-project-results.json
In order to retrieve issues or hotspots, the project ID must be provided. This can be found in the Sonar UI by navigating to the project and looking at the URL. The project ID is the last part of the URL, after the organization name and a colon. For example, in the URL https://sonarcloud.io/dashboard?id=MyOrg_MyRepo, the project ID is MyOrg_MyRepo. It can also be found by navigating to the Information tab of the project in the Sonar UI and finding the value under Project Key.
Authentication with the Sonar API is provided via the SONAR_TOKEN environment variable. Tokens can be generated in the Sonar UI under My Account > Security, which is reached from the drop-down menu in the upper right-hand side of the UI. In SonarCloud, this can be found here.
To run the utility, set the SONAR_TOKEN environment variable with the token generated from the Sonar UI:
export SONAR_TOKEN=<your-sonar-token>