Invalid JSON error when retrieving data from published OData service

0
After publishing an OData service with multiple entities (endpoints), I'm having issues fetching data from one of the entities in Excel or Power BI. When I try to load the data in Excel, I receive the error message "Invalid JSON. More than one value was found at the root of the JSON content". See attached screenshot with the complete error message. The same error message is shown in Power BI when loading the data from the endpoint. This error is only occuring when reading data from Production, not from Acceptance. Reading data from the same endpoint on Acceptance can be done without errors, so it seems this issue is related to the data that is published via the endpoint on Production.  What could be the problem here?
asked
3 answers
2

can you retrieve your endpoint with postman? (if could be Microsoft having trouble)

 

if postman also fails, you may be sending 'illigal characters' as far as I know there is a limited list of chars you are allowed to use, and I think there is even a REGEX out there that can clean your data before sending it.

 

its probably just 1 attribute tripping up the entire json by the sounds of it

answered
1

Hello, were you able to solve this issue? We have been having the same error and cannot figure out what caused this.

answered
1

Hi Steven, in the logs, you should see an (OData Publish) error message with more details. I suspect the issue might be related to a specific enum value. If that's the case, consider exposing the enum value as a String instead of an enum.

answered