Reading Yelp NDJSON Files

KNIME Extensions
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

 

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.