Attached file is not opening on the incident and service request table.

[vinuth v]

Hi All,

I have created the Scripted REST API and provide the API and payload to the 3rd party. But when I try to open the file from the Incident table I am getting 

I am not able to open the file but file is attached to sys_attachment table

Tried with the different content types. I am facing this issue for Docs, Excl and Images.

Script is:

(function process( /*RESTAPIRequest*/ request, /*RESTAPIResponse*/ response) {

var requestBody = request.body.dataString;
var requestBody1 = request.body.data;
var parser = new global.JSON();
var parsedData = parser.decode(requestBody);
var number = parsedData.incidentNumber;

var fileName = parsedData.fileName;

var fileContentType = parsedData.contentType;

var fileData = parsedData.fileData;

var rec = new GlideRecord('incident');
rec.addQuery('number', number);
rec.query();
if (rec.next()) {
var sa = new GlideSysAttachment();
// sa.write(rec, fileName, fileContentType, fileData);
sa.write(rec, fileName, fileContentType, GlideStringUtil.base64Decode(fileData));
var responseBody = {};
responseBody.incNumber = number;
responseBody.status = "Success";
response.setBody(responseBody);
} else {
var responseBodyFailure = {};
responseBodyFailure.status = "Failure";
response.setBody(responseBodyFailure);
}

})(request, response);

And Payload

{   
"incidentNumber": "INC4969852",   
"fileName": "test_6.doc",   
"contentType": "application/octet-stream",   
"fileData":  ""

}

Please anyone provide me the inputs.

Thanks in advance,

Vinuth

[ersureshbe]

Hi, I'm seeing you are parsing the attachment data in scripted API. I recommend to use ECC queue table. When you are parsing the attachment data from scripted API add a code to send it to ecc _queue table. But you should follow the syntax which field should have require value. I.e Attachment Creator is used , table name: sys_id of the record and send the base64 value in payload.

You can check the syntax in the Google or ServiceNow article.

[vinuth v]

Hi @ersureshbe 

Can you please provide any example, it will be helpful.

Thanks,

Vinuth

[ersureshbe]

Hi, Use the below link and follow the same syntax to achieve it

https://docs.servicenow.com/bundle/rome-application-development/page/integrate/inbound-soap/referenc...

[vinuth v]

Hi @ersureshbe 

I am using Scripted REST API, can you please provide example using Scripted REST API.

Thanks,

Vinuth