Reading Yelp NDJSON Files

KNIME Extensions Text Processing
#1

Hello, I'm trying to read in Yelp's JSON files that are NDJSON (Newline delimited JSON). In R I would import the jsonlite package and use: 

yelp <- stream_in(file("yelp_academic_dataset_business.json"))

KNIME's JSON Reader doesn't recognize these files as valid JSON files.

Thanks.

 

 

#2

As NDJSON is not valid JSON you cannot use the JSON Reader. However, you can use the Line Reader node followed by String to JSON.

#3

Thank you, Thor. It worked nicely.

LisaMarie