Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,701
Community Members
 
Community Events
176
Community Groups

copy confluence attachment using Jira script runner

Hi All,

On issue creation I need to create a new confluence page from a template that has an attached excel spreadsheet template.   I have successfully generated the new page.

I have put our attachment in a blank page,  now I need to make a copy of the attachment and attach it to my new page.  Each new page needs its own copy of the attachment.  So it can't all link to the same page.

I believe I need to do this using the GET to download the attachment and then POST to put the attachment back up.  But I am confused as to what exactly is returned by the GET command,  and all of the POST examples I see use a File type to upload it.  

Here is the code I have,  this does not work..  It creates the page but I am not sure how to get the attachment in there..  Do I do it similar to the page creation using a params structure?  And where is that documented?

I would appreciate any help

 

import com.atlassian.applinks.api.ApplicationLink
import com.atlassian.applinks.api.ApplicationLinkService
import com.atlassian.applinks.api.application.confluence.ConfluenceApplicationType
import com.atlassian.jira.issue.Issue
import com.atlassian.sal.api.component.ComponentLocator
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.sal.api.net.Request
import com.atlassian.sal.api.net.Response
import com.atlassian.sal.api.net.ResponseException
import com.atlassian.sal.api.net.ResponseHandler
import groovy.json.JsonBuilder
import groovy.json.JsonSlurper
import groovy.xml.MarkupBuilder
import com.atlassian.sal.api.net.RequestFilePart

import org.apache.log4j.Logger
import org.apache.log4j.Level
def log = Logger.getLogger("com.acme.CreateSubtask")
log.setLevel(Level.DEBUG)


static ApplicationLink getPrimaryConfluenceLink() {
def applicationLinkService = ComponentLocator.getComponent(ApplicationLinkService.class)
final ApplicationLink conflLink = applicationLinkService.getPrimaryApplicationLink(ConfluenceApplicationType.class)
conflLink
}

// the issue provided to us in the binding

def issueManager = ComponentAccessor.getIssueManager()
MutableIssue issue = issueManager.getIssueObject("IT-42")

 

def confluenceLink = getPrimaryConfluenceLink()
assert confluenceLink // must have a working app link set up

def authenticatedRequestFactory = confluenceLink.createImpersonatingAuthenticatedRequestFactory()

// write storage format using an XML builder
def writer = new StringWriter()
def xml = new MarkupBuilder(writer)
xml.'ac:structured-macro'('ac:name': "jira") {
'ac:parameter'('ac:name': "key", issue.key)
'ac:parameter' ('ac:name': "server", "MY JIRA")
'ac:parameter' ('ac:name': "serverId", "Some server Id")
}

// retrieve contents of "template page"
def confResponse = null

authenticatedRequestFactory
.createRequest(Request.MethodType.GET, "rest/api/content?type=page&title=MY_Template_Page&expand=body.storage.value")
.addHeader("Content-Type", "application/json")
.execute(
new ResponseHandler<Response>()
{
@Override
void handle(Response response) throws ResponseException {
confResponse = new JsonSlurper().parseText(response.getResponseBodyAsString())
}
})

// set the page title - this should be unique in the space or page creation will fail
def pageTitle = issue.key + " Issue Page"

def params = [
type : "page",
title: pageTitle,
space: [
key: "TES" // set the space key - or calculate it from the project or something
],
body : [
storage: [
value : writer.toString() + confResponse.results.body.storage.value[0],
representation: "storage"
]
]
]

authenticatedRequestFactory
.createRequest(Request.MethodType.POST, "rest/api/content")
.addHeader("Content-Type", "application/json")
.setRequestBody(new JsonBuilder(params).toString())
.execute(new ResponseHandler<Response>() {
@Override
void handle(Response response) throws ResponseException {
if (response.statusCode != HttpURLConnection.HTTP_OK) {
throw new Exception(response.getResponseBodyAsString())
} else {
def webUrl = new JsonSlurper().parseText(response.responseBodyAsString)["_links"]["webui"]
log.debug webUrl
}
}
})


def att_file
// hard code the download link for now.
authenticatedRequestFactory
.createRequest(Request.MethodType.GET, "download/attachments/5242908/FM00872.xlsx?version=1&modificationDate=1533302834924&api=v2")
// .addHeader("Content-Type", "application/json")
//.setRequestBody(new JsonBuilder(params).toString())
//.setEntity(entityBuilder.build())
//.setFiles(partList)
.execute(new ResponseHandler<Response>() {
@Override
void handle(Response response) throws ResponseException {
if(response.statusCode != HttpURLConnection.HTTP_OK) {
throw new Exception(response.getResponseBodyAsString())
}
else
{
att_file = new File(response.responseBodyAsString)
}
}
})


