question Re: Jira REST Integration - How to send attachment? in ITOM forum

Jira REST Integration - How to send attachment?

garyopela — Thu, 04 Sep 2014 15:40:35 GMT

Again, many thanks to John James Andersen for his work on the Jira REST interface.

I have made a tremendous amount of progress on it, and have a heavily customized version of my own running for the Service Catalog. However, now the requirement has come up to send attachments from the catalog over to Jira.

John also had a nice write-up on how to get the attachments out of Service-Now here: http://www.john-james-andersen.com/blog/service-now/sending-out-servicenow-attachments-via-soap.html. I also found write-ups on how to insert attachments via REST to jira here: How do I upload attachment to JIRA Issue via REST API? - Atlassian Answers.

The problem that I'm seeing is that the first link, the data is returned in the raw format, whereas the Jira integration is expecting an actual file.

So, I was wondering if anyone had any suggestions on how to handle this?

My initial thought is to use Orchestration to kick off a perl script on my mid-server and pass it the sys_id of the RITM. Then the perl script would query the sys_attachment table and, for each attachment found, download the attachment and send it over to the Jira instance. This way Service-Now is the one who kicked off the whole thing, so it's not just sitting there running all the time.

Any suggestions are welcome

Thanks!

Re: Jira REST Integration - How to send attachment?

ankitsaharavat — Fri, 24 Jul 2015 05:07:01 GMT

Hi Gary,

Integration between ServiceNow and Jira is possible using Informatica Cloud. For more info on ServiceNow connector, please visit -http://www.servicenowconnector.com.

For any further query, please reach at info(at)mansasys(dot)com.

Thanks,

Ankit

Re: Jira REST Integration - How to send attachment?

Sreeja Gattu — Thu, 27 Aug 2015 09:02:39 GMT

Hi Gary,

I need to send the attachment from ServiceNow to Jira using REST.

Did u succeed in this scenario?

If so, Can u please help me in configuring the post message.

Thanks in advance

Sreeja Gattu

Re: Jira REST Integration - How to send attachment?

pradeepgupta — Thu, 18 Feb 2016 13:11:40 GMT

Hi Sreeja,

Have you got any solution for this ?

Actually , I have same requirement where ServiceNow needs to send attachment to JIRA over REST.

Re: Jira REST Integration - How to send attachment?

pankaj_puniani — Fri, 25 Mar 2016 22:24:19 GMT

Hi Gary,

From Geneva onwards, ServiceNow supports REST Attachment API which enables user to download/upload attachments. Here is the doc link:

Attachment API

Regards,

Pankaj

Re: Jira REST Integration - How to send attachment?

pankaj_puniani — Fri, 25 Mar 2016 22:33:55 GMT

Hi Pardeep,

You can configure outbound rest message on ServiceNow. From Geneva onwards, Servicenow supports setting attachment as request body in outbound rest request. Here is a doc link: RESTMessageV2 - setRequestBodyFromAttachment(String attachmentSysId)

Regards,

Pankaj

Re: Jira REST Integration - How to send attachment?

reenanarbitrari — Fri, 01 Apr 2016 19:33:48 GMT

We have done something very similar using the Attachment API in Geneva, but in python.

Through REST you get can all of the info needed to post to Jira. You'll need the metadata and the actual file:

For the metadata, if you know the sys_id of the attachment:

GET /attachment/{sys_id} ==> returning "file_name" and "content_type"

For the file:

GET /attachments/{sys_id}/file ==> returning attachment_file

Then we posted it to our Jira Instance:

file = {

'file': (attachment_meta["file_name"], attachment_file.content, attachment_meta["content_type"])

}

response = requests.post(jira_instance_attachment_url, auth=auth, headers={"X-Atlassian-Token": "no-check"}, files=file)

In summary, for us to post attachments successfully to Jira, we had to provide the file_name, raw content, and the especially the content_type. You can get all this info from within the ServiceNow Attachment API.

Re: Jira REST Integration - How to send attachment?

Nick65 — Fri, 27 May 2016 08:02:14 GMT

In a perfect world you should be able to use this,

RESTMessageV2 - setRequestBodyFromAttachment(String attachmentSysId)

Write your script and done.

var request = new sn_ws.RESTMessageV2();

request.setHttpMethod('post');

request.setRequestHeader("X-Atlassian-Token","no-check");

request.setRequestHeader("Content-type","multipart/form-data");

request.setEndpoint('https://{jiraURL}/rest/api/2/issue/SN-2/attachments');

request.setBasicAuth("username","password");

request.setRequestBodyFromAttachment('abd7460b0fe39e001dc906ace1050e9f'); //sys_id of attachment record

var response = request.execute();

But I have not been able to get this to work OOB. I believe Jira is only expecting a multipart-form/data message and ServiceNow is sending a application/octet-stream (i think). The only way I have been able to send attachments via REST is with the Mid server using a custom .jar file called from a script include.

Re: Jira REST Integration - How to send attachment?

jorgelalmodovar — Tue, 20 Sep 2016 17:57:12 GMT

Hi Reenan,

Could you provide a screenshot or a piece of the code in Service Now?

Re: Jira REST Integration - How to send attachment?

philippenguyen — Tue, 20 Sep 2016 21:47:35 GMT

Hi Nick,

I hope you're well. I'm currently busy with a ServiceNOW <=> Jira Integration including attachments. I've used the POC update set found on the share, however I'm stuck at the attachment part.

My ServiceNOW instance is running on Helsinki. Could you guide me on how I can setup a bi-directional attachment synchronization from ServiceNOW to JIRA?

Thank you.

Phil

Re: Jira REST Integration - How to send attachment?

philippenguyen — Wed, 21 Sep 2016 20:22:32 GMT

Hi guys,

Could anyone help me with the ServiceNOW <=> Jira attachment handling integration? I'm currently using the POC update set from Anderson and I'm completely stuck on this part.

Thank you!

Phil

Re: Jira REST Integration - How to send attachment?

kumaran — Mon, 20 Feb 2017 11:56:40 GMT

Can someone help to post attachment to JIRA from serviceNow using rest api.

Thanks

Re: Jira REST Integration - How to send attachment?

ashik1 — Wed, 02 Jan 2019 13:40:39 GMT

I have tried to debug code from another thread and works perfectly for me. I have posted complete solution code here - https://community.servicenow.com/community?id=community_question&sys_id=0679b3b0dbfeeb00f21f5583ca961916