Hi, I do need an advice if I'm on the right path or not. I need to do the following: Receive Data from DB 1 Take an attribute from that result for the where clause of step 3 Fetch detail data from DB 2 Merging Result from Step 1 and Step 3 into a new JSON Record Structure In NIFI I've tried something like this: Step 1, 2 and 3 do work as expected. But Merging gives me a headache. Am I on the right way or is there a better way to do this. Cheers Eric ... View more

Hi, I do want to use the result of an AvroToJSON as Part of a where clause in ExecuteSQL. I do get a result from Avro2JSON: [ { "PKEY" : "20222160749", "BOID" : "20082919283", "TITLE" : "Rechnung eingehend", "ITSPARTNER" : "M11538622", "ITSKOMMPARTNER" : "M11538622", "JOURBOREPRESENT" : ", , ,", "SACHVERHALT" : null, "BEMERKUNG" : null } ] The JSON PATH Expression $..ITSPARTNER extracts the correct value. I've tried to do something like this in the Query of ExecuteSQL: Select * from syr_src_adm.partner where STATEEND = TO_DATE('01.01.3000', 'dd.mm.yyyy') and REPLACED = TO_DATE('01.01.3000', 'dd.mm.yyyy') and BOID = '$[*]..ITSPARTNER' But this seams not to work. Is the Syntax correct? ... View more