JSONL format support / current workaround

[costie]

JSONL appears to be growing in popularity (especially with AI related projects).
EasyMorph might benefit from supporting this format.
It’s basically just a collection of JSON objects (one per line).

In the meantime, I was able to use the existing JSON parser through the Iterate action and accomplish the same goal.

Leaving this sample project here in case other EasyMorphers needs to read JSONL data.

parse_JSONL.morph (24.1 KB)

[dgudkov]

You don't need iterations here. The "Parse JSON" action works on multiple lines too.

Linking my other example:

How to read JSONL (JSON Lines)

The JSONL (JSON Lines) format is becoming more popular. It's a simple format that contains one JSON object per text line. Reading it in EasyMorph is trivial, however may not be obvious: Import the file using the "Import plain text" action, select the option "Import every line as new row". Use the "Parse JSON" or the "Extract JSON properties" actions to convert the loaded JSONL to a table This method won't work if text literals inside JSON objects contain line breaks. See the exam…

[costie]

Yes can confirm on my end.
Apologies for any confusion.

I went back to the original data I was working with. I think I created the Iteration to preserve the original message (which was split across 3 rows). But can see in the “Parse JSON” Action under “Advanced Settings” there is an option “Don’t delete original column” - which does the same thing.

So no need to change EasyMorph. All good for JSONL!