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:

  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;
}
1

Comments

0 comments

Please sign in to leave a comment.

 

Didn't find what you were looking for?

New post