Download a file via REST API from Excel?

[Rainer Hitzeman]

Hi to everybody!

Hopefully I'm in the correct forum. I've managed do transfer data from a Servicenow instance to an Excel spreadsheet via REST API, mainly using code from this page: https://www.servicenowelite.com/blog/2015/9/22/connect-servicenow-to-microsoft-excel-with-rest-webse...

Where I've failed is to download a binary file (zip) from Servicenow. I have the url to download a file after I have provided my login data, but I'm still unable to automate the process via Excel and VBA.

Any help is greatly appreciated!

Rainer

[Ankur Bawiskar]

@Rainer Hitzemann 

refer below link for help

Download attachment using SNOW REST API attachment table

REST Object Byte Stream  -> REST Object Byte Stream

Scripted REST API will download a file

Processor script in Scripted rest api

Regards
Ankur

[Rainer Hitzeman]

@Ankur Bawiskar

Thanks, I'll give it a try. But first, I have to transfer the code to Microsoft VBA...

Regards, Rainer

Ankur Bawiskar

ServiceNow Consultant at Deloitte

309,645 points - Community Level 10