REST API to check responsibility from a broken build

XMLWordPrintable

    • 0

      Problem

      As an admin I need to get the details from a broken build programatically though REST API.
      Bamboo provides a lot of details for a given build through /rest/api/latest/result endpoint but the responsible information is not present there.

      Suggestion

      Expand the result endpoint to include this information or add a new endpoint for this

      Workaround

      Use the following query to get the details directly from the 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"
      

      /!\ The query above was designed to work on Postgres DB and might need small adjustments to run on other DBMS

            Assignee:
            Marcin Walerianczyk
            Reporter:
            Daniel Santos (Inactive)
            Votes:
            38 Vote for this issue
            Watchers:
            30 Start watching this issue

              Created:
              Updated:
              Resolved: