Bamboo REST API to retrieve repositories of the plan

[Jaszeer M]

I am looking for api end point from rest api of Bamboo
which can return bit-bucket information for a given plan key

[Foong · Accepted solution]

There isn't any REST API to retrieve repository details.

Try using the following SQL:

SELECT * 
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
WHERE b.FULL_KEY='<plankey>';

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:

SELECT * 
FROM VCS_LOCATION
WHERE VCS_LOCATION_ID=<parentID>;