MATLAB Answers

0

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?

  0 Comments

Sign in to comment.

Products

1 Answer

Answer by Hans Scharler on 6 May 2019
 Accepted Answer

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.

  3 Comments

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?
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.
Thanks a lot, it works now.

Sign in to comment.