Discussion on "JSON Parsing in Oracle SQL and PL/SQL"

Jon Dixon · 2022-09-05T14:29:54.572Z

As an Oracle APEX developer, I regularly consume JSON from external web services. When I can, I use APEX REST Data Sources or the APEX_DATA_PARSER PL/SQL API to turn JSON into rows of data that can be easily consumed by APEX. There are many occasions...

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.

thanks.

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.

Super nice :-) thanks again Jon

No problem, glad you like it.

Discussion

JSON Parsing in Oracle SQL and PL/SQL

Responses(2)

Recent in Forum

Search Hashnode

JSON Parsing in Oracle SQL and PL/SQL

Responses(2)

Recent in Forum