CSV format data with API export only 1st field

2019 12 23
3 个回答
更新时间：2019 12 24
3 次查看（30 天）

0 个投票

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 个）

Olivier HUBERT
Olivier HUBERT 2019-12-24
编辑：Olivier HUBERT 2019-12-24

0 个投票

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 个评论
显示 -1更早的评论 隐藏 -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

0 个投票

Oups... I did not have notice in the doc sorry Thanks a lot Olivier

社区

更多回答在  ThingSpeak Community

类别

在 帮助中心 和 File Exchange 中查找有关 Downloads 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by