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!

Using Apex REST-Data Sources to call AWS Rest-API Gateway & Lambda function

Jegor WielerNov 15 2022

Hello everyone,
I need help with Oracle Apex "REST-Data Source.
I want to use Oracle Apex "REST-Data Source" to access a Rest API from Amazon Web Service (AWS). For this purpose, I have created a REST API and a Lambda function in AWS.
When I call the URL of the REST API in the browser, I get the data output as desired.
Now Oracle Apex provides a "REST-Data Source".

REST-Data Source.PNG When I create a "REST-Data Source" (as shown in figure), I get the following error message: "ORA-12545: Connect failed because target host or object does not exist". The link in URL-Endpoint is the same as the Invoke URL from AWS API Gateway.
I don't really understand the error massage, because if I open the URL in browser tab, everthing works fine and the data will be displayed.
Does anyone have experience with this problem or has implemented something lke this?

I would be very grateful for any advice!

Oracle Apex Version: 22.2
Best Regards
Jegor

This post has been answered by jariola on Nov 16 2022

Jump to Answer

Added on Nov 15 2022

#apex, #apex-discussions, #rest

5 comments

597 views