Merging array of objects with the same key

Question

The problem: I have N numbers of arrays of objects with the same identifying key within objects, and I'd love to merge those with jq.

This is a contrived example that attempts to illustrate the problem:

From

[
  {
    "google.com": {
      "http": {
        "dest_url": "http://stackoverflow.com"
      }
    }
  },
  {
    "google.com": {
      "https": {
        "dest_url": "https://github.com"
      }
    }
  },
  {
    "test.com": {
      "https": {
        "dest_url": "https://wikipedia.com"
      }
    }
  }
]

To

{
  "google.com": {
    "http": {
      "dest_url": "http://stackoverflow.com"
    },
    "https": {
      "dest_url": "https://github.com"
    }
  },
  "test.com": {
    "https": {
      "dest_url": "https://wikipedia.com"
    }
  }
}

I tried with jq '. | add' file but it ended up with the following result.

{
  "google.com": {
    "https": {
      "dest_url": "https://github.com"
    }
  },
  "test.com": {
    "https": {
      "dest_url": "https://wikipedia.com"
    }
  }
}

oguz ismail · Accepted Answer · 2020-06-10 08:14:34Z

2

A shorter alternative using reduce and recursive merging by * operator:

reduce .[] as $p ({}; . * $p)

^{demo at jqplay.org}

answered Jun 10, 2020 at 8:14

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

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

Comments

Inian · Accepted Answer · 2020-06-11 10:36:12Z

1

You can use the group_by() of the keyname after doing to_entries() and form the final JSON from the grouped result

map(to_entries[])
| group_by(.key)[] 
| { (.[0].key) : map(.value)|add }

See it working on jq-play

edited Jun 11, 2020 at 10:36

answered Jun 10, 2020 at 7:42

Inian

87k15 gold badges166 silver badges183 bronze badges

Collectives™ on Stack Overflow

Merging array of objects with the same key

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