download whole channel Feed

The ThingSpeak community site has been upgraded to a new site. This site is currently in read-only mode. You can ask questions or post and read discussions on the new site.

download whole channel Feed

November 23, 2011
10:30 am

peewag

New Member

Members

Forum Posts: 1

Member Since:
November 23, 2011

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

Hans

Natick, MA

Admin

Forum Posts: 411

Member Since:
January 18, 2011

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

jbowen

Michigan, USA

New Member

Members

Forum Posts: 3

Member Since:
May 9, 2012

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

jbowen

Michigan, USA

New Member

Members

Forum Posts: 3

Member Since:
May 9, 2012

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

almarion

New Member

Members

Forum Posts: 4

Member Since:
March 8, 2014

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

turgo

Gold

Members

Forum Posts: 77

Member Since:
June 16, 2013

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

lee

Admin

Forum Posts: 457

Member Since:
March 14, 2011

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

drewcssv

New Member

Members

Forum Posts: 1

Member Since:
February 6, 2020

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

cstapels

Moderator

Members

Moderators

Forum Posts: 885

Member Since:
March 7, 2017

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.

January 1, 2021
11:23 am

scjerry

New Member

Members

Forum Posts: 1

Member Since:
September 12, 2020

Offline