Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

zadravecm
New Contributor II

Number in HTTPHEADER at WITH CONNECTION call

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



2 Replies
b_knuever
Contributor III

Re: Number in HTTPHEADER at WITH CONNECTION call

Can you give the Variable LET/SET statement?

zadravecm
New Contributor II

Re: Number in HTTPHEADER at WITH CONNECTION call

LOAD

    "time",

    signature

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

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

Community Browser