pass a dynamic variable to a parameter in api

[marjan_it]

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?