Parse an array of json object using jq

Question

I am trying to parse the below json file and store the result into another json file. How do I achieve this ?

{
  "Objects": [
    {
      "ElementName": "Test1",
      "ElementArray": ["abc","bcd"],
      "ElementUnit": "4"
    },
    {
      "ElementName": "Test2",
      "ElementArray": ["abc","bcde"],
      "ElementUnit": "8"
    }
  ]
}

Expected result :

{
"Test1" :[
"abc","bcd"
],
"Test2" :[
"abc","bcde"
]
}

I've tried something on the lines of the below but I seem to be off -

jq '[.Objects[].ElementName ,(.Objects[]. ElementArray[])]' user1.json

jq ".Objects[].ElementName .Objects[].ElementArray" ruser1.json

pmf · Accepted Answer · 2022-03-25 11:44:57Z

1

Your expected output needs to be wrapped in curly braces in order to be a valid JSON object. That said, use from_entries to create an object from an array of key-value pairs, which can be produced by accordingly mapping the input object's Objects array.

.Objects | map({key: .ElementName, value: .ElementArray}) | from_entries

{
  "Test1": [
    "abc",
    "bcd"
  ],
  "Test2": [
    "abc",
    "bcde"
  ]
}

Demo

answered Mar 25, 2022 at 11:44

pmf

38.3k3 gold badges31 silver badges41 bronze badges

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

Comments

Logan Lee · Accepted Answer · 2022-04-04 04:35:29Z

0

Demo

https://jqplay.org/s/YbjICOd8EJ

You can also use reduce

reduce .Objects[] as $o ({}; .[$o.ElementName]=$o.ElementArray)

answered Apr 4, 2022 at 4:35

Logan Lee

1,0351 gold badge12 silver badges27 bronze badges

Collectives™ on Stack Overflow

Parse an array of json object using jq

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related