Convert Single JSON Object within JSON document to an Array with jq

Question

Tryin to use jq to make a slight transformation in a JSON document I am working with.

I am using this as sample input JSON:

{"root" : {"to" : {"email" : "[email protected]"}, "dynamic_template_data" : {"FIRSTNAME" : "BLANCA", "last_4" : "9999", "OFFERCODE" : "88888888888888888"}}}
{"root" : {"to" : {"email" : "[email protected]"}, "dynamic_template_data" : {"FIRSTNAME" : "Michael", "last_4" : "8888", "OFFERCODE" : "9999999999999999999999"}}}

At the moment, I am using this jq filter to try to transform the JSON (also specifying slurp option):

jq --slurp '{"template_id":"d-34d9948687504d1f91fa9ddb738e94c0","asm":{"group_id":14817},"categories":["PROD","ICAP"],"personalizations": [.[].root],"from" : {"email" : "[email protected]", "name" : "Bank of the World"}, "reply_to" : {"email" : "[email protected]", "name" : "Bank of the World"}}'

...which returns close to what I need below with the "to" element to be an array containing the email address:

{
  "template_id": "d-34d9948687504d1f91fa9ddb738e94c0",
  "asm": {
    "group_id": 14817
  },
  "categories": [
    "PROD",
    "ICAP"
  ],
  "personalizations": [
    {
      "to": {
        "email": "[email protected]"
      },
      "dynamic_template_data": {
        "FIRSTNAME": "BLANCA",
        "last_4": "9999",
        "OFFERCODE": "88888888888888888"
      }
    },
    {
      "to": {
        "email": "[email protected]"
      },
      "dynamic_template_data": {
        "FIRSTNAME": "Michael",
        "last_4": "8888",
        "OFFERCODE": "9999999999999999999999"
      }
    }
  ],
  "from": {
    "email": "[email protected]",
    "name": "Bank of the World"
  },
  "reply_to": {
    "email": "[email protected]",
    "name": "Bank of the World"
  }
}

...but the email address is not returning in an array as I need.

Desired output:

{
"template_id": "d-34d9948687504d1f91fa9ddb738e94c0",
"asm": {"group_id": 14817},
"categories": [
    "PROD",
    "ICAP"
],
"personalizations": [
    {
        "to": [
            {"email": "[email protected]"}
        ],
        "dynamic_template_data": {
            "FIRSTNAME": "BLANCA",
            "last_4": "9999",
            "OFFERCODE": "88888888888888888"
        }
    },
    {
        "to": [
            {"email": "[email protected]"}
        ],
        "dynamic_template_data": {
            "FIRSTNAME": "Michael",
            "last_4": "8888",
            "OFFERCODE": "9999999999999999999999"
        }
    }
],
"from": {
    "email": "[email protected]",
    "name": "Bank of the World"
},
"reply_to": {
    "email": "[email protected]",
    "name": "Bank of the World"
}
}

Your desired output is invalid json. You can check it here jsonformatter.curiousconcept.com — lojza
– lojza, Commented Apr 27, 2021 at 20:17

lojza · Accepted Answer · 2021-04-27 20:31:24Z

1

Replace .to with [.to]

jq --slurp '{"personalizations": [.[].root | .to = [.to]]}'

answered Apr 27, 2021 at 20:31

lojza

1,9412 gold badges13 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Convert Single JSON Object within JSON document to an Array with jq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related