Copying attachment from one instance to another+

khusboo1 · ‎05-22-2017

I am getting the following error while copying attachments from one instance to another in helsinki instance using SOAP.The error is

'Illegal attempt to access class 'com.glide.util' via script'.Any help is deeply appreciated.

Michael Ritchie · ‎05-22-2017

Lets try another way to help you... At K17 a few weeks ago I had created a HackLab on this topic and unfortunately that lab guide hasn't been posted yet to the Community. In that lab there was a use case where an incident needs to be sent from one ServiceNow instance to another and along with the record's attachments. Basically a business rule runs after insert of an incident based on whatever conditions you need it to. Below is the script that first send the incident to the target and then query for any attachments and send those as well. Hopefully this example script will be helpful to solve your issue.

var targetInstanceURL =   "https://TARGET-NAME.service-now.com/";

var targetUserID = "USER-NAME";

var targetUserPassword = "USER-PASSWORD";


var answer = "";

var attachmentMsg = "";


//Create a JSON string with the current incident attributes

var incidentJSON = {};

incidentJSON.caller_id = current.caller_id.toString();

incidentJSON.category = current.category.toString();

incidentJSON.impact = current.impact.toString();

incidentJSON.urgency = current.urgency.toString();

incidentJSON.priority = current.priority.toString();

incidentJSON.short_description = current.short_description.toString();


// Set the Correlation fields to link the new incident with the source incident

incidentJSON.correlation_display = "ServiceNow";

incidentJSON.correlation_id = current.sys_id.toString();


// Encode JSON string

var requestBody = new global.JSON().encode(incidentJSON);


// Create incident in target instance via REST

var restMessage = new sn_ws.RESTMessageV2();

restMessage.setHttpMethod("post");

restMessage.setBasicAuth(targetUserID, targetUserPassword);

restMessage.setEndpoint(targetInstanceURL + "api/now/table/incident");

restMessage.setRequestHeader("Content-Type", "application/json");

restMessage.setRequestBody(requestBody);


var response = restMessage.execute();

var responseBody = response.getBody();

var httpStatus = response.getStatusCode();


if (httpStatus.toString() == "201") {

       answer = "Incident successfully sent.";


       // Get target record's SysID

       var parser = new JSONParser();

       var parsed = parser.parse(responseBody);

       var targetRec = parsed.result;


       var attachmentCount = sendAttachments(current.getTableName(), current.sys_id, targetRec.sys_id);

       if (attachmentCount != "none") {

               attachmentMsg =   " Attachments successfully sent: " + attachmentCount[0].toString() + ". Attachments failed to be sent: " + attachmentCount[1].toString();

       } else {

               attachmentMsg =   " Record had no attachments to send.";

       }

} else {

       answer = "Incident could not be sent.";

}

answer = answer + attachmentMsg;


// Set message at top of screen with results.

gs.addInfoMessage(answer);


function sendAttachments(sourceTable, sourceID, targetID) {

       var answer = [0, 0]; //successful attachments, failed attachments

       

       // Query for any attachments on the current record.

       var attachmentRec = new GlideRecord("sys_attachment");

       attachmentRec.addQuery("table_sys_id", sourceID);

       attachmentRec.addQuery("table_name", sourceTable);

       attachmentRec.query();

       if (attachmentRec.hasNext()) {

               while (attachmentRec.next()) {

                       var attachmentMessage = new sn_ws.RESTMessageV2();

                       attachmentMessage.setHttpMethod("post");

                       attachmentMessage.setBasicAuth(targetUserID, targetUserPassword);

                       attachmentMessage.setEndpoint(targetInstanceURL + "api/now/attachment/file");

                       attachmentMessage.setQueryParameter("table_name", attachmentRec.table_name);

                       attachmentMessage.setQueryParameter("table_sys_id", targetID);

                       attachmentMessage.setQueryParameter("file_name", attachmentRec.file_name);

                       attachmentMessage.setRequestHeader("Content-Type", attachmentRec.content_type);

                       attachmentMessage.setRequestHeader("Accept", "application/json");

                       attachmentMessage.setRequestBodyFromAttachment(attachmentRec.sys_id);


                       var response = attachmentMessage.execute();

                       var responseBody = response.getBody();

                       var httpStatus = response.getStatusCode();


                       if (httpStatus.toString() == "201") {

                               answer[0] += 1;

                       } else {

                               answer[1] += 1;

                       }

               }

       } else {

               answer = "none";

       }

       return answer;

}

View solution in original post

Michael Ritchie · ‎06-25-2018

Richard, this was a Hacklab in CreatorCon and unfortunately I don't believe they were published. I did search your error "Unbuffered entity enclosing request" on the community and found the following articles which may help you:

https://community.servicenow.com/community?id=community_question&sys_id=93078be5db1cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=6b30cf61db98dbc01dcaf3231f96...

pardhiv · ‎12-14-2022

Hi,

I modified your script just to copy attachments as data is already available in the target Instance (Custom Table) .

I was able to copy attachments to a certain instance , but unable to do that on remaining.

Are there any things to be noted when creating a user , I created a dummy users in all instances.

Error Code : 401 in some cases , 403 in another .

Do you have any input on this ?

khusboo1 · ‎05-22-2017

Thankyou!!!!!! for your valuable time and awesome response.I am trying your solution and will let you know soon.It is really very informative.

khusboo1 · ‎05-22-2017

It has worked perfectly and solved my issue.Thanks alot!!!!

Michael Ritchie · ‎05-22-2017

Awesome. Happy to help.