5:23 am

April 22, 2019

Hi,
I am trying to bulk-write the data from the example : https://es.mathworks.com/help/thingspeak/bulkwritecsvdata.html#mw_9108a4c1-a09f-4a9c-94fe-8e6dde3634ea_seealso
However, I am always generating an error code (400 - Bad request) and I don't know why. Can anyone, watching my simple code, help me ? Thanks in advance !
import requests
url = "https://api.thingspeak.com/channels/"+channelID+"/bulk_update.csv" #I use my channelID
data = "write_api_key=XXXXXXXXXXXXXXXX&time_format=absolute&updates=2018-01-30T10%3A26%3A2-0500%2C2%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%7C2018-01-30+10%3A26%3A23-0500%2C2%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%7C2018-01-31+10%3A27%3A2-0500%2C16%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%7C2018-01-31+11%3A26%3A32-0500%2C2%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%7C2018-01-31+11%3A27%3A22-0500%2C164%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C%2C"
# I use my api key instead of Xs
requestHeaders = {"User-Agent":"mw.doc.bulk-update (Raspberry Pi)","Content-Type":"application/x-www-form-urlencoded","Content-Length":str(len(data))}
r = requests.post(url,data=data,headers=requestHeaders)
print(r.status_code)
############################
#I have the same results with urllib2:
############################
import urllib2 as ul
req = ul.Request(url = url)
req.add_header("User-Agent","mw.doc.bulk-update (Raspberry Pi)")
req.add_header("Content-Type","application/x-www-form-urlencoded")
req.add_header("Content-Length",str(len(data)))
req.add_data(data) # Add the data to the request
try:
response = ul.urlopen(req) # Make the request
print response.getcode() # A 202 indicates that the server has accepted the request
except ul.HTTPError as e:
print e.code
Most Users Ever Online: 166
Currently Online:
24 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
rw950431: 272
Vinod: 240
piajola: 95
turgo: 70
vespapierre: 63
Adarsh_Murthy: 62
Member Stats:
Guest Posters: 1
Members: 8665
Moderators: 1
Admins: 2
Forum Stats:
Groups: 3
Forums: 14
Topics: 1600
Posts: 5760
Newest Members:
bogart, estebanmateo93, mikewrite, onlinebusiness, winzy99, Zark_zeuganModerators: cstapels: 460
Administrators: Hans: 405, lee: 457