Let’s assume you have to connect to a third party API such as l’addition that uses a
bearer KEY and one ore more other
application KEY(s) in the header to get your data.
headers in HttpDownload is a string. And we need somehow an array, ie:
‘Authorization’: ‘Bearer 12345’
But the GET to the endpoint will pass our header as a unique array to string converted blobed thing but how to pass that to our beloved Query Tool?
It is as simple as that:
select * from httpdownload@DataDictionary ( url => 'https://myniceurl.com' , contentType => 'application/json' , headers => 'Authorization=Bearer 12345' || '&ApplicationKey=4878' , diskCache => true , method => 'GET' )
You’ll notice the notice & before the key following the
You’ll notice also the space between the Bearer and the value itself. Leave it like this, it just works (no need for