Download CSV & Clearing data | improvements requests. | Feature Requests | Forum

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_TopicIcon
Download CSV & Clearing data | improvements requests.
Avatar
Deimos
New Member
Forum Posts: 2
sp_UserOfflineSmall Offline
1
January 2, 2018 - 10:21 pm
sp_Permalink sp_Print

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.

Avatar
cstapels

Gold
Forum Posts: 126
sp_UserOfflineSmall Offline
2
January 3, 2018 - 2:30 pm
sp_Permalink sp_Print

You can complete the desired download with a REST API call. 

https://thingspeak.com/channels/276330/feed.csv

or

https://thingspeak.com/channels/276330/feed.json

If you want more than one day, add the days parameter

https://thingspeak.com/channels/276330/feed.csv?days=3

See the get channel feed documentation or get a channel field feed documentation for more parameters.

You can append multiple parameters using &, for example:

https://thingspeak.com/channels/276330/feed.json?days=3&sum=1440

 

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.

Avatar
cstapels

Gold
Forum Posts: 126
sp_UserOfflineSmall Offline
3
January 8, 2018 - 5:51 pm
sp_Permalink sp_Print

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.

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 252

Vinod: 164

cstapels: 96

piajola: 75

vespapierre: 63

Adarsh_Murthy: 59

Newest Members:

winnieeq69

AutoCheernpen

Bostermet

engladNed

iivenul

olewaeayafaku

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

 

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Administrators: Hans, lee