deployed with Docker
i want to know if the only option i have for pulling the data about different projects is with the DB or if it is possible to utilise the api?
i’ve looked at the web api and i can’t seem to find any functionnality that helps you do that.
Welcome 
normally the Sonarqube DB should be seen / handled as black box. There are (very) rare cases where you need to access the db directly, i.e for resetting the admin password.
All data is accessible via the rest api, see web api docs
http(s)://<yoursonarhost>:9000/web_api
to see all including internal and deprecated see
http(s)://<yoursonarhost>:9000/web_api?deprecated=true&internal=true
You may check what’s going on under the hood when doing operations in the Sonarqube web ui and spy with the browser developer tool to see the underlying rest calls.
When you provide more details about the data you want to pull me might assist with the appropriate rest calls.
Gilbert