Bulk upload issue - HTTP Error code 502

1 次查看（过去 30 天）
Johannes Kuder
Johannes Kuder 2022-1-6
评论： Christopher Stapels 2022-1-9
Obviously I asked my question in the wrong forum before. Hope this is the right one.
Dear community,
I'm trying to bulk upload data from my IoT server to ThingSpeak through a Python script. I get HTTP Error code 502 as response, which obviously means "Bad Gateway" - "The server received an invalid response from the upstream server. Check your network connection and try again."
No idea how to fix this. Can anybody please help?
import requests
import csv
import json
indices = {
"created_at" : 0,
"field1" : 1,
"field2" : 2,
"field3" : 4,
"field4" : 6,
"field5" : 7,
"field6" : 8,
"field7" : 9,
"field8" : 10,
}
r = requests.get("https://[MyServer]/[MyFile.csv]")
rows = r.text.splitlines()
reader = csv.reader(rows)
parsed_csv = list(reader)
objects = []
for row in parsed_csv:
new_object = {}
for key, value in zip(indices.keys(), indices.values()):
new_value = row[value]
new_object[key] = new_value
objects.append(new_object)
body = {
"write_api_key" : "MyWriteApiKey",
"Content-Type" : "application/json",
"updates" : objects,
}
response = requests.post("https://api.thingspeak.com/channels/[MyChannel]/bulk_update.json", data=json.dumps(body))
print(response.status_code)
Of course I have checked the document of the API of thingspeak.com, and I don't think that I will exceed the rate limit, since this upload is a one-time call, and the data amount in the CSV file is small enough.
Thanks Johannes
  3 个评论
显示 1更早的评论
Christopher Stapels
Christopher Stapels 2022-1-9
Im sorry, I didnt read far enough into your code. You are using the json endpoint for bulk. We also have a csv endpoint which Is how I got confuesd. You are reading the csv file from somewhere else to create the JSON request.
The bulk syntax can be tricky, though I wouldnt expect a 502 from bad syntax. Just to be sure, can you hard code a request of the proper format instead of creating it dynamically from the local file? The endpoint might be getting confused if you send extra material in the header.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

社区

更多回答在  ThingSpeak Community

类别

在 Help Center 和 File Exchange 中查找有关 Read Data from Channel 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by