Would be neat to be able to easily input a url for an API and have the response automatically generate an Airtable table. Then I want to manually (or ideally semi automatically) link rows in my other tables to this API data so I can then do other formulas and rollups.
Whenever data changes in the API endpoint, then it automatically updates my dependent columns.
It’s highly unlikely that that will ever be natively built into Airtable, but you can already do that with several different tools: DataFetcher.com or Make.com or writing your own custom scripts within Airtable’s automations.
Why wouldn’t Airtable consider it? Data isn’t always fixed. Moreover, I’d like to easily extend my data with other datasets without manually downloading, converting, parsing it all in a tedious fashion.
https://www.superblocks.com is a great example for working with APIs and external datastores. Airtable has a great interface for managing data. Would be cool so see something in between.
This is what the Data Fetcher extension is designed to do! Connect to any third-party REST API or remote file (e.g. a CSV file on a server somewhere) and update your base data when the data changes.
It can’t create tables but does create the fields (with suggested types) for you when you set up an API request for the first time.
