Access BitBucket database tables via API?

Question

Hi,

I need to retrieve the BitBucket DB data from the tables (non AO tables) like users, projects, repositories. Is there any way to fetch data from these tables similar to the AO tables? I dont want to use the Oracle DB details to fetch these details. Is there any way to fetch them through the Java API?

Venkata Nagarjuna Dondapati · Answer

Thanks Nic. But our database is pretty big and our server is timing out to retrieve all the users and their projects and repository permissions. I cannot modify the server settings. Is there anyway I can retrieve them through the API? (I really didnt find a way to retrieve the users permissions in one call)

Nic Brough -Adaptavist- · Answer

No, the database tables in Atlassian applications are mostly not directly exposed, because they're really badly laid out for reporting.

You should forget database tables and use the APIs that are exposed, they are far more easy to use and representative of what you really want to do with the information being held.

Maarten Cautreels · Answer

Hi Venkata,

You can find the BitBucket Server API Documentation here or if you're using cloud, the documentation is here.

Hope this helps.

Best,

Maarten