question Starting with NiFi JOLT Transformations: create a list with a JSON inside in Support Questions

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

rchaos — Wed, 15 Mar 2023 15:15:21 GMT

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.

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

SAMSAL — Wed, 15 Mar 2023 15:36:39 GMT

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

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

rchaos — Wed, 15 Mar 2023 15:43:51 GMT

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