Access BitBucket database tables via API?

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?

 

2 answers

1 vote
Maarten Cautreels Community Champion May 08, 2017

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

1 vote

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.

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)

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Piotr Plewa
Published Dec 27, 2017 in Bitbucket

Recipe: Deploying AWS Lambda functions with Bitbucket Pipelines

Bitbucket Pipelines helps me manage and automate a number of serverless deployments to AWS Lambda and this is how I do it. I'm building Node.js Lambda functions using node-lambda&nbsp...

1,929 views 1 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you