Development & APIs

Hey everyone 👋If you've ever run into Airtable API limits or just need a faster way to access your base data regularly, I’ve put together a simple workflow that might help.Using CSV Getter, you can sync your Airtable base to a Google Sheet on a schedule.Results:✅ Faster access to your data✅ Fewer Airtable API calls✅ Automatic backups in Google SheetsThe Google Sheet acts like a proxy API. You can use it for lightweight querying or integrations, without constantly hitting the Airtable API.I wrote a short guide with a diagram and step-by-step setup instructions here:👉 https://www.csvgetter.com/blog/say-go

Hi, I have this table where i would like to filter by the ID of the player. But I strangely cannot find a way to do it.  Thanks a lot for your help,Laurent

Ok, who approved the new gui layout? I keep going top left for the Hide fields, filter, group, sort….. only for it not to be there anymore!!! Any chance you could put some real effort into wrapping the headers of columns please?ALSO allow us to colour the different groups. 50 shades of grey is really difficult to keep track of! 

The back end of one of our products is built on Airtable. Its been runing fine, but in the last couple of months (since May 18th) it hasn't been working anymore. Unfortunately we didn't discover this until now, and this means a key product in our whole business is broken/down.Did airtable change its scripting system to change how attachment fields work? The images being attached work, the script appears to successfully run, logs are totally okay, just the images don't get attached at the end.More info:We wrote an airtable script that, based on data, attaches a photo to the airtable. The script stopped working recently. It gets triggered, appears to run, logs look fine, but images aren't attached. It was working before, but stopped working around may. What do you think the issue is?We’ve emailed Airtable support but haven’t heard back yet :( let table = base.getTable('Raw Data');let inputConfig = input.config();let rec

Hello Airtable Community,I’m working on an integration where we need to detect if someone updates any field in a Form View (e.g., adds/removes/hides fields). I’ve explored the Airtable Metadata API, specifically the endpoint: bashCopyEditGET https://api.airtable.com/v0/meta/bases/{baseId}/views While this API returns the list of views, including forms, it doesn’t seem to provide: A timestamp or audit log of when a form was last modified Information on which specific fields were updated or reordered Any versioning or update tracking for forms Questions: Is there any way (via API or otherwise) to determine if a Form View’s field configuration has been changed (e.g., which fields are visible/required/ordered)? Can we track when a particular Form View was

When working with building automation systems outside of Airtable, a lot of use cases involve taking actions on Airtable data. These are currently done via custom Airtable API calls and actions that require a lot of configuration. They’re difficult to set up, maintain, get right, and scale.It would be a huge advancement if, instead of hooking up all those API calls and configurations ourselves, we could just provide our base and table and provide our request to Airtable Omni via the API and let it do the agentic work on our data.For example, the automation might look something like:ClickUp trigger > Airtable > Airtable Query: “Look through user feedback data in table X in base Y and provide a summary report of the 3 most important areas of improvement according to Z criteria” > Upload the PDF and upload to Microsoft OneDrive.”The parts in bold is where it would be very he

I’m creating an extension here. Often times I want to send record from extension to my backend api. My backend already supports the json serialized format returned by get records api. It would be very helpful if there is a method to convert record object in blocks sdk to that format. Or is there already a way for that?Thanks

Is there a script that can initiate printing of a record designed in the printing extension from an interface? As in, Print This Record?

Hi all,I am struggling to find a solution to this, and I wonder if it’s an easy problem. I want to upload an attachment to an Airtable base for a specific record/field; I am following the instructions reported here: Upload attachment - Airtable Web APIHowever,m I keep getting error 403. I can create and update records, but the image upload is not working. Any ideas? 

I don’t want to be overly negative as I love Airtable, as do my clients. But can Airtable slow down in integrating new features without proper testing. In the past couple of weeks since developers integrated Interface/data layout into one in the home view, there have been so many bugs in the system. I am all for new integrating and love the direction the company is going. However, don’t be premature about it. Every time I am using Airtable now there are new bugs and I don’t have time to send Airtable developers feedback and examples... It’s hard to keep up (more a clients perspective) with new features, new layouts and new bugs. To the developers, just make sure your ready before publishing new layouts and features please 🙏

API for searching in multiple basesHi community, My company developed an API to search multiple databases, we used Airtable for a talent pipeline for the company's recruiting team, and we found ourselves with the limit of 50,000 records (teams plan).Instead of upgrading the plan, we developed this solution. We divide our base by years and create several bases. And with this new program, we can search through all the databases quickly and effectively.I share screenshot In the API, you can search multiple fields (in the example, we search through name and Linkedin link), and then, it shows in which base the API found the specific record (Of course, you can choose which fields you want to display.)What do you think if we commercialize the API? Do you think it is a recurring problem for airtable users?Thanks!Lu

We have created a Provider Directory on our website, and we got feedback requesting a map to accompany the list. We have created a "Sandbox base" where we're trying out the AirTable Map extension, but I'm wondering if there's a way to display the map *next to* the table on our website (or above or below but specifically *with* the table).I see that it doesn't embed, but is there a way for a developer to do it if we hired someone? Any other suggestions if not?(I already tried the other map extension called MapChart and confirmed theirs won't display externally at all.)Thanks!Erin

Since last week my HTML forms began to fail with scripts apps which I could send data and pdf files to airtable the file as it is, now it doesn't allow I don't know what to do someone knows a safe method but that is not using the drive download URL, thank you

Can anyone tell me if there’s a way to perform web scrapping on Airtable and fetch changes related to the tickets? For example, I change the status of my ticket to In-Progress from To-Do, I need a custom scraper method that would parse the data and store it into my database. I am using Node.js and puppeteer. 

Hello! We encountered a number of systematic errors when accessing our Airtable databases inside Make (former Integromat) scenarios via APIWhen accessing an Airtable module in a Make scenario , Airtable consistently throws one of two errors:1) Error 4292) The operation timed outBecause of this, all our Make scenarios automatically stop and we experience great difficulties. Re-running the scenario results in similar errors.Please help fix this issue.The screenshots with errors are attachedThank you in advance

