Server Error (500) on existing data update

User Support API
, ,
1

Hello,
I am attempting to update a specific column variable within existing data using submission IDs. However, the updates are failing, and an error is being displayed: " Server Error (500)"
The code is in python:

import requests
import json

URL = 'https://kf.kobotoolbox.org/api/v2/assets/formID/data/bulk/'
TOKEN = 'secret'
PARAMS = {
    'format': 'json'
}
HEADERS = {
    'Authorization': f'Token {TOKEN}'
}

payload = {
    'submission_ids': ['259050319',
'259050324',
'259071342',
'259072431'
],
    'data': {'sectionC/commune': '555'}
}

res = requests.patch(
    url=URL,
    data={'payload': json.dumps(payload)},
    params=PARAMS,
    headers=HEADERS
)

print(res.status_code)
print(res.text)

Thanks

2

Welcome back to the community, @momou28! Maybe this post discussed previously should give you a clue on how to achieve it?

3

image
image948×312 8.05 KB

Thank you very much LAM. I followed the video that explains the solution using the Postman tool, and I applied the process, but I still get the same “500 Internal Server Error.” I think it’s a server-related error because the same script was working before. Could there be a blocking mechanism after several unsuccessful attempts? Ngnix or other bugs on your server! Thank you.

4

I have exactly the same problem. (use the same code)

What I have discovered is that it occurs only if the record was created via Kobocollect.
If its created via Enketo, the code works fine.
As soon as the record created via Kobocollect was ‘manually’ updated via Enketo, the code works as well.

Does this give anyone any ideas?