Thingspeak bulk update csv problem

I'm not able to perform the bulk update using either an embedded system (ESP8266) or sending a POST request via web based service (https://reqbin.com).

I always get a 400 response with "The request cannot be fulfilled due to bad syntax."

No problem using the standard write data interface (but of course it's limited to one message).

The POST request content is (I have my key instead of XX):

write_api_key=XXXXXXXXXXXXXXXX&timeFormat=relative&updates=4,1.1,2,0.3,6,7.7,0.8,0,0,41.2,9,1,ok

I did a lot of trials changing the number of parameters and the time format, but always with the same result.

Is anyone able to perform any kind of bulk update?

Answer 1

[Hans Scharler]

What URL are you sending the POST request? For this format, you need this URL: https://api.thingspeak.com/channels/XXXYYY/bulk_update.csv

Replace XXXYYY with your channel ID.

[Alberto Maccioni]

Yes, the URL is correct.

I tried http, https, and without prefix.

By the way, same thing with json bulk update.

Have you tried any kind of bulk update lately?

[Hans Scharler]

I see the issue. You need to change timeFormat to time_format.

I will have the doc team make sure the example is written consistently.

[Alberto Maccioni]

Thanks a lot, it works now.