Introduction
When working with REST APIs via ZappySys SSIS/ODBC PowerPack, you might see this error:
429 – Too Many Requests
This means the API provider is throttling you because your package is sending more requests than the allowed rate limit.
Common Causes
- Paginated or looping calls with no delay between requests
- Parallel tasks hitting the same API too aggressively
Quick Fixes
- Check the API’s rate-limit policy (e.g. X requests per minute)
- Enable Throttling on the ZappySys JSON/XML Source to add a wait time between calls
- Turn on Auto-Retry for HTTP/OAuth connections and handle status code
429 - Add a small delay in For Loop / Foreach Loop containers to avoid back-to-back calls
These tweaks reduce API pressure and prevent your packages from failing due to 429 errors.
👉 Read the full troubleshooting guide with screenshots and detailed steps
Top comments (0)