Busting the cache
There are a couple of ways to set your TTL on a per-table basis.
This may be useful if you are updating your data and would like your data to reflect your Airtable almost instantly.
Make a request
The easiest and simplest way to bust a cache is to make a DELETE
request to our endpoint.
In order to this, you will need...
- your user ID,
- your base ID or name,
- your table ID or name, and
- optionally, your view name
The URL structure is: https://airproxy.api/api/v1/data/<user_id>/<base_name>/<table_name>?view=<view_name>
.
You will probably recognise this URL structure from fetching your data; that's because it's exactly the same. The only difference is that you need to send a DELETE
request, rather than a GET
request.
Of course, you are free to setup a cron job, manually send a request or any number of other imaginative ways to do this. Tweet me some creative way!
Automations
Note: to set this up, you will need an either an Pro and Enterprise Airtable plan.
Currently, the only way to bust a cache "automatically" is through an Airtable automation.
To set this up...
- Open a base on Airtable,
- Click "Automations" on the top of your screen,
- Click "When a record is updated",
- Select a table under the "Configuration" section on the right hand side and filter by columns if desired.
You will then be able to add a fetch request to a URL in the style above. You can learn how to do this in the section above, under Make a request.
Webhooks
😇 Coming soon!
We're currently working on a way to allow us to listen for changes to your Airtable data and purge your cache automatically.
This is currently in development; but if this feature would be useful for you, please support it through our feature roadmap.
Tweaking your TTL value
When you set your TTL on a table, we purge the cache so that we can update the expiry timestamp.
Although not a recommended way, in a pinch you can use this to purge a tables cache.
If you would like different ways to set and control your TTL times, let me know via our feature roadmap!