Oracle Apex 23.1.0 - Region Type INVOKE REST API

 

REST Data Sources have been updated to provide more control over source discovery and responses. The recent REST Data Source Enhancements in oracle APEX is very helpful.

DIRECT REST INVOKE REGION

The region in apex provides a single interface for all common region related functionality of Application Express. This returns an Application Express region object, which is used to access region related functions and properties.

A new region type that currently connects DIRECTLY to rest sources in real time is Awesome!

Data can come from anywhere! Currently most of the external data source offers REST API services. Oracle Apex product development in recent years is highly beneficial to its customers.

A new region types in its release 23.1.0 has a highly attractive and direct inter connectivity between application and external data source.

The new process type utilizes page item directly passes parameter values from application to the rest data source endpoint.

Also, automatically for type conversions, as well as switch and check box item type configurations automatically for Boolean conversion. Identify the API endpoint you want to use and determine the required parameters and authentication method.

 

 

 

 

 Steps to give a try by yourself.

Step 1 : Create a new application on Invoke API Process and it is a new feature in Oracle apex 23.1.0

Step 2: After Creating the application and then create a new blank page to work on this new feature.

Step 3: Define web credentials and configure rest data sources in the application share component section.

Step 4 : Creation of a new blank page for this application and then create a region with this new region type as “ INVOKE API”.

Step 5: Go to the settings and choose Type as Rest sources. Next select Resource then choose Operations ( it can be as per the definitions that configured at initial point of time like GET / PUT) .

Step 6: Now, associate page items to the parameters. The page items will take input form users and pass on to the REST Parameters. This is Wonderful.

Step 7 : After entering some data into page items then it’s automatically communicates with the REST data sources and returns the results on the INVOKE API region.

 

In Summary:

 

The Invoke API process has been extended to support REST Data Sources, providing fully declarative REST invocation for Page Processes, and making it simple to map REST Source Parameters to page items, SQL expressions, static values, and more.

 Excellent feature that supports REST Source discovery based on responses from Swagger/OpenAPI. Create a complete REST Data Source based on a response, including a data profile as well as additional meta data like operations and URL or other parameters.

A new switch item has been added to REST Data Source Profiles to select rows as they are. When enabled, all selectors will be used exactly as specified and APEX will not sanitize row and column selectors when generating the SQL query for JSON parsing.

 

Thanks to Oracle Apex Product Development Team #oracelApex.