Error While Parsing Json Api Microsoft Q A

Error While Parsing Json Api Microsoft Q A Hi, until yesterday i was parsing correctly a json api. today instead i'm getting an exception thrown while debugging error in asks and error in bids . i'm not really understanding why. the json doesn't seems to be changed. the api uri is order.depth and this is the code i'm using:. In my dataset i have one column which contains json data, when i try to parse it with the transform>parse>json, it gives an unknown error. (image is attached).

Solved Error While Parsing Json Microsoft Fabric Community Microsoft.aspnetcore.http.badhttprequestexception: failed to read parameter "loginrequest login" from the request body as json. > system.text.json.jsonexception: the input does not contain any json tokens. expected the input to start with a valid json token, when isfinalblock is true. Json parse errors occur when a json parser is unable to correctly interpret a json formatted string. this could be due to a variety of reasons, such as incorrect data types, missing or extra commas, or improperly nested objects. Error while parsing json: 'unexpected character encountered while parsing value: y. path '', line 0, position 0.' on postman: you must provide a valid value for the distribution combination attribute. Microsoft.powerplatform.powerautomate.desktop.actions.sdk.actionexception: unexpected character encountered while parsing value: <. path '', line 0, position 0. at microsoft.flow.rpa.desktop.modules.variables.actions.convertjsontocustomobject.execute (actioncontext context).

Solved Error While Parsing Json Microsoft Fabric Community Error while parsing json: 'unexpected character encountered while parsing value: y. path '', line 0, position 0.' on postman: you must provide a valid value for the distribution combination attribute. Microsoft.powerplatform.powerautomate.desktop.actions.sdk.actionexception: unexpected character encountered while parsing value: <. path '', line 0, position 0. at microsoft.flow.rpa.desktop.modules.variables.actions.convertjsontocustomobject.execute (actioncontext context). However, as you mentioned, the response from the api has a content type of text plain;charset=iso 8859 1, which means it's returning plain text and not json and since your api is returning plain text, you should configure your source dataset to expect plain text instead of json. These steps might help: 1. validate json format: manually: inspect a sample of the response from the api using tools like postman or a browser. review structure: make sure it adheres to json syntax rules. you can use a json validator online or in your code. 2. address unexpected characters:. As discussed in o ther q&a thread, you need to make a post request to the endpoint in order to get json response back. if you make a get request, the endpoint might not return a json response and hence processing the response body as json will threw an error as you mentioned. I am trying to parse the api response in power query and use the response as a table in power bi. the data is paginated, and that's why i am using the list.generate function along with a custom function that calls the api.

Json Parsing Microsoft Q A However, as you mentioned, the response from the api has a content type of text plain;charset=iso 8859 1, which means it's returning plain text and not json and since your api is returning plain text, you should configure your source dataset to expect plain text instead of json. These steps might help: 1. validate json format: manually: inspect a sample of the response from the api using tools like postman or a browser. review structure: make sure it adheres to json syntax rules. you can use a json validator online or in your code. 2. address unexpected characters:. As discussed in o ther q&a thread, you need to make a post request to the endpoint in order to get json response back. if you make a get request, the endpoint might not return a json response and hence processing the response body as json will threw an error as you mentioned. I am trying to parse the api response in power query and use the response as a table in power bi. the data is paginated, and that's why i am using the list.generate function along with a custom function that calls the api.