Skip to main content
lvic4594_
lvic4594_
Gold ⭐️
May 3, 2019
Solved

NiFi Jolttransform to package json array into object?

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

mburgess
mburgessAnswer
Gold ⭐️⭐️⭐️
May 3, 2019

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}

View in thread

2 replies

mburgess
Gold ⭐️⭐️⭐️
mburgessAnswer
Gold ⭐️⭐️⭐️
May 3, 2019

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}

Translate
    lvic4594_
    lvic4594_Author
    Gold ⭐️
    May 3, 2019

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

    Translate
    Terms & ConditionsAccessibility statement