question Re: NiFi Jolttransform to package json array into object? in Support Questions

NiFi Jolttransform to package json array into object?

lvic4594_ — Fri, 03 May 2019 02:36:30 GMT

i have json array like the following: [{"id":"one"}, {"id,"two"}] Any idea how could i "package" it into json "root" like the following: { [{"id":"one"}, {"id,"two"}] }

I am trying to use JolttransformJSON but couldn't find any clues how to approach operation like this....

Thank you

Re: NiFi Jolttransform to package json array into object?

mburgess — Fri, 03 May 2019 03:51:00 GMT

I don't think your desired output is valid JSON, as the root object only has an array in it, not a key/value pair. If you want a key in there (let's call it root) the following spec will work in JoltTransformJSON:

[
  {
    "operation": "shift",
    "spec": {
      "*": "root.[]"
    }
  }
]

Otherwise if you just want to add braces around the array, you can use ReplaceText, replacing the entire thing with {$1}

Re: NiFi Jolttransform to package json array into object?

lvic4594_ — Fri, 03 May 2019 23:23:47 GMT

how can i transform array of maps into array of values: ["one", "two", "three"] ?