Number in HTTPHEADER at WITH CONNECTION call

Anonymous — Mon, 05 Mar 2018 09:32:47 GMT

Hi,

I have some API to call to get the data, but I need to add some parameters in header of that call, on the fly.

I figure out that this is done by WITH CONNECTION and then add some HTTPHEADER inside.

My problem is, that I don't know how to add number parameters inside the HTTPHEADER.

For example:

If I write this :

HTTPHEADER "request_time" "$(time)"

then I get error:

Error 500: Authentication failed: For input string: "1523845473.650126"

I guess that problem is in quotes, because server expect number. But if I try any of the solutions:

HTTPHEADER "request_time" $(time)

HTTPHEADER "request_time" time

HTTPHEADER "request_time" '$(time)'

I get error in Qlik Sense that sintax is wrong.

How to deal with the numbers in HTTPHEADER ?

Marko

Re: Number in HTTPHEADER at WITH CONNECTION call

bramkn — Mon, 05 Mar 2018 10:02:22 GMT

Can you give the Variable LET/SET statement?

Anonymous — Mon, 05 Mar 2018 10:04:25 GMT

LOAD

"time",

signature

FROM [lib://python/....xml] (XmlSimple, table is param);

let time = peek('time',0,'param');