Dan Cook
05/29/2023, 4:05 PM{{ last_records | count < {{ config['records_per_page'] }} }}
2. Incremental sync should allow for not just time-based cursoring but also integer/id-based cursoring. The API endpoint I've set up incremental sync for works a lot better if I can "scroll down" to the latest known ID rather than latest known timestamp. That's because this API only allows for starting from a specific date (format YYYY-MM-DD), not from a specific timestamp. So at best I can fetch everything since the last known date, which renders intra-day incremental sync repetitive/pointless and involves a lot of de-depuping. So it's best to simply wait until just after midnight and fetch the last 24 hrs worth of data.kapa.ai
05/29/2023, 4:05 PMkapa.ai
05/29/2023, 4:06 PMDatetimeBasedCursor
for incremental syncs, but they don't mention integer or ID-based cursoring. You can find more information about incremental syncs in the [documentation](https://docs.airbyte.com/connector-development/config-based/understanding-the-yaml-file/incremental-syncs). If you have feature requests or suggestions, it's best to reach out to the Airbyte team through their [community forum](https://discuss.airbyte.io) or [Slack](https://airbytehq.slack.com) to discuss your ideas and get more information.David Anderson
05/29/2023, 4:19 PMMaxime Carbonneau-Leclerc (Airbyte)
05/29/2023, 4:36 PM