Keep getting "Unexpected end of input reached while processing a JSON string" on SP List Refresh

[StuartSmith]

I am working with multiple SharePoint Lists to import data, but on one perticular list, I keep geting the below error when refreshing the data...

An error occurred in the ‘Table: Admin Check Log’ query. DataSource.Error: We couldn't parse OData response result. Error: Invalid JSON. Unexpected end of input reached while processing a JSON string value.
Details:
DataSourceKind=SharePoint
DataSourcePath=https://**********.sharepoint.com/sites/206913
DataSourceKind.2=SharePoint
DataSourcePath.2=https://***********.sharepoint.com/sites/206913/_api/Web/Lists(guid'******************************')/Items

I dont and have nver had this with any other SP List, so unsure why this list keeps on doing it.

Thanks in advance.

[StuartSmith]

Thanks both, I will try your suggestions and get back to you.

[Anonymous]

Hi @StuartSmith 

Has your problem been resolved? If so, could you share your solution so that others with similar issues can benefit from it?




Best Regards,

Jayleny

[Anonymous]

Hi @StuartSmith 

Sometimes, a specific record in the list has invalid characters or null values that break the JSON response. Check if the list has any unusual entries, attachments, or very large text fields.

You can load the list in Power Query, apply row filters (e.g., load only the first 10 rows or data within a specified time range), and gradually expand fields to see if a specific row or column is causing the error.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Expiscornovus]

Hi @StuartSmith,

How much items does that list have? Can you also share a bit more about this list, does it have any specific setup (columns, enabled features, etc.)?

If you don't know exactly you also retrieve the item count via the below request:

https://{site_url}/_api/web/lists('{list_guid}')/ItemCount

Have you tried adding a $top parameter to see if it is working with that?

https://{site_url}/_api/web/lists('{list_guid}')/items?$top=10