I'm using a simple JSON to POST data to create a new record in Airtable.I'm using Field IDs to prevent name changes from affecting the integration. I've replaced the actual field ID's below for this example, however I'm using the correct Field IDs in in my production environment.I'm using variables captured from the chat to send to Airtable.{"records": [{"fields": {"fld1": "{First_Name}","fld2": "{Last_Name}","fld3": "{eMail}","fld4": "{Boomo_Intent}","fld5": "{MCI_Copilot_Feedback}"}}]} I've verified both my endpoint URL and Authorization API Key.I've troubleshot this for a couple of days now including using ChatGPT but still get the following error:{"error": {"type": "INVALID_REQUEST_MISSING_FIELDS",

I'm wondering if forms can also have the "take photo" function in attachments the same as when adding records from a phone or device? The idea is to have customer feedback be able to take a photo in the feedback form without going through their gallery.  

I want to use server-side Airtable API calls to completely replace all options in a "Multiple Select" field type. Specifically:Current options: A, B, C Via API call: First delete all existing options (A, B, C) Then write new options (D, E, F) ​Question:​​ What is the correct request body structure for this operation?I've tried the following JSON structure, but always receive this error: { "error": { "type": "INVALID_REQUEST_UNKNOWN", "message": "Invalid request: parameter validation failed. Check your request data." }}My attempted API call:--data '{ "options": { "choices": [ {"name": "D", "color": "blue"}, {"name": "E", "color": "green"}, {"name": "F", "color": "green"} ] }}'

Some field types including single selects, multiple selects, linked records, and collaborator fields will show “List” or “Record” instead of the values you may be used to seeing in the Airtable grid view. This is consistent with how the Airtable Web API returns information.

Hi there,I am using webhooks to send data from our base to our application endpoint, but we've observed that if our endpoint fails to respond correctly, the webhook is retried many times.While we work on making our endpoint more resilient, the volume of retries can cause issues.Is there any setting, configuration, or recommended best practice from your end that we can use as a workaround to prevent or immediately stop a webhook from retrying upon the first failure?Our goal is to have more direct control over the retry behavior to avoid overloading our systems during an incident.Thank you for your guidance.

I’m having trouble making a successful API request via Postman, and a co-worker pointed out that the documentation says a requirement is for the user to be an “Enterprise admin”.See here: https://airtable.com/developers/web/api/hyperdb-table-read-recordsWhat admin roles, listed on the page below, does that refer to?https://support.airtable.com/v1/docs/admin-roles-in-admin-panel-overview-and-managementMy current role is an “Integration admin”. Does this role count as an “Enterprise admin”? Do all those listed roles count? Are these different contexts? 

Heya everyone!So I noticed that on the Airtable update API endpoint they note about upserts:Airtable reserves the right to throttle upsert requests differently from the standard rate limit throttling policy.Intuitively, I’d assume that differently means that they’re more strict about it as they’d be doing comparisons on their end.Does anyone know whether upsert is throttled more aggressively than plain updates? I’d assume so but I thought I’d get it cleared up.Thanks!

I have an object that I output from another script using the Output.Set(key: value) method. The value that I’m passing is an array of json objects. It seems that there are a lot of objects to transform the object but I would prefer to just pass the object to my script to iterate over the object and use dot notation to get the values that I would like.  I don’t see anything that just lets me keep the object as is and pass it through input.config only transforms or operations like length? Is there no way to pass an array or object??

Hello everyone, I hope you can help me! I am creating an product database for internal purposes. I have created a Softr interface and I want to have a customer chat bot to can answer basic queries such as “Does this product have x feature?” “What is the price of this product” etc… I have managed to create everything with the help of Chat GPT (I can’t code!) but once issue remains, when I try to trigger a database search, it constantly returns with “I can’t find this product”. I have searched the console, it says it cannot access the database because authentication is required and returns an error 401 or 403. I have checked the token, the database ID all and everything is correct, so I am a bit at loss! I am the owner of the database. Hope someone can assist with this, thanks in advance for any advice!

I've registered a new OAuth integration record on my dev instance of Airtable, however when trying to perform the first step of authorization by getting a code I am presented with the following error:There was an error during grant authorization. Close this window and try again or contact your system administrator for details.