There isn't any REST API to retrieve repository details.
Try using the following SQL:
FROM VCS_LOCATION vl
JOIN PLAN_VCS_LOCATION pvl ON vl.VCS_LOCATION_ID=pvl.VCS_LOCATION_ID
JOIN BUILD b ON b.BUILD_ID=pvl.PLAN_ID
The repository details are stored in XML format in the column "XML_DEFINITION_DATA" of the table VCS_LOCATION.
If the column "PARENT_ID" is not null, the above SQL may not have the repository details. You will need to use the following SQL to get the details from the parent data:
G’day Bamboo customers, The wait is almost over! We are in the final stages of work on the first release of Bamboo Data Center, our self-managed enterprise offering of Bamboo. This Data Center offe...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events