How to merge 2 JSON objects from 2 files using jq?

by

Since 1.4 this is now possible with the * operator. When given two objects, it will merge them recursively. For example,

jq -s '.[0] * .[1]' file1 file2

Important: Note the -s (--slurp) flag, which puts files in the same array.

Would get you:

{
  "value1": 200,
  "timestamp": 1382461861,
  "value": {
    "aaa": {
      "value1": "v1",
      "value2": "v2",
      "value3": "v3",
      "value4": 4
    },
    "bbb": {
      "value1": "v1",
      "value2": "v2",
      "value3": "v3"
    },
    "ccc": {
      "value1": "v1",
      "value2": "v2"
    },
    "ddd": {
      "value3": "v3",
      "value4": 4
    }
  },
  "status": 200
}

If you also want to get rid of the other keys (like your expected result), one way to do it is this:

jq -s '.[0] * .[1] | {value: .value}' file1 file2

Or the presumably somewhat more efficient (because it doesn’t merge any other values):

jq -s '.[0].value * .[1].value | {value: .}' file1 file2

More Related Contents:

  1. Modify a key-value in a json using jq in-place
  2. Exporting JSON to environment variables
  3. How to get key names from JSON using jq
  4. How can I pretty-print JSON in a shell script?
  5. Passing bash variable to jq
  6. How to convert arbitrary simple JSON to CSV using jq?
  7. Select objects based on value of variable in object using jq
  8. jq not working on tag name with dashes and numbers
  9. Iterating through JSON array in Shell script
  10. passing arguments to jq filter
  11. how to parse a JSON String with jq (or other alternatives)?
  12. Read JSON data in a shell script [duplicate]
  13. How to convert a JSON object to key=value format in jq?
  14. Using jq how can I split a very large JSON file into multiple files, each a specific quantity of objects?
  15. jq: Object cannot be csv-formatted, only array
  16. jq: print key and value for each entry in an object
  17. How to format a JSON string as a table using jq?
  18. Get outputs from jq on a single line
  19. How do I update a single value in a json document using jq?
  20. How to convert a JSON object stream into an array with jq
  21. Convert a JSON array to a bash array of strings
  22. How to use jq when the variable has reserved characters?
  23. How to filter array of objects by element property values using jq?
  24. Reusable function to group_by but return an object with group as key
  25. Parse JSON to array in a shell script
  26. Split a JSON file into separate files
  27. Create JSON using jq from pipe-separated keys and values in bash
  28. Constructing a JSON object from a bash associative array
  29. In Excel VBA on Windows, for parsed JSON variables what is this JScriptTypeInfo anyway?
  30. Can Server Sent Events (SSE) with EventSource pass parameter by POST

Leave a Comment