Slow or Delayed Sync
Issue
Syncs are slow or delayed. The following message appears in the connection logs:
HTTP 429 Too Many Requests: after <number_of_attempts> attempts, sleeping for <sleep_duration_seconds> seconds
Environment
Connector: Apple App Store
Resolution
To reduce the number of API calls and prevent this issue, consider removing unnecessary tables from your connection schema. To adjust an existing connection's schema, do the following:
- In Fivetran, go to your Apple App Store connection page.
- Select the Schema tab.
- Deselect the checkbox next to any unwanted tables.
- Click Save changes.
Cause
This issue occurs when your connection exceeds the hourly request limits enforced by the Apple App Store Connect API. When this happens, Apple temporarily blocks further requests, delaying the sync.
For more information, see Apple's Identifying Rate Limits documentation.