Loading of sharepointlist not working after filling by RestAPI

Copper Contributor

Hello everyone,

We currently have the problem in several Sharepoint lists that when they are opened, the lists display an error message ("A problem has occurred: Expected property name or '}' in JSON at position 329 (line 1 column 330)") and no data is displayed in the list. The error code is always the same as here, but with different positions/ property names.

Only after refreshing the list several times is the data finally displayed. Meanwhile, other users in the list can already see the results.

The upstream process is that the data is entered into the list via the Rest API of Sharepoint using Python.

Is this error already known?

1 Reply

You're getting a "JSON error" in your SharePoint lists due to incorrectly formatted JSON data from your Python code. To fix:

1. Verify your Python code follows SharePoint REST API specifications.
2. Test with different data types to see if specific types cause the error.
3. Clear your browser cache.
4. Use Fiddler to analyze the JSON data and identify inconsistencies.
5. Report the issue to Microsoft if you can't fix it yourself.