I’m building an integration that needs to sync ~6,600 records from an external API to Airtable, ideally in under 1 minute.
Currently I’m hitting the standard REST API limits (10 records/request, 5 requests/second = ~2-3 minutes minimum, but in practice it’s taking 10-13 minutes due to network latency).
I’ve looked into: ∙ Sync API (CSV) - but the table becomes read-only, and I’m seeing significant processing delays after the request completes ∙ REST API with performUpsert - works but slow at scale
Has anyone found a faster approach to bulk insert/update thousands of records? Any workarounds or techniques I’m missing?
For context: manual CSV import through the UI takes ~5 minutes for the same data.