Hi,
this is great but whats the best way to fetch the URL with data end point and insert into Oracle table? do you think i need to set ACL?
Oracle 12g.
Hi. You will need an ACL, and if you are calling a HTTPS endpoint, you will also need to install the SSL Certificate in your database wallet. If you have APEX installed, then the apex_web_service API is the best way to call web services.
Jon Dixon
I am using Apex 5.x + Oracle 12g.
But my remote json data is accessed via https so i am using using username&password to get the token. that bearer Token i used to pass as part of the parameter to reference the external URL...regards
When I call web services from APEX, I do it from the backend using the apex_web_service PL/SQL API. When using apex_web_service, you must have an appropriate ACL, install the TLS certificate in a database wallet and tell APEX where the wallet is from the INTERNAL workspace.