How concatenate multiple json objects with a delimiter comma using jq

Question

Here is my data:

{
  "ReferringUrl": "N",
  "OpenAccess": "0",
  "ItmId": "1694738780"
}
{
  "ReferringUrl": "L",
  "OpenAccess": "1",
  "ItmId": "1347809133"
}

I want it to be like this:

[
 {
  "ReferringUrl": "N",
  "OpenAccess": "0",
  "ItmId": "1694738780"
 },
 {
   "ReferringUrl": "L",
   "OpenAccess": "1",
   "ItmId": "1347809133"
 }
]

How to make it by using jq library? I use bash. Thank you! :)

Possible duplicate of Add json array element with jq (cmdline) — Norbert
– Norbert, Commented Jun 28, 2017 at 20:49
You should make some effort to solve this yourself, and include those attempts in your question, including what went wrong with them. — miken32
– miken32, Commented Jun 28, 2017 at 23:45
Possible duplicate of How to convert a JSON object stream into an array with jq — Jeff Mercado
– Jeff Mercado, Commented Jun 29, 2017 at 16:51

ggorlen · Accepted Answer · 2022-09-29 18:13:50Z

27

Assuming the sequence of JSON objects is in a file named input.json, simply "slurp" it:

jq -s . input.json

If the objects are spread over multiple files, say input*.json, you can run: jq -s . input*.json.

Handling invalid JSON

If the "objects" are as originally shown (i.e., not strictly valid as JSON), then you could use a command-line tool such as any-json, json5, or hjson to convert them to JSON, one at a time. If there is more than one quasi-JSON object per file, then you might be able to use csplit or awk to split up the file.

Alternatively, if the objects follow the pattern established in the example, you could use GNU sed: sed -z 's/,\(\n}\)/\1/g'.

edited Sep 29, 2022 at 18:13

ggorlen

59.3k8 gold badges119 silver badges173 bronze badges

answered Jun 28, 2017 at 21:56

peak

119k21 gold badges185 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chepner Over a year ago

Unfortunately, the OP appears to have invalid JSON objects in the input stream (trailing commas after the ItmId keys).

Collectives™ on Stack Overflow

How concatenate multiple json objects with a delimiter comma using jq

1 Answer 1

Handling invalid JSON

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Handling invalid JSON

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related