pass a dynamic variable to a parameter in api

marjan_it — Sat, 16 Nov 2024 17:42:39 GMT

Hi All

I have an api that get startdate, enddate and citycode. H want to pass date(now()) as enddate, date(now()-10) as startdate and citycode from a table in my database.

I use the following ruls in loading api but it doesnt work

let startdate=date(now()-10)

let enddate=date(now())

WITH CONNECTION(
QUERY "p_start_date" "$(startdate)",
QUERY "p_end_date" "$(enddate)",
QUERY "p_citycode" "$(citycode)")
;

how can I do that?

topic pass a dynamic variable to a parameter in api in QlikView

pass a dynamic variable to a parameter in api