JSON Parse Error

[tf05]

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

[BenoitC]

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 

[danilang]

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