{"id":914,"date":"2012-03-22T23:17:29","date_gmt":"2012-03-23T04:17:29","guid":{"rendered":"https:\/\/blogs.mathworks.com\/iot\/?p=914"},"modified":"2012-03-22T23:18:27","modified_gmt":"2012-03-23T04:18:27","slug":"accessing-historical-data-on-a-thingspeak-channel","status":"publish","type":"post","link":"https:\/\/blogs.mathworks.com\/iot\/2012\/03\/22\/accessing-historical-data-on-a-thingspeak-channel\/","title":{"rendered":"Accessing Historical Data on a ThingSpeak Channel"},"content":{"rendered":"
We have recently\u00a0received\u00a0a few email about accessing historical data. We even noticed some posts on other forums asking about older data.<\/p>\n
All ThingSpeak Channels are\u00a0continuous\u00a0logs of data. Using API commands, you can access recent data and historical data. The default API parameters allow for easy access to recent data. To get access to older data, all you need to do is pass in a “start” and “end” parameter into a channel request.<\/p>\n
Here is my feed from New Year’s Eve:<\/p>\n
http:\/\/api.thingspeak.com\/channels\/9\/feed.json?start=2011-12-31%2000:00:00&end=2012-01-01%2000:00:00<\/a><\/p>\n And remember, you can also do this with charts too:<\/p>\n http:\/\/api.thingspeak.com\/channels\/9\/charts\/2?start=2011-12-31%2000:00:00&end=2012-01-01%2000:00:00&average=60<\/a><\/p>\n Let us know if you need any more\u00a0clarification\u00a0on the many API parameters possible. Have fun!<\/p>\n PS. Some big features coming soon!<\/p>\n","protected":false},"excerpt":{"rendered":" We have recently\u00a0received\u00a0a few email about accessing historical data. We even noticed some posts on other forums asking about older data.
\nAll ThingSpeak Channels are\u00a0continuous\u00a0logs of data. Using… read more >><\/a><\/p>\n","protected":false},"author":148,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[30,17],"_links":{"self":[{"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/posts\/914"}],"collection":[{"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/users\/148"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/comments?post=914"}],"version-history":[{"count":4,"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/posts\/914\/revisions"}],"predecessor-version":[{"id":918,"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/posts\/914\/revisions\/918"}],"wp:attachment":[{"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/media?parent=914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/categories?post=914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.mathworks.com\/iot\/wp-json\/wp\/v2\/tags?post=914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}