how to pull project and repos list from bitbucket

[dsp_admin]

Hi Team,

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

[Raghavendra Reddy]

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

[Mahesh Shinde]

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