Bamboo REST API get list of responsible people on failed build result

[Brad Lajoie]

Have been googling for this for a little while now, searching atlassian community articles, and digging through Bamboo REST API documentation. There doesn't seem to be a way to get the list of responsible people on a build result e.g. when a build result is in a failed state? Is there any way to get the list of responsible people for a given build result?

[Daniel Santos · Accepted solution]

Hi @Brad Lajoie,

We don't have a REST endpoint to return this information and for this reason I've created this feature request: [BAM-20239] REST API to check responsibility from a broken build - Create and track feature requests for Atlassian products.

I also created the below query in case you want to extract this information programatically from the Bamboo DB:

SELECT
 A.*,
 "USERNAME",
 "USER_WHO_UPDATED",
 BUILD_TYPE,
 CREATED_DATE,
 BUILD_KEY,
 BUILD_NUMBER,
 BUILD_STATE,
 LIFE_CYCLE_STATE,
 BUILD_DATE,
 BUILD_CANCELLED_DATE,
 BUILD_COMPLETED_DATE,
 TRIGGER_REASON,
 REBUILD
FROM
 "AO_7A45FB_AOTRACKING_USER" TU
LEFT JOIN
 AUTHOR A ON A.LINKED_USER_NAME=TU."USERNAME"
JOIN
 "AO_7A45FB_AOTRACKING_RESULT" TR ON TR."LINKED_TRACKING_ENTRY_ID"=TU."LINKED_TRACKING_ENTRY_ID"
JOIN
 BUILDRESULTSUMMARY ON BUILDRESULTSUMMARY_ID="RESULT_SUMMARY_ID"

 Please notice that some names are in quotes because those tables/columns are in capital letter in Postgres (which is the DB I used in my tests) so you may need small adjustments depending on your DB type.

I hope that helps.

[Brad Lajoie]

Awesome, thanks Daniel! That SQL will probably work for us for the time being. Will keep an eye on BAM-20239

[Daniel Santos]

Good to know! =]