Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
marjan_it
Creator III
Creator III

pass a dynamic variable to a parameter in api

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?

Labels (2)
0 Replies