question Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore. in ITSM forum

Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Giovana Lopes — Wed, 24 Mar 2021 12:20:48 GMT

Hello,

I have a script wich integrates Azure devops.

When I add attachments from a specific group, it works well, but when I try with another group, the catch script returns: "Response body was requested to be saved as attachment. It's not available through getBody() anymore."

But it doesnt make sense, as well it works with another group.

Heres my code:

var att2 = new GlideRecord('sys_attachment');
att2.addQuery('table_sys_id', incident.sys_id);
att2.addQuery('file_name', attchFilename.toString());
att2.query();
if (att2.next()) {
cckFileName2 = true;
} else {
cckFileName2 = false;
}

if((!cckFileName) && (!cckFileName2) && (!comment.contains("Attachment from ServiceNow"))){

//var check = new global.VSTSUtils().getAttachment(attachId, incident.sys_id, Mfilename.toString());
try {
var r = new sn_ws.RESTMessageV2('VSTS Integration BI', 'Get Attachments');
r.setStringParameterNoEscape('id', attachId);
r.saveResponseBodyAsAttachment('incident', incident.sys_id, Mfilename.toString());

var response2 = r.execute();

var responseBody = response2.getBody();

var httpStatus = response2.getStatusCode();

if (httpStatus == "200" || httpStatus == "201") {
}

} catch (ex) {
var message = ex.message;
gs.log('catch: ' + message);
}

Can anybody help me?

Thank you

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Ankur Bawiskar — Wed, 24 Mar 2021 12:46:35 GMT

Hi,

Can you explain what it means it works for specific group?

you can consuming 3rd party endpoint?

So is there any specific thing you are sending which identifies the group

please explain in detail with steps

Regards
Ankur

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Giovana Lopes — Wed, 24 Mar 2021 14:46:55 GMT

Hi, Ankur!

Thanks for answer!!

When I open an incident wich group is "A" or "B", it opens a work item in Azure devops.

After that, when I try to send an attachment from ServiceNow to Azure, its all working.

But when I send from azure to Servicenow, it works well with group "A", but when i send from group 'B', it doesnt work

I hope you understand me.

Warn me if you have questions

Thank you

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Ankur Bawiskar — Wed, 24 Mar 2021 15:06:28 GMT

Hi,

So what is the error message?

what is the difference in both the JSON body when you send file for Group A and file for Group B?

Regards
Ankur

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Giovana Lopes — Wed, 24 Mar 2021 17:03:49 GMT

Its the same JSON body for both

The error message is:

Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Ankur Bawiskar — Thu, 25 Mar 2021 04:45:19 GMT

Hi,

not much sure on this

Regards
Ankur

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

michaelward — Thu, 06 May 2021 12:04:49 GMT

Yeah, this seems to be buggy as all get out. When I create a REST service to table_list.do?CSV or table_list.do?EXCEL, it works fine when running a test, but no combination of the following works. As you can see, the call to the rest service is parameterized as the REST service's Default GET has the proper ?CSV or ?EXCEL extension on the endpoint. All other combinations seem to not work. The 'text/html' appears to be that when run via script like below, you just get ServiceNow's html page response, but if you run directly in outbound REST as a test on Default GET method, it works. Below I was switching between using saveResponseBodyAsAttachment vs. a GlideSystemAttachment.write(). Neither seem to work. saveResponseBodyAsAttachment gives a stack trace. GlideSystemAttachment.write() produces corrupted files. By the way, my REST Services are setup with basic auth to a service account and they have a full endpoint. Partial or relative endpoints, i.e. "/table_list.do?EXCEL' do not work due to a 'host is null' error.

vars passed in: fileName, tableName, tableId.....

var request = new sn_ws.RESTMessageV2(restName, restMethod);
request.saveResponseBodyAsAttachment(tableName, tableId, fileName);
response = request.execute();
if (response.getStatusCode() == '200') {

var binaryFile = response.getBody();//Receiving excel file, binary data.
var attachment = new GlideSysAttachment();
var sqGr = new GlideRecord(tableName);
sqGr.get(sqTableId);

//attachment.writeBase64(sqGr, fileName, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", gs.base64Encode(binaryFile)); // corruption
//attachment.writeBase64(sqGr, fileName, "text/csv", binaryFile); // corruption
//attachment.write(sqGr, fileName, "text/csv", binaryFile); // this works for .CSV

}

Stack trace:

Security restricted: MIME type mismatch for file: query_attachment3.csv. Expected type:text/csv, Actual type: text/html
Security restricted: File type is not allowed or does not match the content for file query_attachment3.csv
Evaluator: com.glide.rest.util.RESTRuntimeException: Response body was requested to be saved as attachment. It's not available through getBody() anymore.
   Caused by error in script at line 472
	com.glide.rest.outbound.direct.DirectRESTResponse.getBody(DirectRESTResponse.java:86)
	com.glide.rest.outbound.scriptable.ScriptableRESTResponse.jsFunction_getBody(ScriptableRESTResponse.java:82)
	sun.reflect.GeneratedMethodAccessor2549.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

kente — Sun, 27 Jun 2021 19:27:26 GMT

Joining in on having the issue.

However i get the actual attachment created, but the REST message still fails with
"Response body was requested to be saved as attachment. It's not available through getBody() anymore."

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Rahman3 — Mon, 28 Jun 2021 02:46:13 GMT

Hello,

HTTP response is a stream that you cannot process twice. saveResponseBodyAsAttachment is already processing the response and therefore you cannot do again response.getBody();

What you possibly need to do is this:

var request = new sn_ws.RESTMessageV2(restName, restMethod);
response = request.execute();
if (response.getStatusCode() == '200') {

var binaryFile = response.getBody();//Receiving excel file, binary data.
var attachment = new GlideSysAttachment();
var sqGr = new GlideRecord(tableName);
sqGr.get(sqTableId);

// Write your own code to save the response Body as attachment

Hope this helps

Re: Integration attachement error: Response body was requested to be saved as attachment. It's not available through getBody() anymore.

Abhinav Duvvuri — Wed, 13 Jul 2022 23:04:07 GMT

Hey, Thanks for this. It was very helpful in resolving the error.