Here's the problem: I pull booking data for a date range, let's say daily or weekly or monthly and put it into SQL
Then, someone gives a refund to a guest a few days after checkout. My data is now obsolete.
The only way to avoid this that I can see is to continually pull old data in case it's changed.
Ideally, each record would have a "last modified" timestamp (I suspect this might already be the case, but only internally). The API would allow me to specify a "modified since" parameter, and only return data modified since that date. Then, I can update my data.
This would reduce the load on both servers, and provide a better "API experience"
Tim
