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?

5

I also have the same problem, and indeed when I edit the submission with enketo via the UI, then use the API it work, but for the data that is not yet edited via enketo, the api doesn’t work

6

Has there been any resolution on this? We are having the same problem with our KoboToolbox instance. We want to bulk update our records but the API is failing due to reasons highlighted in this thread (producing error 500 especially for records submitted from the mobile app). Any help on this?

7

Is there a solution to this? We also have the same issue with a file that has been working for over 2 years.
However, in our case, we are pulling the data into Excel through the Kobo API using Powerquerry.

8

hi @sector, do you want to edit your data though api? or you just want to connect your data to power query? what i understood from your message, you are trying to achieve the option two

9

No I use the API to pull the data into power query then all edits are done within the query editor

10

I asked because this is to edit the submission though API. If your link were working over the last two years, you probably using the kobo.humanitarian.info link. This link is no longer working you need to change your link to https://eu.kobotoolbox.org/

11

This is the link to the API, https://kc.humanitarianresponse.info/api/v1/data/xxxx

12

Yes, that link is no longer working. You need to change link to kc-eu.kobotoolbox.org/api/v1/data/xxx

13

I have changed the API and the issue remains, although I have also noticed something unique I can associate the error with, my data is huge and since I am not on a paid subscription it might be declining the request because I have tried to refresh data from other forms under the same server even using the https//kc.humanitarianresponse.info and they were a success…

14

Hi @sector, does your data have more than 30.000 submission? If yes, usually that’s is the reason for such error.