CSV format data with API export only 1st field

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

Answer 1

[Vinod]

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

Answer 2

[Olivier HUBERT]

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

[Vinod]

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>

Answer 3

[Olivier HUBERT]

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