How to use date range for your timezone in thingspeak?

Hi Team

I have the following Rest URL, but i notice the timezone is not correct. I am in South Africa and want it to correstpdonf with my auto time as per time and date. What could be reason for this issue below?

https://api.thingspeak.com/channels/929272/fields/1.csv?key=O6P4N8AVZWKNGK5U&start=2019-12-06T00:00+02:00&end=2019-12-09T23:59+02:00

[Håkon Dahle]

Hi,

the URL uses UTC+02:00 which I believe is the same as South Africa Standard Time.

Note that the data returned in the CSV-file will show times in UTC. So when the first line in the CSV-file says

2019-12-06 05:54:43 UTC

this is actually the same as

2019-12-06 07:54:43 SAST South Africa Standard Time.

Answer 1

[Christopher Stapels]

You can use the timezone or offset parameters.

They are documented in the Read Data documentation page. Be sure to change the api key to match your read api key.

https://api.thingspeak.com/channels/929272/fields/1.json?key=XXXXXXXXXXXXXXXX&start=2019-12-06T00:00+02:00&end=2019-12-09T23:59+02:00&timezone=Africa/Johannesburg