Hello, there is a good feature called "Download all of this Channel's feeds in CSV format" but it would be even better if it would be possible to download the data for the last day/week/month/year instead of downloading the whole data.
Also, it would be great to have the ability to clear the data for the last day/week/month/year instead of clearing all data.
The ability to clear the data for the last day or week would be very useful when sensors for some reason start to send some wrong data to ThingSpeak.
You can complete the desired download with a REST API call.
If you want more than one day, add the days parameter
You can append multiple parameters using &, for example:
If you want, go to your channel private view and use the 'Data Export' button there. Its next to the 'Add Visualizations' button. When you press the button, it builds the URL for you and opens a new tab (for .json or .xml). Look at the address and you can modify it to what you need. The default is 1 day or 8000 points. For '.csv' you can see the address when you hover over the '.csv', or just change the address from '.json' to '.csv'.
It is currently not possible to selectively delete data, I will look into if it could be included in a future update, thanks for your suggestions.
As of January 2018, ThingSpeak is not yet expiring any data. Your past data usage does not count against your new capacity. If you intend to convert to a free license, the easiest thing you can do is slow down the data rate from your devices. Your existing data collected on ThingSpeak will remain. Slowing down of ingesting data to ThingSpeak will ensure you don't exhaust the capacity. If you want to download a complete copy of your historical data, please reach out to support 'at' mathworks dot com with details about your channel that you want the data for. We can email you a csv file or a link to the file of your complete data set.
Most Users Ever Online: 114
Currently Browsing this Page:
Guest Posters: 1
Administrators: Hans, lee