Merge 2 jsons discarding the difference in specific key value

[rjshrjndrn]

Hi,
I have a weird mere issue. I want to merge 2 json's equal objects disregarding the ID key

{
################ Rule A ################
  "Rules": [
    {
      "Expiration": {
        "Days": "180"
      },
       ######### Discarding this key ################
      "ID": "chact06u6ntc5uagbv30",
      "Filter": {
        "And": {
          "Tags": [
            {
              "Key": "to_delete_in_days",
              "Value": "180"
            }
          ]
        }
      },
      "Status": "Enabled"
    }
  ]
}

{
################ Rule B ################
  "Rules": [
    {
      "Expiration": {
        "ExpiredObjectDeleteMarker": true
      },
      "ID": "chacfnmu6ntc6vi39hg0",
      "Status": "Enabled"
    }
  ], [
    {
      "Expiration": {
        "Days": 180
      },
       ######### Discarding this key ################
      "ID": "custom rule 1",
      "Filter": {
        "And": {
          "Tags": [
            {
              "Key": "to_delete_in_days",
              "Value": "180"
            }
          ]
        }
      },
      "Status": "Enabled"
    }
  ]
}

[emanuele6]

It's hard to understand your question because it is not very clear what exactly you want to do. Do the JSON objects come from different files? From another JSON object? Do you want to remove both duplicates or keep one? Do you prefer keeping the id from the first object over the second object, or viceversa, or does it not matter?

Also because your example is not valid JSON (], [), and in one object the expiration days are a "180" string and in the other a 180 numbers, etc.

Anyway, comparing objects ignoring the value of ID is pretty straight forward, you can use a combination of the del/1 function and the unique_by/1 function to do this.

For example, if you have multiple files containing those objects with just a Rules entry and nothing else, and you want to output, a single object with a Rules entry that contains the union of all the Rules, and you don't care about the order of the rules in the output, and if there are duplicates ignoring ID you want to keep only one duplicate (not preferring the ID from a file over another), you would just use:

jq -s 'map(.Rules[]) | { Rules: unique_by(del(.ID)) }' -- file1.json file2.json file3.json

If that does not match your use case, feel free to provide more details.