JSON Parsing in Oracle SQL and PL/SQL

14 likes

14.3K reads

Oracle APEX Shorts

orclapex

6 comments

Jon Trøstheim

·Sep 8, 2022

Sep 8, 2022

Super nice :-) thanks again Jon

·1 reply

Jon Dixon

Pro

Author

·Sep 8, 2022

Author

·Sep 8, 2022

No problem, glad you like it.

Enock Oloo

·Sep 28, 2023

Sep 28, 2023

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.

·3 replies

Jon Dixon

Pro

Author

·Sep 28, 2023

Author

·Sep 28, 2023

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.

Enock Oloo

·Sep 29, 2023

Sep 29, 2023

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

Jon Dixon

Pro

Author

·Sep 29, 2023

Author

·Sep 29, 2023

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.