Created 03-15-2023 08:15 AM
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.
Created 03-15-2023 08:36 AM
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
Created 03-15-2023 08:36 AM
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
Created 03-15-2023 08:43 AM
Thank you very much SAMSAL, I apreciate it, specially the references you provide.