JIRA Scriptrunner - Using Confluence Rest API to pull data from Confluence into a JIRA field

Aaron Andrade

Goal

Pull a list of contacts documented in Confluence (part of page properties macro (id=contacts, key=Outage Contact List)) and make available in a custom field (type multi-select) in JIRA

What I have

I have a URL that uses Confluence's Rest API along with a sample output of what I get back.

https://confluence.domain.com/rest/masterdetail/1.0/detailssummary/lines?cql=type=page&detailsId=contacts&sortBy=title&spaceKey=CONTACTS&contentId=123445&headings=Outage Contact List

{
  "currentPage": 0,
  "totalPages": 17,
  "renderedHeadings": [
    "Outage Contact List"
  ],
  "detailLines": [
    {
      "id": 209718035,
      "title": "ABC Contacts",
      "relativeLink": "/display/ABC/ABC+Contacts",
      "details": [
        "<p xmlns=\"http://www.w3.org/1999/xhtml\"><span><a class=\"external-link\" href=\"mailto:Person.A@client.com\" rel=\"nofollow\">Person.A@client.com</a></span></p>"
      ],
      "likesCount": -1,
      "commentsCount": -1
    },
  ],
  "asyncRenderSafe": true
}

What I need from the GET

I need the "details" Person.A@client.com... There are multiple sets returned in "detailLines", but all I want is "details".

What I have referenced

• Other questions (how to post to external sites)
• https://github.com/jgritman/httpbuilder/wiki
• https://scriptrunner.adaptavist.com/latest/jira/behaviours-conversions.html#_walkthrough_external_rest_service
• https://scriptrunner.adaptavist.com/latest/jira/rest-endpoints.html

What I don't know

• I am not savvy enough with the code to pull it all together, in JIRA.  1) Call Confluence, 2) Parse the data, and 3) Assign to a custom field.  Any ideas or suggestions would be most helpful

Matt Doar_tzgiej

I think I'd use the nFeed plugin