You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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: