Copying attachment from one instance to another

[dinesh91n]

Hi guys, i have task to copy an attachment from an incident, from one instance to a change request in another instance using soap web services. Can anyone help me on this.

[Pradeep Sharma]

Hi Dinesh,

Please refer the below link for more info.

http://www.servicenowguru.com/integration/sending-attachment-servicenow/

[dinesh91n]

Hi pradeep,

        Thanks for the reply i have a doubt payload they have mentioned like 'base64 encoded binary (or ASCII) data', is this applicable for all file types

[dinesh91n]

i tried the following code in BRULE

var gR = new GlideRecord('sys_attachment');

  gR.addEncodedQuery('table_name=incident^table_sys_id='+current.sys_id);

  gR.query();

  if(gR.next()){

  try {

  var s = new sn_ws.SOAPMessageV2('Copy attachments', 'insert');

  s.setStringParameter('source', 'change_request:'+current.u_change_sysid);

  s.setStringParameter('payload', 'base64 encoded binary (or ASCII) data');

  s.setStringParameter('topic', 'AttachmentCreator');

  s.setStringParameter('agent', 'AttachmentCreator');

  s.setStringParameter('name', gR.file_name+':'+gR.content_type);

  var response = s.execute();

  var responseBody = response.getBody();

  var status = response.getStatusCode();

it is copying the file but the file is corrupted

[dinesh91n · Accepted solution]

hi guys i found the solution

used these two to finish the code GlideStringUtils, GlideSysAttachment

revised code:

var StringUtil = new GlideStringUtil();

  var attachments = new GlideSysAttachment();

  var fileName, contentType;

  var gR = new GlideRecord('sys_attachment');

  gR.addEncodedQuery('table_name=incident^table_sys_id='+current.sys_id);

  gR.query();

  while(gR.next()){

  try {

  var binData =   attachments.getBytes(gR);

  var encData =   StringUtil.base64Encode(binData);

  gs.log('XML Respons for payload='+encData);

  var s = new sn_ws.SOAPMessageV2('Copy attachments', 'insert');

  s.setStringParameter('source', 'change_request:'+current.u_change_sysid);

  s.setStringParameter('payload', encData);

  s.setStringParameter('topic', 'AttachmentCreator');

  s.setStringParameter('agent', 'AttachmentCreator');

  s.setStringParameter('name', gR.file_name+':'+gR.content_type);

  var response = s.execute();

  var responseBody = response.getBody();

  var status = response.getStatusCode();

  }

  catch(ex) {

  var message = ex.getMessage();

  }

  }