Query with time limit to read the field is not working

1 次查看(过去 30 天)
I am reading a field for data of last 45 minutes.
The query given is as follows on the browser.
*** represent my channel id and api key.
I expect that last 45 minutes readings should be available. The response is as follows.
{"channel":{"id":*******,"name":"Pump Parameters","description":"Starting Date, Starting Time, No of working hours.","latitude":"0.0","longitude":"0.0","field1":"Starting Date","field2":"Starting Time","field3":"Working Hours","field4":"Remaining Hours","field5":"User Request","field6":"Pump Status","created_at":"2021-12-03T04:20:52Z","updated_at":"2022-01-20T10:02:50Z","last_entry_id":206},"feeds":[{"created_at":"2022-07-04T01:02:03Z","entry_id":40,"field6":"7"},{"created_at":"2022-07-18T01:02:03Z","entry_id":39,"field6":"7"}]}
Last 2 readings are incorrect. entry_id: 40 and entry_id:39
How to avoid these two readings. I also had valid readings in this time span but still id39 and id40 is appearing in the response. date shown for these id's in not correct. Please advice about getting correct response. It is not possible to use Matlab as I am using Web Page integration. this is free and private channel.

回答(1 个)

Christopher Stapels
You can use MATLAB in the free ThingSpeak even if you dont have a seperate MATLAB license.
Those two readings have a timestamp of July 2022,so they occur in the future. I suggest you download then clear the channel data, then delete those entries, and then write the rest of the data (or new data) back to the channel.

社区

更多回答在  ThingSpeak Community

类别

Help CenterFile Exchange 中查找有关 Read Data from Channel 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by