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 leandrolinof_2-1623670516979.png](https://community.cloudera.com/t5/image/serverpage/image-id/31520i12DEE65A8BAEFB85/image-size/medium?v=v2&px=400)
This flow is executed by an "ExecuteSQL" line by line.
![leandrolinof_4-1623670703934.png leandrolinof_4-1623670703934.png](https://community.cloudera.com/t5/image/serverpage/image-id/31522i25141B003BF84F56/image-size/medium?v=v2&px=400)
![leandrolinof_3-1623670643542.png leandrolinof_3-1623670643542.png](https://community.cloudera.com/t5/image/serverpage/image-id/31521i25572EF18A5D86E4/image-size/medium?v=v2&px=400)
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 leandrolinof_5-1623670765168.png](https://community.cloudera.com/t5/image/serverpage/image-id/31523i918B5B0C2553B2EE/image-size/medium?v=v2&px=400)
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_7-1623670960653.png](https://community.cloudera.com/t5/image/serverpage/image-id/31525i8E2E55FE15147457/image-size/medium?v=v2&px=400)
![leandrolinof_6-1623670929866.png leandrolinof_6-1623670929866.png](https://community.cloudera.com/t5/image/serverpage/image-id/31524i80B055E6E5F248D0/image-size/medium?v=v2&px=400)
Thank you so much.