Support Questions
Find answers, ask questions, and share your expertise

How to send an "InvokeHTTP" response to Oracle

Good morning everybody,


I have a stream where I execute a POST method and I have multiple returns from an API.

 

leandrolinof_2-1623670516979.png

 

This flow is executed by an "ExecuteSQL" line by line.

leandrolinof_4-1623670703934.png

 

leandrolinof_3-1623670643542.png

 

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.

 

leandrolinof_5-1623670765168.png

 

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.

 

leandrolinof_7-1623670960653.png

 

leandrolinof_6-1623670929866.png

 

Thank you so much.

1 REPLY 1

Re: How to send an "InvokeHTTP" response to Oracle