Parsing JSONL Files in Celigo

[tylerlamparter]

Ever need to work with a JSONL file but don't see JSONL listed as a file type within Celigo file provider exports? No worries—here’s a simple workaround to parse JSONL files and make them usable in your flows:

Steps to Parse JSONL Files:

1. Import JSONL as a CSV:
   • Treat the JSONL file as a CSV file by selecting the CSV (or any delimited text file) option in the file provider setup.
   • Use a custom column delimiter (e.g., celigo_dummy_delimiter) that would never exist in the file itself. This ensures each JSONL row is treated as an individual column.
2. Add a Transformation Script:
   • Create a transformation script to parse the stringified JSON in each row. Below is a sample transformation script:

function transform (options) {
options.record = JSON.parse(options.record.Column0);
return options.record;

}