how to pull project and repos list from bitbucket

dsp_admin January 20, 2022

Hi Team,

 

Kindly suggest exporting the project as well repositories details from bitbucket. (user wise)

2 comments

Mahesh Shinde
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 20, 2022

Hi @dsp_admin ,

Please, refer this document which will help you to export project or repository from Bitbucket using REST API call.

https://confluence.atlassian.com/bitbucketserver/exporting-957497835.html

Raghavendra Reddy February 10, 2023

Hi @dsp_admin ,

Please use the below query. I used below query for oracle DB and it works.

 

SELECT
prj.name AS "Project / User Name"
, prj.project_key AS "Project / User Key"
, rep.name AS "Repository Name"
, rep.slug AS "Repository Slug"
FROM repository rep
INNER JOIN project prj ON rep.project_id = prj.id
ORDER BY prj.name, rep.name

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events