Troubleshooting and Resolving “Too Many Requests Error” in Bold BI

When integrating APIs with Bold BI, users may encounter a “too many requests” error. This error occurs when the number of API requests exceeds the API rate limit. For example, AppFolio is set to 5 requests every 5 seconds. To resolve this issue and ensure a smooth data synchronization process, follow the steps outlined below.

Steps to Resolve the “Too Many Requests Error”

1. Delete Unnecessary Data Sources
   Begin by reviewing the data sources connected to the APIs within Bold BI. Remove any data sources that are not essential to your reporting needs. This will reduce the overall number of API calls being made.

2. Adjust Schedule Refresh Interval
   Increase the time interval between scheduled data refreshes. This will spread out the API calls over a longer period, helping to stay within the rate limit imposed by the API provider.

3. Increase Rate Limit in Data Source
   If possible, adjust the rate limit settings in the data source configuration to align with the API rate limits. This can prevent the system from attempting too many requests in a short timeframe.

By following these steps, you should be able to mitigate the “too many requests” error and maintain a stable connection between the APIs and Bold BI.

Additional References

• Google API limit and quota
• How to Resolve the “Too Many Client Already” Error in PostgreSQL Data Source