Convert Timestamp from a JSON Query

Hello Everyone!

I’m querying some external data from this API url: https://economia.awesomeapi.com.br/USD-BRL/10?start_date=20200201&end_date=20200229 but the timestamp column is not being converted to DateTime or Date, how can I force this convertion?

Thanks :smiley:

What format do the timestamps arrive in from the API? If Redash can’t parse them as dates you can use the Query Results data source to reformat them. Downside is it means you’ll need two queries (one against the JSON source and one against QRDS).

The problem is that my Json request uses parameters so i’m facing problems to pass the parameters to it.

What format do you need the parameter in? I think the parameters for dates are fixed to ISO8601 YYYY-MM-DD