Airtable is a great app to automate your workflow. You can keep your payment records, habit tracks, todos, estimations of your next project — all at one place. It is today's Excel. But unlike Excel, you can make airtable act like your database.
Key Issue :— Airtable API is hard to integrate, because it has limits on calls and advance level documentation. For example 👇
By default, every GET request has 60 seconds of caching which means that the first API call will come from a third party application API and other API calls under the next 60 seconds from the caching server.
Confusing ? It is ! Below is a work around to fetching airtable data to your website without getting into unnecessary details.
- Click here 👉 airtable.com/account to go to airtable account's page.
- Click on Generate API Key under the API heading.
- Click on password input field to pick your API Key.
- Click here 👉 airtable/api · to go to airtable's API page.
- Click on your airtable base (Base is your file name).
- Copy your Base ID — It starts with letters
- Sign In to your nocodeapi dashboard.
- Go to Marketplace
- Activate your Airtable app
- Click on “Make Airtable API”
- Fill in API Key (from Step 1) and Base Id (from Step 2)
- Press the “Create” button
- Click on “Use this API” button just above your generated Api
- Select “Get” on the overlay just appeared
- Select “Click & Test API”
- Enter your "tableName" — this is the sheet name of your airtable base
- Press “Execute” to test it
You should get a 200 response with all rows in your airtable listed in JSON format.
Through your airtable integration you can make GET, POST, PUT and DELETE requests to manage your database.
If finding something confusing, watch this video tutorial.
I hope you enjoyed this blog. You can contact us on telegram at nocodeapi.
Thank you. ✌️
Paid users can customise caching time. Pass cacheTime (in seconds) as
query param with your api end point.
Now your endpoint will be cached for 900 seconds(15 minutes).