Hi,
I am using metabase APIs for getting data from metabase question. My question has the SQL parameters. t1 and t2.
select * from totalcalls where starttime between {{t1}} and {{t2}}
t1 and t2 have their type as Date.
I am using the below query to get the data from the metabase.
[{“type”:“date”,“target”:[“variable”,[“template-tag”,“t1”]], “value”: “05-01-2020”},{“type”:“date”,“target”:[“variable”,[“template-tag”,“t2”]], “value”:“05-10-2020”}]
When I send this POST request I get the error “Unable to substitute parameters”,
Please tell me what is the correct way to pass the date type parameters?