6:13 pm

December 16, 2018

9:28 am


Moderators
March 7, 2017

You can use the timezone parameter for the Read data API
https://www.mathworks.com/help/thingspeak/readdata.html
The time zones are listed here.
https://www.mathworks.com/help/thingspeak/time-zones-reference.html
Here is an example for +3
http://api.thingspeak.com/channels/9/feeds.json?timezone=Europe/Kiev
I think Rio is -2 at present, based on DST.
http://api.thingspeak.com/channels/9/feeds.json?timezone=America/Godthab&results=1000
or for excel compatible data
http://api.thingspeak.com/channels/9/feeds.csv?timezone=America/Godthab&results=1000
You can get up to 8000 results this way. At present the export to excel does not provide the adjusted timestamp. If you need more than 8000 points, you can use the start and end parameters to set times and use multiple reads.
12:58 am
February 13, 2019

cstapels said
You can use the timezone parameter for the Read data API
https://www.mathworks.com/help/thingspeak/readdata.htmlThe time zones are listed here.
https://www.mathworks.com/help/thingspeak/time-zones-reference.htmlHere is an example for +3
http://api.thingspeak.com/channels/9/feeds.json?timezone=Europe/KievI think Rio is -2 at present, based on DST.
http://api.thingspeak.com/channels/9/feeds.json?timezone=America/Godthab&results=1000
or for excel compatible data
http://api.thingspeak.com/channels/9/feeds.csv?timezone=America/Godthab&results=1000You can get up to 8000 results this way. At present the export to excel does not provide the adjusted timestamp. If you need more than 8000 points, you can use the start and end parameters to set times and use multiple reads.
Maravilloso!
Thank!!
Most Users Ever Online: 166
Currently Online:
25 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
rw950431: 272
Vinod: 240
piajola: 95
turgo: 70
vespapierre: 63
Adarsh_Murthy: 62
Member Stats:
Guest Posters: 1
Members: 8665
Moderators: 1
Admins: 2
Forum Stats:
Groups: 3
Forums: 14
Topics: 1600
Posts: 5760
Newest Members:
huldacormier, bogart, estebanmateo93, mikewrite, onlinebusiness, winzy99Moderators: cstapels: 460
Administrators: Hans: 405, lee: 457