10:30 am

November 23, 2011

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
11:16 am

Admin
January 18, 2011

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.
9:26 am

May 9, 2012

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...
9:33 am

May 9, 2012

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)
11:01 pm

March 8, 2014

5:36 pm


Gold
June 16, 2013

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/
11:51 pm

February 6, 2020

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!!
Most Users Ever Online: 166
Currently Online:
28 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:
kusmumichael, petersmith99, Rambant, blakeharriss09, optisol, Niyonzima FilsModerators: cstapels: 460
Administrators: Hans: 405, lee: 457