What we do with our most robust integration is try to build real-time integration based on pushed data. The way we see it:

Option 1: An API we can reach out to on an hourly or daily schedule to get data from it as of that time. We are then responsible for reconciling that data.

Option 2: An API we can reach out to a scheduled basis that sends us transactional or incremental data. We can send back to the API to tell them when we action something, so it does not get sent again.

Option 3 (Ideal): We can subscribe to a “Webhook” with an API endpoint of our own. This setup then sends a request to our API whenever a new record is created, updated, or modified so we are getting that data in real-time.

Hope this helps,