JSON Parse Error

Question

I have an API call set up which appears to be extracting data through the Download, however when I try and JSON Parse the Downloaded Data, I get the below error. I can see the data in the DownloadedData field before it reaches the JSON Parse but only one line is then Parse.

ConvError: JSON Parse (5): Error message: The document root must not be followed by other values. at character position: 222

I am going to struggle to provide a workflow as the data cannot be shared, however this is the Download and JSON configuration.

Any general suggestions much appreciated.

Thank you

danilang · Answer

Hi @tf05

A few things to look at

-Do you have any errors in the DownloadHeaders field?

-Is the API returning the json with extra characters added at the end?

-Is the API returning multiple json records not properly nested in an array?

-Is the API returning badly formatted JSON? This is the most likely one

Dan

BenoitC · Answer

Hello

after searching on this issue, seems like the problem is related to parsing your json data before using the JSON tool. Check the below link to further detail:

Solved: JSON Question - Designer - Alteryx Community