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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Executing self-signed REST APIs in Oracle Apex (autonomous database)

Edisson Gabriel Lopez SalamancaMay 29 2024 — edited May 29 2024

Hello,

I am having trouble accessing a REST API that I believe is self-signed. I tested with the Rick and Morty API and it works fine. How can I run this REST service in these cases?

Certificate:

GlobalSign GCC R6 AlphaSSL CA 2023

GlobalSign nv-sa

Try searching, but they are all about oracle apex local and not autonomous database.

Reference:
https://enesi.no/2021/03/utl_http-from-oracle-autonomous-database/

Update:
The issue persists in another APEX environment. It is necessary to execute REST services for this user, but all users have this problem in the cloud. Is there a way to disable certificate verification or allow services to run even for users without certificates or local locations?

tried the following, but nothing worked:
https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/call-web-services.html#GUID-E335B0E5-D540-4C05-A727-4E4EDBCECEB3

Regards

Comments
Post Details
Added on May 29 2024
7 comments
542 views