Starting with NiFi JOLT Transformations: create a list with a JSON inside

Question

I'm stating with Jolt Transformation Processor in NiFi and I so far to understand the Jolt logic.

I want to apply a simple transformation to insert a provided JSON into a list.

provided JSON:

{
Label1:Value1,
Label2:Value2
}

expected result:

{

GeneralLabel:[

{
Label1:Value1,
Label2:Value2
}

]

}

Any clue about how to do it? In working with shift operation but without results.

SAMSAL · Accepted Answer

Hi,

First of all make sure that the provided json is in valid format . What you provided in your example doesnt have double quotes surrounding the key\value as in

{
"Label1": "Value1",
"Label2": "Value2"
}

Assuming thejson is valid , you can use the following jolt spec to produce expected output:

[
  {
    "operation": "shift",
    "spec": {
      "*": "GeneralLabel[#].&"
    }
  }
]

To learn more about jolt transformation please refer to :

https://jolt-demo.appspot.com/#inception

https://intercom.help/godigibee/en/articles/4044359-transformer-getting-to-know-jolt

If that helps please accept solution.

Thanks

rchaos · Answer

Thank you very much SAMSAL, I apreciate it, specially the references you provide.

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.