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!

How to get the data from https web service directly from APEX 19.2 | Oracle 19 C

Ashish SahayApr 4 2020 — edited Apr 9 2020

Hi there,

I need to get the data from https web service url which is kind of https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/2.5_day.geojson.

My Database Details

OS: Win 10 64 bit

DB version Oracle 19 c

Pdbs:   APEX_5, APEX_18, APEX_19

I have installed three versions of APEX in three different PDBs as above.

Now the requirement is of getting data from https url in APEX report which is in APEX_19 PDB.

What i have done:

Creation of ACL: Not sure where to create

Creation of Wallet: Tried using below commands

orapki wallet create -wallet https_wallet -pwd *** -auto_login

orapki wallet add -wallet https_wallet -cert usgsgov.crt -trusted_cert -pwd ***

SSL certificate : Retrieved the SSL certificate from the site

Please share the steps only for Oracle 19C. Thanks

Ashish Sahay

Message was edited by: Ashish Sahay

Comments
Post Details
Added on Apr 4 2020
6 comments
1,167 views