USING External REST API in Oracle APEX
In the previous article, I explained how to CREATE a RESTful Web Services inside Oracle APEX. https://lidagholizadeh.blogspot.com/2025/08/all-about-restful-webservice-in-oracle.html In this article, we will focus on the opposite scenario: How to consume external REST APIs from Oracle APEX and PL/SQL. External API integration is one of the most common requirements in APEX applications. In this article I will explain all supported methods for calling external REST APIs in Oracle APEX: 1. Calling REST APIs Using Web Source Modules 2. Calling REST APIs from PL/SQL Using APEX_WEB_SERVICE 3. Use Rest Data Sources in Our Application But first of all let me answer this question ❓ Where Can You Use Your Newly Created Web Source Module in Oracle APEX ❓ The short answer: Almost everywhere in APEX💖 As soon as you see the Source → Type property on a component and one of these options appears, you can directly plug in your external REST API (Web Source): Interactive...