Thanks Ankur for the response.
This is my script bit which processes the external response received and inserting to sys_attachment table.
source : my instance
target: third party instance
_________________________________
try {
var r = new sn_ws.RESTMessageV2('Attachment Outbound xxxx', 'GET');
r.setStringParameter('table_sys_id', corID);
//r.saveResponseBodyAsAttachment("incident", tableSysIdSource, "filename1");
var response = r.execute();
GlideStringUtil.base64Encode(response);
var responseBody = response.getBody();
var parser = new JSONParser();
var parsed = parser.parse(responseBody);
for (i = 0; i < parsed.result.length; i++) {
var link = parsed.result[i].download_link;
var grAtt = new GlideRecord('sys_attachment');
grAtt.initialize();
grAtt.table_name = parsed.result[i].table_name;
grAtt.table_sys_id = tableSysId_BW;
grAtt.size_bytes = parsed.result[i].size_bytes;
grAtt.content_type = parsed.result[i].content_type;
grAtt.file_name = parsed.result[i].file_name;
grAtt.insert();
}
}
catch(ex) {
var message = ex.getMessage();
}
_______________________________________________
corID - I first do GET Incidents API call and collect the incidents which are in scope.
Then, loop through the incident in source instance and collect the 'Correlation ID'.
Correlation ID is table sys ID in 'sys_attachment' table in target instance.
I then loop through the Correlation ID and make GET API call to 'sys_attachment' table in target instance.
I was using the function saveResponseBodyAsAttachment in my script above, it didnt make any difference (tableSysIdSource is the sys_id of ticket in source instance). Infact, I am not aware if I am using at the right place. I do not have the 'filename' as it is set before executing the request.
There is no error, Attachment record is inserted and the file is empty when opened.
