Hi Marco,
There are different ways to build this cron/scheduled job to pull and store data into oracle DB. Since you wanted this to be built in oracle, below instructions are one way to achieve this.
1. Pull Data from Quickbase using HTTP API that gives data in XML format.
Refer to the NOTES below for Quickbase API information.
2. Build an oracle stored procedure using PL/SQL, use HTTPURITYPE to consume HTTP GET request and read XML data received using Quickbase HTTP API. Use below link on how to do this.
https://sonra.io/2009/03/12/consuming-a-rest-web-service-with-oracle/
3. Once the stored procedure is ready, schedule it for timely download. Use below link for setting up scheduler.
https://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm
4. Use XMLTABLE to extract the data received from Quickbase API GET Response. Follow below link for using this or any other oracle library to read XML response.
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions228.htm
NOTES:
Quickbase exposes HTTP API to read data, follow the below guide hosted by Quickbase to read data out of it in XML.
https://help.quickbase.com/api-guide/index.html
Steps to read Data
Use API_Authenticate to get ticket which can be used to make
https://help.quickbase.com/api-guide/index.html#authenticate.html
Use API_DoQuery
https://help.quickbase.com/api-guide/index.html#do_query.html
Let me know if you need any additional information.
