Advice needed on the best way to orchestrate the below.

We have a booking system which provides an API to get bookings by meeting room (resource id) within a date range i.e. start and end date. e.g. /api/getdata?id=""&start_date=""&end_date=""

The idea is to get the data from the API on a schedule basis and keep our delta table updated accordingly.

My first though is to get the initial load to the delta table for the following period 2024-01-01 – 2024-08-31.

This will give the past bookings and future bookings for the next month.

But what would be the best strategy or logic for the subsequent schedule requests, taking into account that bookings for a resource can change (or even be deleted) if the end date has not passed.

Hope this is clear, but if not let me know.

Any advise would be appreciated.