CSV format data with API export only 1st field

12 次查看（过去 30 天）
Olivier HUBERT
Olivier HUBERT 2019-12-23
回答： Olivier HUBERT 2019-12-24
Hello,
I'm using following command to output my data in CSV format
https://api.thingspeak.com/channels/CHANNEL/fields/1.csv?api_key=APIKEY&start=2017-01-20&results=8000
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

请先登录，再回答此问题。

回答（3 个）

Vinod
Vinod 2019-12-24
I think you're looking for the API documented here: https://www.mathworks.com/help/thingspeak/readdata.html
Olivier HUBERT
Olivier HUBERT 2019-12-24
编辑：Olivier HUBERT 2019-12-24
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
https://api.thingspeak.com/channels/CHANNEL/fields/1.csv?api_key=APIKEY&start=2017-01-20&results=8000
This channel have 5 fields in total.
Thanks for your help
Olivier
  1 个评论
Vinod
Vinod 2019-12-24
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>

请先登录，再进行评论。

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

社区

更多回答在  ThingSpeak Community

类别

在 Help Center 和 File Exchange 中查找有关 Downloads 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by