CSV format data with API export only 1st field
2 views (last 30 days)
Show older comments
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
0 Comments
Answers (3)
Vinod
on 24 Dec 2019
I think you're looking for the API documented here: https://www.mathworks.com/help/thingspeak/readdata.html
0 Comments
Olivier HUBERT
on 24 Dec 2019
Edited: Olivier HUBERT
on 24 Dec 2019
1 Comment
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>
Communities
More Answers in the ThingSpeak Community
See Also
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!