Thingspeak bulk update csv problem

1 view (last 30 days)
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?

Accepted Answer

Hans Scharler
Hans Scharler on 6 May 2019
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
Hans Scharler
Hans Scharler on 8 May 2019
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
Alberto Maccioni on 8 May 2019
Thanks a lot, it works now.

Sign in to comment.

More Answers (0)

Communities

More Answers in the  ThingSpeak Community

Categories

Find more on Read Data from Channel in Help Center and File Exchange

Products

Community Treasure Hunt

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

Start Hunting!