Use jq to convert json array to jsonl format

Question

I have json like this:

[ {"one": 1}, {"two": 2}]

and wish to convert it to this format:

{"one": 1}
{"two": 2}

to facilitate indexing it into ElasticSearch. (latter is called 'jsonl' format). JQ is my tool of preference but I can't figure out how to do this. Thanks

score 29 · Answer 1 · answered Feb 09 '18 at 17:58

29

The key is the -c command-line option, which produces JSONL:

jq -c '.[]' test_array.json

answered Feb 09 '18 at 17:58

peak

105,803
17
152
177

score -3 · Answer 2 · answered Feb 09 '18 at 17:34

-3

figured this out:

cat test_array.json |jq '.[]'

answered Feb 09 '18 at 17:34

David

485
1
5
16

Use jq to convert json array to jsonl format

2 Answers2

Linked