Purging from the cache will essentially disable your API until the next sync occurs. For Google Sheets and Airtable, that's every couple of minutes. For External API data sources, the next sync will be dependent on how often you have your API polling setup to run (e.g. every 1 minute, every 10 minutes, etc.).