Development & APIs

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!Lucas

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","message": "Could not find field \\"fields\\" in the request body"},"VF_STATUS_CODE": 422,"VF_HEADERS": {"access-control-allow-headers": "authorization,content-length,content-type,user-agent,x-airtable-application-id,x-airtable-user-agent,x-api-version,x-requested-with","access-contr

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"} ] }}'Key Points:​​Field type: Multiple Select Operation: Complete replacement (not incremental updates) Error persists despite correct authentication and field IDCould you provide:The exact JSON structure required for complete option replacement? Any special parameters needed (like enable

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.

Hi there - I have a list of outputs and am trying to create a PDF listing those. Is it possible to create a PDF via script? Or what other methods are there other than one line per PDF? How could you use the PDFs if linking all records to one record in another table?

We are trying to set up an 0Auth connection for retool. Unfortunately the Dialog to define Scopes and select the Base does not load/open at all. When I click “grant Access”, a loading wheel appears but nothing ever happens. Does anyone have an idea where the problem could be ?  

Is there a solution to sync Jira which is an on premise version NOT Jira Cloud. When in the office I have access to both Jira and Airtable which are behind firewalls. Are there any solutions maybe with MCP Browserbase or other type of way to extract data not via API but through the browser and sync with Airtable. 

Here’s my thinking. I like the simplicity of Airtable’s own “Export CSV” function. Data in a spreadsheet as a simple backup is all I am after. If “Export CSV” could be triggered via a script, the entire process could be automated. A new record could be the trigger to run this script. Does anyone know if this is even possible? Thank you!

Hi all — every time I try to import a Google Sheet into Airtable, I get this error:"Can’t import from Google Sheets — Something is wrong with Google API."This happens regardless of which sheet I try. The sheet is shared properly and I'm logged in with the right Google account. Is this a known issue with the Google Sheets sync or a permissions problem? Would appreciate any tips on fixing or working around this (besides switching to Excel!).Thanks!

Hi all 🙂 Please, is there any way so I can convert emails to PDF?I have a TaskRobin integration, and would like to save my incoming emails in PDF format.Thank you 🙂

Hi Dear community I'm building an app for kitchen management specially recipe costing Need somebody to guide me for developing the apps introducing interface and adding tables for inventory management I'm  new and passionate to aittable  Please give me advice without costing a fortune .…Kind regards 

Thanks @openside for your famous post "New Script: Same Table Linked Records Backlinks".Is there a way to use this in automation so that whenever the Parent task is updated, the child task runs? How would you need to modify the script?