About leandrolinof

leandrolinof · ‎06-14-2021

Good morning everybody, I have a stream where I execute a POST method and I have multiple returns from an API. This flow is executed by an "ExecuteSQL" line by line. I would like to know how to send these returns to Oracle. In some moments the API will return errors in my submission and I need to save them in Oracle too, to later handle these errors. I also need to save the JSON sent to the API and this happens via another stream of the Original from "invokeHTTP". I'm already handling these flows through "EvaluateJSONPath", "ExtractText" and "SplitJSON", but I don't know how to send them to Oracle. Note that I need to group all these streams into just one stream and only one stream at a time to send to Oracle, because I need to pass parameters in the routine that will be sending to Oracle. If anyone knows how to help me I appreciate it. Thank you so much.

leandrolinof · ‎05-21-2021

@MattWho, Good afternoon. I changed my flow to make a counter by the processor "RouteOnAttribute 1.12.1" so every time I have a record to be sent to the API and have a return to store in Oracle, I do the LOOP through RouteOnAttribut. Thus sending one FlowFile at a time to the PROCEDURE call in Oracle by "ExecuteSQL 1.12.1" But what is happening at the moment is that from the second time it goes through the LOOP, it seems to me that the Flow to get the attributes "CODIGO" and "JSON_ORIGINAL" is not passing the values that I requested in the processor "EvaluateJsonPath 1.12.1" passing the parameters as null. Do you have any idea what may be happening in this second flow passage within the LOOP? This is the JSON ORIGINAL of the second stream that I must send to Oracle = This is OK with the CODE attribute as you can check. This is Split Configure Processor = This is EvaluateJsonPath 1.12.1 Configure Processor = This is MergeContent 1.12.1 Configure Processor = This is ExecuteSQL 1.12.1 Configure Processor =

leandrolinof · ‎05-18-2021

Good afternoon, I am using the "RouteOnAttribute" processor to do a loop validating a condition that is as follows = ${cont:lt(${CONTADOR})} But I am not able to make the processor understand the property "CONTADOR" Could you help me please?

leandrolinof · ‎05-17-2021

@MattWho I was able to use the following structure in the flow = Thanks a lot for the help. 😃

leandrolinof · ‎05-17-2021

Sorry the correct property for this case is $ {CONTADOR: equals ('N')}

leandrolinof · ‎05-17-2021

@MattWho I'm trying a different approach using "RouteOnAttribute" with the condition $ {CODE: contains ("N")} after "ConvertAvroToJSON" I thought about putting this condition before all my flow. So already valid if there is a record to be sent by Oracle. But it is not working, a result of the always "unmatched" Even Oracle sending me "N". Could you tell me if this condition I put in is correct?

leandrolinof · ‎05-17-2021

@mburgess can You help me?

leandrolinof · ‎05-14-2021

Good afternoon everyone, I have a problem with my flow in the processor "JoltTransformJSON" when I run the processor "ExecuteSQL" and no Oracle record returns to me. I would like your help to know what to do in this case. Thank you so much.

leandrolinof · ‎05-12-2021

@MattWho @pvillard @mattw Please can you help me?

leandrolinof · ‎05-10-2021

Good morning all, Can someone help me?

Online	Offline
Last Visited	‎10-29-2022 02:50 PM

Member Since	‎05-06-2021 03:37 AM
Last Visited	‎10-29-2022 02:50 PM
Posts	37
Kudos received	1

Cloudera Community

Re: Error Routing to Failure

How to send an "InvokeHTTP" response to Oracle

Re: How to Merge Multiple Flow Files - "ExecuteSQL...

RouteOnAttribute - How to capture property in cond...

Re: Error Routing to Failure

Re: Error Routing to Failure

Re: Error Routing to Failure

Re: How to Merge Multiple Flow Files - "ExecuteSQL...

Error Routing to Failure

Re: How to Merge Multiple Flow Files - "ExecuteSQL...

Re: How to Merge Multiple Flow Files - "ExecuteSQL...