I am working on an automation of integrating authentication with GitLab and enable entitlements based on the GitLab groups via creating and applying permission templates, as a part of the automation.
Before I run this, I would like to know if there are any options available for me to extract the current mapping of each SonarQube projects with the corresponding permission templates. With this, I can extract the information as a backup and restore (trigger API to apply template one by one) if anything goes wrong.
The APIs will not be helpful in my scenario for extracting the information as we have around 20K projects where API can return up to max of 10K projects. So, I am looking for any mapping information from database. Where should I capture the link between these two?