JSON Lines / NDJSON Help

Description

JSON Lines (also known as NDJSON — Newline Delimited JSON) is a text format where each line is a self-contained, valid JSON value, typically a JSON object. It is widely used for streaming data, log files, and large data exports because files can be read and written one record at a time without loading the entire document into memory. Common file extensions are .jsonl and .ndjson.

Upload Settings for JSON Lines

Click on Upload Settings button to start configuring the import settings for your JSON Lines file.

JSON Lines (NDJSON) files contain one valid JSON value per line, typically one JSON object per record. Use the tree below to tell the system how to read your data.

RECORD

Use this option to tell the system where each row of data starts. For a typical JSON Lines file, turn this on for the top-level object on each line.

FIELD

Use this option to tell the system which pieces of information to include in your results. Turn this on for any value you want to appear as a column. For example, IDs, names, or balances.

Example

Take the below JSON Lines / NDJSON data as an example (one JSON object per line):

{"Id":"1","AccountNo":"101","LastName":"Reeves","FirstName":"Keanu","Balance":"12","CreditLimit":"1000.23","AccountCreated":"17/01/1998","Rating":"A"}
{"Id":"2","AccountNo":"102","LastName":"Butler","FirstName":"Gerard","Balance":"123456","CreditLimit":"1234567891","AccountCreated":"06/08/2003","Rating":"B"}
{"Id":"3","AccountNo":"103","LastName":"Hewitt","FirstName":"Jennifer","Balance":"4294967295","CreditLimit":"9876543211","AccountCreated":"25/05/1985","Rating":"B"}
            

The RECORD switch would be ON for the top-level object (each line is one record).

The FIELD switches would be ON for Id, AccountNo, LastName, and other properties you want as columns.

Once you have configured the settings, click Save Changes to apply them.