Member since
05-22-2018
3
Posts
0
Kudos Received
0
Solutions
05-30-2018
02:02 PM
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
Labels:
- Labels:
-
Apache NiFi
05-22-2018
01:01 PM
Hi Matt, it worked so far, but how do I get rid of the [ ] in the result of the EvaluateJsonPath? The generated query now looks like .... TO_DATE('01.01.3000','dd.mm.yyyy')and BOID =["M12121212"]
... View more
05-22-2018
11:33 AM
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
Labels:
- Labels:
-
Apache NiFi