// What do I put here? how to I insert what was returned?


authenticatedRequestFactory
.createRequest(Request.MethodType.POST, "rest/api/content/IT-42+MY_Template_Page/child/attachment")
.addHeader("X-Atlassian-Token", "nocheck")
//.setRequestBody(new JsonBuilder(params).toString())
//.setEntity(entityBuilder.build())
//.setFiles(partList)
.execute(new ResponseHandler<Response>() {
@Override
void handle(Response response) throws ResponseException {
if(response.statusCode != HttpURLConnection.HTTP_OK) {
throw new Exception(response.getResponseBodyAsString())
}
}
})

 

1 answer

Ok So I never got an answer, but I did get it working. 

Here is my code.  I create a confluence page and link it to our issue.  I added the template as a n attachment to a page in confluence, which is why I can hard code the downlink address,  then pull down the excel template and then add the template as an attachment to a my new confluence page.   I then add a link to the attachements page inside the jira issue.  This way when viewing the issue any user can access the spreadsheet by selecting the link.

I left out the code to create the new page and get the page_id since that code is available in the scriptrunner examples

 

The trick was to use getResponseAsStream()  instead of getResponseAsString()  the conversion to string was corrupting the excel file.

 

 

import com.atlassian.applinks.api.ApplicationLink
import com.atlassian.applinks.api.ApplicationLinkService
import com.atlassian.applinks.api.application.confluence.ConfluenceApplicationType
import com.atlassian.jira.issue.Issue
import com.atlassian.sal.api.component.ComponentLocator
import com.atlassian.sal.api.net.Request
import com.atlassian.sal.api.net.Response
import com.atlassian.sal.api.net.ResponseException
import com.atlassian.sal.api.net.ResponseHandler
import groovy.json.JsonBuilder
import groovy.json.JsonSlurper
import groovy.xml.MarkupBuilder
import com.atlassian.sal.api.net.RequestFilePart
import org.apache.commons.io.FileUtils
import com.atlassian.jira.issue.link.RemoteIssueLinkBuilder
import com.atlassian.jira.issue.link.RemoteIssueLink
import com.atlassian.jira.issue.link.RemoteIssueLinkManager
import com.atlassian.jira.component.ComponentAccessor

 

// Get attachment and save to temporary file
def pathName = "C:\\temp\\TEMP.xlsx"
File testfile = new File(pathName);
testfile.createNewFile();
InputStream att_file;
authenticatedRequestFactory
.createRequest(Request.MethodType.GET, "download/attachments/5242908/Workbook.xlsx?version=1&modificationDate=1533302834924&api=v2&download=true")
.addHeader("Content-Type", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")
.execute(new ResponseHandler<Response>() {
@Override
void handle(Response response) throws ResponseException {
if(response.statusCode != HttpURLConnection.HTTP_OK) {
throw new Exception(response.getResponseBodyAsString())
}
else
{
att_file = response.getResponseBodyAsStream()
//log.debug "GET " << response.statusCode
}
}
})

FileUtils.copyInputStreamToFile(att_file, testfile);

File fileUpload = new File(pathName)
assert fileUpload
def part = new RequestFilePart(fileUpload, "file")
assert part
def partList = new ArrayList<RequestFilePart>()
partList.add(part)
assert partList
assert partList.size() == 1
//log.debug fileUpload
//log.debug fileUpload.size();


// Add attachment as child
authenticatedRequestFactory
.createRequest(Request.MethodType.POST, "rest/api/content/" + page_id + "/child/attachment")
.addHeader("X-Atlassian-Token", "nocheck")
.setFiles(partList)
.execute(new ResponseHandler<Response>() {
@Override
void handle(Response response) throws ResponseException {
if(response.statusCode != HttpURLConnection.HTTP_OK) {
//log.debug response.statusCode
//log.debug response.getResponseBodyAsString()
throw new Exception(response.getResponseBodyAsString())
}
}
})

def link = "http://yourconfluenceserver:8090/pages/viewpageattachments.action?pageId="+ page_id + "&metadataLink=true"

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def code_field = customFieldManager.getCustomFieldObjectByName("Project Code / Name")
def project_code = issue.getCustomFieldValue(code_field)
def workbook_name = project_code.toString() + " Design Maturity Workbook"

RemoteIssueLinkBuilder remoteIssueLinkBuilder = new RemoteIssueLinkBuilder();
remoteIssueLinkBuilder.issueId(issue.getId());
remoteIssueLinkBuilder.relationship("Link");
remoteIssueLinkBuilder.title(workbook_name.toString());
remoteIssueLinkBuilder.url(link);

RemoteIssueLink remoteIssueLink = remoteIssueLinkBuilder.build();

def user = issue.getAssigneeUser();

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events