Transform nested array to top level array JOLT

Question

Is it possible to transform a input JSON

{
    "root": {   
        "lang" : "fr-FR",
        "ttp" : "ttp1",
        "net" : "wifi",
        "gps" : [
            {"gpslon" : "1", "gpslat" : "4"},
            {"gpslon" : "2", "gpslat" : "5"},
            {"gpslon" : "3", "gpslat" : "6"}
        ]
    }
}

to another JSON file using JOLT transformation?

{
  [
    {
     "lang" : "fr-FR",
     "ttp" : "ttp1",
     "net" : "wifi",
     "gpslon" : "1", 
     "gpslat" : "4"
    },
    {
     "lang" : "fr-FR",
     "ttp" : "ttp1",
     "net" : "wifi",
     "gpslon" : "2", 
     "gpslat" : "5"
    },
    {
     "lang" : "fr-FR",
     "ttp" : "ttp1",
     "net" : "wifi",
     "gpslon" : "3", 
     "gpslat" : "6"
    }
  ]
}

In other words i would like to copy "header" data (lang, ttp, net) to each array item gps.

Geckelberryfinn · Accepted Answer · 2018-03-06 15:07:14Z

2

Ok, i have found solution, may be not very efficient

[
  {
    "operation": "shift",
    "spec": {
      "root": {
        "gps": {
          "*": {
            "@": "[&1]",
            "@(2,lang)": "[&1].lang",
            "@(2,ttp)": "[&1].ttp",
            "@(2,net)": "[&1].net"
          }
        }
      }
    }
  }
]

answered Mar 6, 2018 at 15:07

Geckelberryfinn

314 bronze badges

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

1 Comment

Milo S Over a year ago

That is exactly how to do it.

Collectives™ on Stack Overflow

Transform nested array to top level array JOLT

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related