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.

[@mohamedsameer3549]

Hi Chaitanya, Your tutorial videos are more clear than others in oracle. Big thumbs up 👍🏽. Thanks.

[@ArunKumar-ii1jp]

Excellent video, Kudos for the new functionality

[@HeshamAbuElenain]

Amazing Feature and awesome video, thanks Chaitanya

[@daxelai]

It's too much excellent. One more videos wishing for how to create web services so from other server apex can use as rest service.

[@mohamedsameer3549]

I would like to request you to make complete video tutorial for rest data sources and their methods.(Get, Post, Put, Delete)

[@miguelangelquintanasilva3933]

Very nice feature.

[@NickSThompson]

This appears to be one-way sync. Is it possible to make it two-way, so it posts changes made to the local table back to the REST API?

[@madhusudankatkam4382]

Is there any option to sync the table at remote DB from the local DB.

[@geova26]

How can I make something like that to copy data from a Google Sheet to my Apex app?

[@muhammadasifrazakhan1693]

I get this error during REST Data Source Creation "ORA-24247: network access denied by access control list (ACL)". I am running APEX 22.1and ORDS on a local machine with 19c DB.

[@gayatri1783]

very good feature and very easy no code feature

[@santoshjadhav2993]

How can blob content data be synchronized from REST Services to Local Table

[@arslanhayat8351]

Hi Sir how can retract user by MAC address in login.. for example i have table APP_USER(users_id,user_name,user_pass,user_status,user_mac) if user want login and device mac exist in table then login else invalid... how to do sir.

[@tanveershahpk]

Nice, can you explain the REST Data Source with OAUTH2 Authentication

[@mksnaps8679]

What about the REST source having a Parameter. How to synchronize all data of an API having parameters. How to pass multiple values of a table to a parameter.

[@OracleAPEX]

See this: blogs.oracle.com/apex/post/synchronize-parent-child-rest-sources

[@grandma-story]

i have a problem with https gives me error ORA-29024: Certificate validation failure

[@visitermanvisiterman8513]

عندي نفس المشكلة ولم اجد لها حل فضلا هل وجدت حل لهذه المشكلة استخدم database 19c

[@keyhole2863]

I'm getting the same error. Did you resolve your issue and if so, how?

[@mofijulislam6974]

N c video