The below input and script is working in http://jolt-demo.appspot.com/#andrewkcarter2 , But it is not working in Nifi JolttransformationJson .
This example is concatenation of firstname and lastname . I understood it is becuase of not having "Operation : modify-overwrite-beta" in existing Nifi - JoltTransformation plugin .
Is it possible to get this function by custom ? If yes, Please provide the process to implement .
or let us know the process to ultilize it . Thanks . @Yolanda M. Davis - Please through some light on this .Thanks . Input :
{
"data": [{
"IDF": "123",
"FirstName": "George",
"LastName": "Kosher",
"PaymentInfo": [{
"Type": "ABC",
"Text": "Soft",
"Amount": 3
}, {
"Type": "ABC",
"Text": "Text",
"Amount": 5
}],
"PaymentCard": [{
"CardNumber": "12345",
"CardType": "Credit"
}, {
"CardNumber": "56789",
"CardType": "Credit"
}]
}, {
"IDF": "456",
"FirstName": "Mill",
"LastName": "King",
"PaymentInfo": [{
"Type": "ABC",
"InstructionText": "Hard",
"Amount": 6
}, {
"Type": "ABC",
"InstructionText": "Text",
"Amount": 8
}],
"PaymentCard": [{
"CardNumber": "12345",
"CardType": "Credit"
}, {
"CardNumber": "56789",
"CardType": "Credit"
}]
}]
}
Script :
[
{
"operation": "shift",
"spec": {
"data": {
"*": { // data arrayf
"*": "data[&1].&", // pass thru stuff
"PaymentInfo": {
"*": {
"Amount": "data[&3].Amount[]",
"Text": "data[&3].PaymentText[]",
"InstructionText": "data[&3].PaymentText[]"
}
},
"PaymentCard": {
"0": {
"CardType": "data[&3].CardType"
}
}
}
}
}
},
{
"operation": "modify-overwrite-beta",
"spec": {
"data": {
"*": { // data array
"Name": "=concat(@(1,FirstName),' ',@(1,LastName))",
"Amount": "=sum" // should work on Jolt 0.0.24
}
}
}
},
{
"operation": "remove",
"spec": {
"data": {
"*": { // data array
"FirstName": "",
"LastName": ""
}
}
}
}
]
Output :
{
"data" : [ {
"IDF" : "123",
"Amount" : [ 3, 5 ],
"PaymentText" : [ "Soft", "Text" ],
"CardType" : "Credit",
"Name" : "George Kosher"
}, {
"IDF" : "456",
"Amount" : [ 6, 8 ],
"PaymentText" : [ "Hard", "Text" ],
"CardType" : "Credit",
"Name" : "Mill King"
} ]
}
... View more
