Synchronizing Data from REST Services to Local Table
Web Source Modules are now named REST Data Sources. APEX supports data synchronization from a REST Data Source (formerly known as Web Source Modules) to a local table. Synchronization can run either on Schedule or on Demand, by calling the APEX_REST_SOURCE_SYNC package. Developers don't need to build custom PL/SQL code in order to copy data from REST services to local tables; APEX provides this as a declarative option.
In this demo, you first create a REST Data Source using the USGS (U.S. Geological Survey) JSON feed URL for URL Endpoint. Next, you create an interactive report that utilises this REST Data Source. Then, you define a primary key in the REST Data Source's Data ProUle and configure the synchronization. After the synchronization is triggered, you review the logs and also the local table data. Finally, you update the interactive report region to utilise the local table as a data source.
Watch video Synchronizing Data from REST Services to Local Table online without registration, duration hours minute second in high quality. This video was added by user Oracle APEX 21 October 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,26 once and liked it 21 people.