JIRA field value over the confluence page along with style & formatting



One of our customer requirement is to update the JIRA issue description value over the confluence page.

To get it done I implemented following solution with help of #ScriptRunner plugin.

  • Created Listener at JIRA end on issue update.
  • Created RestEnd point at confluence end to serve the request.
  • On issue update trigger, Sending API request to confluence along with update field  data in WIKI format.
  • Inside Rest API, capturing the WIKI data & converting it into storage format and updating the page. 
  • Prerequisite is JIRA issue should have confluence page link.

Below is the Sample code to convert WIKI data into storage format. Written in script console.

import com.atlassian.confluence.content.render.xhtml.ConversionContext
import com.atlassian.confluence.content.render.xhtml.DefaultConversionContext
import com.atlassian.confluence.xhtml.api.XhtmlContent
import com.atlassian.confluence.pages.Page
import com.atlassian.confluence.core.DefaultSaveContext
import com.atlassian.sal.api.component.ComponentLocator
import com.atlassian.confluence.pages.PageManager
import org.apache.commons.lang.StringUtils
import com.atlassian.confluence.core.ContentEntityObject

PageManager pagemanager = ComponentLocator.getComponent(PageManager);
XhtmlContent xhtmlContent = ComponentLocator.getComponent(XhtmlContent);

Page page = pagemanager.getPage(75990487);
ContentEntityObject contentEntityObject = page.getBodyContent().getContent();

final List<RuntimeException> wikiMarkupToStorageConversionErrors = new ArrayList();

final ConversionContext conversionContext = new DefaultConversionContext(page.toPageContext())
String jiraText = "Hi\r\n\r\n \r\n\r\nThis is +created+ for{color:#de350b}[SolutionBook|https://solutionbook.xxxx.com/]{color} testing purpose. _Please ignore._ \r\n||*JIRA*||Confluence||\r\n|Test|Best|\r\n\r\n \r\n :)\r\n * 1\r\n * 2\r\n * 3\r\n\r\n-Test-\r\n{code:java}\r\n{java code}{code}\r\n{panel}\r\n*Panel Header*\r\n\r\nPanel Text\r\n{panel}\r\n{noformat}\r\n*no* further _formatting_ is done here{noformat}\r\naksdfhasdf"
String jiradata = xhtmlContent.convertWikiToStorage(jiraText,conversionContext,wikiMarkupToStorageConversionErrors)
String pageBody = page.getBodyAsString()

pageBody = pageBody.replace("suresh",jiradata);

return "pageBodyStr"
log.error("Something went wrong whilw updating toc parameter:"+e.getMessage());






Log in or Sign up to comment
AUG Leaders

Atlassian Community Events