Attachment API Invalid file type issue

bota — Mon, 04 Mar 2024 12:48:04 GMT

Hello,

I am trying to attach excel file using attachment API and i am getting

Invalid file type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet error. I only get this error when trying to do this using a third-party tool, that requires me to write the payload in js. And only when i am trying to send excel files i tried to upload pdf the same way and it works. Here's my code:

===============================================================

let options = {

method: 'POST',

url: 'attachment/file?table_name=my_table&table_sys_id=' + sys_id + '&file_name=' + filename,

responseType: 'json',

resolveBodyOnly: true,

metadataType: irpa_core.enums.request.metadataType.formData,

headers: {

'Content-Type': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',

'Accept': '*/*'

body: content

};

return options;

===============================================================

I don't have any problem calling it via thunder client with the same payload:

Here's the CURL that works for the excel file:

curl -X POST \

'https://myinstance.service-now.com/api/now/attachment/file?table_name=mytable&table_sys_id=mysysid&file_name=myfilename' \

--header 'Accept: */*' \

--header 'Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' \

--header 'Authorization: Basic ' \

--data-binary '@c:\myfile.xlsx'

Any idea why it works with this CURL and doesn't work with the js code above?

Thank you!

Bota

Re: Attachment API Invalid file type issue

Kris Moncada — Wed, 31 Jul 2024 14:37:43 GMT

Hi @bota ,

Did you ever get this resolved? I'm running into a similar issue; but my code is server-side.

Re: Attachment API Invalid file type issue

bota — Thu, 01 Aug 2024 13:40:48 GMT

Hi @Kris Moncada ,

Unfortunately I was not able to resolve this issue.

question Re: Attachment API Invalid file type issue in Developer forum

Attachment API Invalid file type issue

Re: Attachment API Invalid file type issue

Re: Attachment API Invalid file type issue