CSV format data with API export only 1st field

2 views (last 30 days)
Hello,
I'm using following command to output my data in CSV format
Problem is that file is outputed with only 1st field
created_at,entry_id,field1
2019-12-19 21:08:00 UTC,2228,8.09
2019-12-19 21:09:24 UTC,2229,8.09
2019-12-19 21:10:47 UTC,2230,50.09
2019-12-19 21:12:11 UTC,2231,24.09
How can I do to export all fields?
This channel has 5 fields.
Thanks a lot for your support
I wish you a merry Christmas

Answers (3)

Vinod
Vinod on 24 Dec 2019
I think you're looking for the API documented here: https://www.mathworks.com/help/thingspeak/readdata.html

Olivier HUBERT
Olivier HUBERT on 24 Dec 2019
Edited: Olivier HUBERT on 24 Dec 2019
Yes you are right but it said in the top "Read data from all fields in a channel".
My question is why I got only 1st field in the downloaded data file when using this command line
This channel have 5 fields in total.
Thanks for your help
Olivier
  1 Comment
Vinod
Vinod on 24 Dec 2019
Your request is specifically requesting only field 1.
https://api.thingspeak.com/channels/<channel_id>/fields/1.csv?api_key=APIKEY&start=2017-01-20&results=8000
If you want all fields, you have to get the entire channel feed
https://api.thingspeak.com/channels/<channel_id>/feeds.<format>

Sign in to comment.


Olivier HUBERT
Olivier HUBERT on 24 Dec 2019
Oups... I did not have notice in the doc sorry Thanks a lot Olivier

Communities

More Answers in the  ThingSpeak Community

Categories

Find more on ThingSpeak in Help Center and File Exchange

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!