For months, we’ve had an integration workflow running that queries Kobo project data (form submissions) and the asset (form metadata). The second now fails with 500 error.
I can still fetch data just fine with this request: GET https://kf.kobotoolbox.org/assets/{projectid}/data/?format=json
However, this request now returns a 500 error when I try to query a list of forms available in my Kobo account: GET https://kf.kobotoolbox.org/api/v2/assets/?format=json
This also fails: GET https://kf.kobotoolbox.org/api/v2/assets.json
^This was working for months before, but since April 15th I am encountering 500 Internal Server Error error with every request.
This url also used to take me to v2 api docs, but it now fails - see screenshot:
We’ve tried with another credential, and confirm this works for one credential, but not the other… GET https://kf.kobotoolbox.org/api/v2/assets.json
We’re investigating permissions to see what’s different about the 2 credentials, but if this is a credential issue - then I’m curious why the Kobo API returned a 500 error code instead of 4XX to let us know it was auth-related. Keep you posted!
HI @Kal_Lam, it looks like there is a specific issue with my Kobo account - see screenshot which shows it’s failing to list asset. This is preventing us from fetching the list of forms:
@dianedetoeuf and I are still experiencing this issue when trying to query a list of forms via the API (GET /assets). This error only appears with Diane’s account, and not others, so something is wrong with her account/credential. We see more 500 errors today @Kal_Lam - any feedback on this failed to list assets error from Diane’s screenshot? Note that this error is showing up in the frontend UI, as well as in the API response.
@dianedetoeuf, are you still having this issue? Would you kindly share with me the following details through a private message so that I can have a closer look at your case?
Username
Server
Project name
Note: You could share with me a private message as outlined in the post discussed previously:
@dianedetoeuf, thank you for bringing this issue back to our attention. Please be informed that I was able to replicate the issue on your account.
Out of curiosity, is this causing any other issues or interfering with any actions you’re trying to perform? Please let me know if you notice anything else.
@dianedetoeuf, it appears that you have quite a large number of projects in your account, possibly over 100. Could you try deleting or unlinking any projects that are no longer needed?
I believe the issue may be resolved if the total number of assets is brought down to around 100 or fewer. Please give that a try and let me know how it goes.
Thank you for finding where the issue came from, it’s good to know that there is a limit of about 100 forms. I’ll see what I can do to take some of these forms out.
Hi @Kal_Lam, I’ve removed about a hundred forms and I should now have just a bit less than a hundred, but the account is still failing to list the assets. What’s weird is that when getting the list of asset from the API (https://kc.kobotoolbox.org/api/v1/forms?format=json), some forms appear that I can’t find when looking for them in the account. I’ve tried the v2 of the API but it doesn’t work.
