JSON Bulk Write to ThingSpeak Channel, 401 Unauthorized Error

Question

cog 2023-2-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1911075-json-bulk-write-to-thingspeak-channel-401-unauthorized-error

编辑： Christopher Stapels 2023-8-2

I am attempting to bulk write some JSON data to a ThingSpeak channel using the API. An example payload is:

% Payload is
data =
  {
    'write_api_key': <my_api_write_key>,
    'updates': [
      {'field5': 833.205, 'field4': 6, 'field3': 775.648, 'field2': 24.2523, 'delta_t': 1, 'field1': 59.1391}, 
      {'field5': 833.199, 'field4': 6, 'field3': 771.03, 'field2': 24.2844, 'delta_t': 2, 'field1': 59.1331}, 
      {'field5': 833.208, 'field4': 6, 'field3': 750.343, 'field2': 24.3008, 'delta_t': 3, 'field1': 59.1405}, 
      {'field5': 833.208, 'field4': 7, 'field3': None, 'field2': 24.2903, 'delta_t': 5, 'field1': 59.1479}, 
      {'field5': 833.216, 'field4': 7, 'field3': 748.45, 'field2': 24.2965, 'delta_t': 6, 'field1': 59.1686}, 
      {'field5': 833.21, 'field4': 8, 'field3': None, 'field2': 24.2914, 'delta_t': 7, 'field1': 59.1756}, 
      {'field5': 833.204, 'field4': 8, 'field3': 738.847, 'field2': 24.2867, 'delta_t': 8, 'field1': 59.1943}, 
      {'field5': 833.208, 'field4': 8, 'field3': 732.472, 'field2': 24.2814, 'delta_t': 10, 'field1': 59.1964}, 
      {'field5': 833.212, 'field4': 8, 'field3': None, 'field2': 24.2599, 'delta_t': 11, 'field1': 59.1971}, 
      {'field5': 833.207, 'field4': 8, 'field3': 737.475, 'field2': 24.2658, 'delta_t': 12, 'field1': 59.2122}, 
      {'field5': 833.212, 'field4': 8, 'field3': None, 'field2': 24.2498, 'delta_t': 14, 'field1': 59.2161}, 
      {'field5': 833.209, 'field4': 7, 'field3': 749.432, 'field2': 24.2503, 'delta_t': 15, 'field1': 59.2298}, 
      {'field5': 833.208, 'field4': 7, 'field3': 760.224, 'field2': 24.2396, 'delta_t': 16, 'field1': 59.2308}
     ]
  }

I am sending this payload programatically, in Python, with the requests library using the following command:

response = requests.post(url='https://api.thingspeak.com/channels/<my_channel_id>/bulk_update.json', ...
    data=json.dumps(data))

This results in the response below:

% Response
   {
    "status": "401",
    "error": {
      "error_code":"error_auth_required",
      "message":"Authorization Required",
      "details":"Please provide proper authentication details."
      }
   }

I am certain that the API write key and channel_id are correct. I have used both for single writes successfully. I am using a free ThingSpeak account. I have also tried adding headers to the requests.post() call to indicate explicitly that this is json data. I'm not sure why this is occuring and would sincerely appreciate any pointers.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Christopher Stapels 2023-2-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1911075-json-bulk-write-to-thingspeak-channel-401-unauthorized-error#answer_1170685

It seems that ThingSpeak is not understanding your API key. This example for an RPI uses python. Does your code look similar?

Also you may want to put delta t first, the endpoint may be expecting the time data first. See the example Bulk Write with Reletive Timestamps in the bulk jso write doc.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Christopher Stapels 2023-8-2

Are you able to post to the regular write endpoint with the same API key and channel ID?

Christopher Stapels 2023-8-2

编辑：Christopher Stapels 2023-8-2

@Erol Probably better to start a new post though. Make sure you show the whole part of the code that does the posting, and desribe your hardware please.

请先登录，再进行评论。