@puneetn HI, I'm having the same scenario. I wonder, have you ever come up with a solution?   Thanks, Rosa ... View more

@Justen Thanks! ... View more

@ Justen i believe this is the answer: Thanks! ... View more

@ Justen my JSON file is being converted to null (file size iz 4bytes) after wrong JOLT is applied. So, when I open the JSON it's litterally 'null'. There are no brackets.. just null. ... View more

@ Justen use EvaluateJsonPath to extract the record into an attribute, apply the changes and push it back in with update record processor ... View more

@ Justen as far as the schemas go, try using SimpleKeyLookupService controller service, create two new properties that will point to AvroSchemaRegistry controller service. That way you will call for ${schema.name} attribute in your processors instead of hardcoding the schemas into the processor directly. ... View more

@ Justen try using evalate json path... https://jsonpath.com/ ... View more

you could first read that line from the json file (evaluate json path) and then update attribute with expression language and push it back into the json file with update record processor. let me know if you need further help. ... View more

@Matt Burgess do you mind helping me out with a similar issue? I have a json file comming in as : [ {   "regId" : "us",   "cId" : "SomeProduct",   "weId" : 15,   "name" : "R",   "id" : 1539,   "cityId" : 17,   "cityName" : "Moskow" }, {   "regId" : "us",   "cId" : "SomeProduct",   "weId" : 15,   "name" : "R",   "id" : 1540,   "cityId" : 18,   "cityName" : "Berlin" }, {   "regId" : "us",   "cId" : "SomeProduct",   "weId" : 15,   "name" : "R",   "id" : 1541,   "cityId" : 19,   "cityName" : "Vienna" } ] I need to add 3 new fields passed from the FlowFile attribute into each element? Can I do that with the update Record also? [ {   "new_att":"somevalue",   "new_att2":"somevalue2",   "new_att3":"somevalue3",   "regId" : "us",   "cId" : "SomeProduct",   "weId" : 15,   "name" : "R",   "id" : 1539,   "cityId" : 17,   "cityName" : "Moskow" }, {   "new_att":"somevalue",   "new_att2":"somevalue2",   "new_att3":"somevalue3",   "regId" : "us",   "cId" : "SomeProduct",   "weId" : 15,   "name" : "R",   "id" : 1540,   "cityId" : 18,   "cityName" : "Berlin" }, {   "new_att":"somevalue",   "new_att2":"somevalue2",   "new_att3":"somevalue3",   "regId" : "us",   "cId" : "SomeProduct",   "weId" : 15,   "name" : "R",   "id" : 1541,   "cityId" : 19,   "cityName" : "Vienna" } ] Thanks, Rosa ... View more