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!

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
620 views