Parsing JSONL Files in Celigo
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:
-
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.
-
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;
}


1
Comments
Please sign in to leave a comment.