Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rest API: how could apex use an external rest api to POST data into a 3rd party solution?

Efarah-OracleJan 10 2018 — edited Jan 11 2018

Hi gurus,

first of all, happy new year to you all.

Need some advice on how to proceed in this situation with APEX.

I work with a commercial application that delivers a very comprehensive REST APIs catalog. The catalog has multiple services with different methods (get/post/patch, etc...)

I created then an apex application (on our private cloud - APEX 5,01 ) which consumes some REST from that commercial application (which is occasionally hosted on the same environment). the GET method is working properly and sweet. Everything I need from GETTING the data from our commercial APP is working fine. I check the data from the APP and it matches exactly with the data into my APEX app, as expected.

Having said that, now I'm trying to get some data FROM my APEX app and POST that data into my commercial application.

I followed the same process to create the web services:

-> Application 105 -> Shared Components -> Web Service References

and then CREATED my reference to a POST method.

when I execute my APEX application, it returns the following error on DEBUG

| 0.01492 | 4.02957 |

...Process "Web Service Request" - Type: NATIVE_WEB_SERVICE

| 4 |

99%

|
| 4.04448 | 0.00033 |

Response: {"result":"SUCCESSFUL","message":{"detail":"System cannot process the request, please try again later.","code":"SYS_CO_0003"}}

| 4 |

0%

|
| 4.04481 | 0.00100 |

l_parm_delim:

|

apparently the JSON is correctly created (since im testing it through POSTMAN and it works fine and since it reaches the server and return SUCESSFUL..

my guess is that the HEADER is not correct when I configured it on APEX.

in the HTTP header, i added Content-Type: application/json but i didn't find if that's the proper format.

pastedImage_0.png

most blogs and docs I found, always mention a POST to INSERT into an APEX application but i didn't find anyone that consumes a REST to POST a transaction outside of APEX.

does anyone have any clue? any documentation I could look through? any suggestion on where to start?

thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2018
Added on Jan 10 2018
5 comments
6,002 views