download whole channel Feed | 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
download whole channel Feed
No permission to create posts
November 23, 2011
10:30 am
Avatar
peewag
New Member
Members
Forum Posts: 1
Member Since:
November 23, 2011
sp_UserOfflineSmall Offline

Hi,

 

i tried to download the whole data-set from one channel as csv-file.

 

I used this URL:

http://api.thingspeak.com/channels/(channel_id)/feed.csv

but I get only the last 2666 Entries (i know 8000 entries are the maximum (2666*3 fields = 8000))

 

then i tried

http://api.thingspeak.com/channels/(channel_id)/feed.csv&days=5

but that does not work.

 

i also tried, to download the whole data-set in small pieces:

http://api.thingspeak.com/channels/(channel_id)/feed.csv&start=2011-11-20 00:00:00&end=2011-11-21 00:00:00

but that also does not work.

 

Can someone give me a hint how to use the "Retrieving Channel Feeds Method"

 

best regards

 

Peter

November 24, 2011
11:16 am
Avatar
Hans
Natick, MA

Admin
Forum Posts: 411
Member Since:
January 18, 2011
sp_UserOfflineSmall Offline

There is no "download" all option just yet. We are thinking of adding a button the web app that allows you to do that.

The best way to get the data is to use time slices on the API.

Time format is as follows: 2011-07-09 00:00:00 (%20 is an encoded space) – that's year, month, date, hours, minutes, seconds – all 2 digits long.

Example: http://api.thingspeak.com/channels/627/charts/2?timescale=10&width=600&height=400&start=2011-07-08%2000:00:00&end=2011-07-09%2000:00:00

October 2, 2012
9:26 am
Avatar
jbowen
Michigan, USA
New Member
Members
Forum Posts: 3
Member Since:
May 9, 2012
sp_UserOfflineSmall Offline

I'm struggling with this same problem...I can't figure out how to download data from my feed.  I've tried several combinations, but here's the most recent, which looks ok?  

 

http://api.thingspeak.com/channels/(mychannelid)/field/(myfieldid).csv?start=2012-07-01%00:00:00&end=2012-07-09%00:00:00

 

It seems that no matter what I do, I get a -1 returned.  This includes clicking on the feed links in the "Developer Info" tab in my channel's page...they all return -1.  Thanks in advance for any advice...

October 2, 2012
9:33 am
Avatar
jbowen
Michigan, USA
New Member
Members
Forum Posts: 3
Member Since:
May 9, 2012
sp_UserOfflineSmall Offline

As usual, the problem is with me.  And as usual, within minutes of asking for help, I found my error.  In my case, I needed to add a 'key' to the url to make it work (my feed is not public).  Here's a url that works (for me, at least): 

 

http://api.thingspeak.com/channels/(mychannelid)/field/(myfieldid).csv?start=2012-07-01%00:00:00&end=2012-07-09%00:00:00&key=(myreadkey)

March 12, 2014
11:01 pm
Avatar
almarion
New Member
Members
Forum Posts: 4
Member Since:
March 8, 2014
sp_UserOfflineSmall Offline

Hi,
Great work you are doing!
Has there been any update as far as downloading csv for the entire stored data?
I noticed at least for me that the URL format has changed.
"&start" seems replaced/changed to "&start_date" for example.

Thanks.

March 13, 2014
5:36 pm
Avatar
turgo

Gold
Members
Forum Posts: 77
Member Since:
June 16, 2013
sp_UserOfflineSmall Offline

Hi almarion,

I build a web page tool that makes repeated api downloads, graphs them, and can export the whole data set as csv.
http://community.thingspeak.com/forum/announcements/thingspeak-live-chart-multi-channel-second-axis-historical-data-csv-export/

April 1, 2014
11:22 pm
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi,

We just released a new feature that allows you to download all of your Channel data. To do so, open your Channel in a web browser, click on the "Data Import / Export" tab, and you should see a button to download your data in CSV format.

lee

May 19, 2020
11:51 pm
Avatar
drewcssv
New Member
Members
Forum Posts: 1
Member Since:
February 6, 2020
sp_UserOfflineSmall Offline

Hi Lee, I know this is an old thread, but I am trying to use the "Data Import/Export" tab to download data from my channels. I do get the data but no headers other than "field1", "field2", etc. I need the actual names I assigned in the Channel Settings (see my Channel ID: 1039093) as I need them to help parse the data in a Javascript application. How do I do this? Here's what I typically get:

created_at,entry_id,field1,field2,field3,field4,field5,field6,field7,field8,latitude,longitude,elevation,status

what I need is:

created_at,entry_id,pm1,pm25,pm10,temp,humidity,latitude,longitude,aqi

Thanks for your help!!

May 27, 2020
8:43 am
Avatar
cstapels
Moderator
Members


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

If you use MATLAB analysis, you can use 'outputformat','timetable' and the column names will be your field names.
In the rest API, you can use the channel information call to read the field names.

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
13 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

Narayanavarma, kimjoongsik131, freerk, Tarunima, Juan7908, BYRON LALANGUI

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457