Add new element to existing JSON array with jq

by

The |= .+ part in the filter adds a new element to the existing array. You can use jq with filter like:

jq '.data.messages[3] |= . + {"date": "2010-01-07T19:55:99.999Z", "xml": "xml_samplesheet_2017_01_07_run_09.xml", "status": "OKKK", "message": "metadata loaded into iRODS successfullyyyyy"}' inputJson

To avoid using the hardcoded length value 3 and dynamically add a new element, use . | length which returns the length, which can be used as the next array index, i.e.,

jq '.data.messages[.data.messages| length] |= . + {"date": "2010-01-07T19:55:99.999Z", "xml": "xml_samplesheet_2017_01_07_run_09.xml", "status": "OKKK", "message": "metadata loaded into iRODS successfullyyyyy"}' inputJson

(or) as per peak’s suggestion in the comments, using the += operator alone

jq '.data.messages += [{"date": "2010-01-07T19:55:99.999Z", "xml": "xml_samplesheet_2017_01_07_run_09.xml", "status": "OKKK", "message": "metadata loaded into iRODS successfullyyyyy"}]'

which produces the output you need:

{
  "report": "1.0",
  "data": {
    "date": "2010-01-07",
    "messages": [
      {
        "date": "2010-01-07T19:58:42.949Z",
        "xml": "xml_samplesheet_2017_01_07_run_09.xml",
        "status": "OK",
        "message": "metadata loaded into iRODS successfully"
      },
      {
        "date": "2010-01-07T20:22:46.949Z",
        "xml": "xml_samplesheet_2017_01_07_run_09.xml",
        "status": "NOK",
        "message": "metadata duplicated into iRODS"
      },
      {
        "date": "2010-01-07T22:11:55.949Z",
        "xml": "xml_samplesheet_2017_01_07_run_09.xml",
        "status": "NOK",
        "message": "metadata was not validated by XSD schema"
      },
      {
        "date": "2010-01-07T19:55:99.999Z",
        "xml": "xml_samplesheet_2017_01_07_run_09.xml",
        "status": "OKKK",
        "message": "metadata loaded into iRODS successfullyyyyy"
      }
    ]
  }
}

Use jq-play to dry-run your jq-filter and optimize any way you want.

More Related Contents:

  1. Accessing a JSON object in Bash – associative array / list / another model
  2. How to check if element exists in array with jq
  3. How to filter an array of objects based on values in an inner array with jq?
  4. Assigning an Array Parsed With jq to Bash Script Array
  5. jq: recursively merge objects and concatenate arrays
  6. Loop through an array of strings in Bash?
  7. Check if a Bash array contains a value
  8. Creating an array from a text file in Bash
  9. How can I store the “find” command results as an array in Bash
  10. How can I join elements of an array in Bash?
  11. Capturing output of find . -print0 into a bash array
  12. How to return an array in bash without using globals?
  13. Iterating through JSON array in Shell script
  14. passing arguments to jq filter
  15. Print array elements on separate lines in Bash?
  16. How to convert a JSON object to key=value format in jq?
  17. Reading a space-delimited string into an array in Bash
  18. Bash indirect array addressing?
  19. Convert command line arguments into an array in Bash
  20. Using jsonb_set() for updating specific jsonb array value
  21. Swift 4 JSON Decodable with multidimensional and multitype array
  22. How to pass an array argument to the Bash script
  23. How to merge two arrays in a zipper like fashion in Bash?
  24. Exporting JSON to environment variables
  25. Convert a JSON array to a bash array of strings
  26. Swift 4 JSON Codable – value returned is sometimes an object, others an array
  27. Check if an element is present in a Bash array [duplicate]
  28. Create JSON using jq from pipe-separated keys and values in bash
  29. Constructing a JSON object from a bash associative array
  30. How to copy an array in Bash?

Leave a Comment