We are subscribed to a third party XML FEED that updates data in real time on thousands of records. We would like to incorporate that feed into our Oracle Apex application i.e an interactive report and form that pulls data from our database . Ideally we would have all the required data from the feed in something like a UNION sql statement that includes a query from our database data and a query to parse the xml data from the feed.
The data from the feed will be used in some parts of the application and we can store any data from the feed in our database as well. The documentation is limited and is private so I cannot share it here, but it basically is a Glossary and Definitions of the fields , and nothing else. So I don't have an example to what I could go by to get started.
We'll just say the feed url is https://feedurl.com/data.xml
I've embedded xml feeds into applications in the past, but have become more accustomed to Restful services so I need help getting started and doing this as efficiently as possible.
Thanks you.