JSON Error - Not reading in all data

DataBlender

Hi everyone,

I'm trying to input a json file which is a union (I think) of a number of different webpages which have been scraped. My issue is that only the first of these pages seems to be coming through and I also receive a warning message: 

Input Data (1) Error message: The document root must not follow by other values. at character position: 143856

I have a csv file which contains the same data and I can see that this has all of the pages. The reason I'm using the json file rather than the csv is so that I can keep the column headers from each page.

Separately, this has all come about because I was unable to correctly parse the page directly through Alteryx. This is also included in the sample workbook in case anybody would like to look at that as well!

Thanks

DB

JSON Test.yxzp

KaneG

Hi @DataBlender,

Your JSON file is indeed a whole lot of JSON files unioned, but that is easy enough to deal with. Bring it in and configure the input tool as CSV with no delimiter:

Then add a recordID and put it through the JSON Parse tool. Note that your schema changes after record 406 and so you might want to split on that before cross-tabbing your results.

Kane