I cannot read history data older than one month

Ilias Lamprou on 23 Dec 2023
Latest activity Edit by Christopher Stapels on 28 Dec 2023

Hi, while I can download data from the thingspeak page as csv older than 5 months, I can't read history data older than one month.
The data exists on the database.
This are my requests:
https://api.thingspeak.com/channels/667773/fields/1.json?start=2023-11-23T01:01:10.000Z
The same results. Every day the older value date is higher by one day.
Today the older value day is: 2023-11-25T02:13:46Z
Why? Is there a limit to history data loading?
Christopher Stapels
Christopher Stapels on 23 Dec 2023

I think you need the end parameter ad well. Without it, thingspeak might read backwards to try to get to ‘start” but stop when it gets to 8k records. Anyway, im sure you need both start and end parameters to get date based reads to work.

Ilias Lamprou
Ilias Lamprou on 23 Dec 2023
Hi, I have already tested. The same results.
This is a request:
Today the latest day I can get data is: 2023-11-25T19:17:27Z
Some hours later than last night.
The channel is public, everyone can test the results.
I believe there is some limit from the server
Christopher Stapels
Christopher Stapels on 23 Dec 2023 (Edited on 28 Dec 2023)
There is definitely a limit of 8000 records. If you want more data than that, you will need to do multiple reads. Make sure you delay between reads at least a little so you dont slam the server.
Have a look at the tip in the blue box: Read Data