Hi, i want to fetch data from a confluence page and populate it into a drop down field in Jira JSM. I could access the data via api with this code:
import groovy.json.JsonSlurper
import org.jsoup.Jsoup
def confluenceBaseUrl = "xxxxxx"
def pageId = "4522360"
def username = "xxxxx"
def password = "xxxxxxx"
def authString = "${username}:${password}".bytes.encodeBase64().toString()
def url = "${confluenceBaseUrl}/rest/api/content/${pageId}?expand=body.storage"
def connection = new URL(url).openConnection()
connection.setRequestProperty("Authorization", "Basic " + authString)
connection.setRequestProperty("Content-Type", "application/json")
def response = connection.inputStream.text
def json = new JsonSlurper().parseText(response)
But then i could not parse the table or specific row.
Can someone explain me how to solve this?
best regards,
Tarik