Channel export to CSV limit? | ThingSpeak API | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





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

sp_Feed sp_TopicIcon
Channel export to CSV limit?
No permission to create posts
May 18, 2017
5:01 am
Avatar
femuruy
New Member
Members
Forum Posts: 1
Member Since:
May 18, 2017
sp_UserOfflineSmall Offline

Hi guys, new to this so please let me apologize in advance for my questions!

 

I created a channel that is being updated every 15 min by a sensor array (that is working perfectly)

https://thingspeak.com/channels/270574

But when i try to download the csv it only downloads the last 100 data points, how do i download the whole data set to CSV?

 

Thanks in advance for your help!

April 30, 2018
4:36 pm
Avatar
cstapels
Moderator
Members


Moderators
Forum Posts: 287
Member Since:
March 7, 2017
sp_UserOfflineSmall Offline

The data export on the private and public views of your channel will default to the last day of date. Use the data export feature on the data export tab to retrieve the contents of the whole channel.

When you click the data export on the channel view, you will see the format for the rest call in your browser window. You can add another parameter, such as ?days=5 if you want more data, but not all of it.

see https://www.mathworks.com/help/thingspeak/readdata.html for the format and full list of parameters that you can add.
If you use two parameters, use ampersand for the second parameter, for example: '?days=4&sum=10'

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online: samdavies
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 261

Vinod: 196

piajola: 85

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

Newest Members:

Lakshmanaprakash S B, bettetj60, ronnievw3, bessiesj18, Pavan kumar, Williampup

Administrators: Hans: 387, lee: 457