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?