This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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.
Is there a way to magically create new tables in bases through these (or any tools)?
The Enterprise API allows creation of bases, tables, fields, and collaborators. Interestingly, it does not allow the creation of views.
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.
Pretty cool! Definitely will try it out for a few different things!
In my specific use case I have endpoints for each record that I’d like to call and parse which is a little different than what I was describing above.
Nice! You can actually reference values from your table in Data Fetcher (even a whole URL), so it’ll do what you need: Use table values in requests - Data Fetcher Help Center
Of course, another option is scripting!