Development & APIs

I’m working on a script in an automation (triggered when new record enters a view) where I need to collect some variables (from the record that triggered the automation) to include in an outbound web hook. I’m getting an error on the record.getCellValueAsString lines:TypeError: Cannot read properties of undefined (reading 'getCellValueAsString')let inputConfig = input.config();let recordId = inputConfig.recordId;const table = base.getTable("table_name");let record = table.recordId;let var1 = record.getCellValueAsString("field_name");let var2 = record.getCellValueAsString("field_name");

Is there any way to control the image sizes I get served from an Airtable Attachment field via API? My API docs tell me I can access “thumbnails” in sizes “small” (width 72 on one image), “large” (width 1024 on one image) and “full” (3000 on one image)… But… “full” is not a thumbnail at all, it’s the source image. “large” is too large. “small” is just too small. It feels like there’s a missing middle size here. But it’s not supplied. Is there any way to constrain the size of an output image?

Hello All,Please my Airtable <> Docpotion integration was successful, script runs fine, generates pdf invoice in attachment field when, but unfortunately I cannot view the invoice generated and when I download the file, it also does not render in pdf format. Had series of calls with the founder/support of Docupotion, all looks good from their end. Please I need all the help I can get with getting this issue resolved or any other means to achieving same outcomes This is a major blocker to a major project completion.I have attached screenshot for easy of issue Thanks in advance 🙏🏽 

HiIs anyone encountering intermittent issues with the API.Sometimes it take 2 min to get data, at time a few seconds?

Hello, I have created a custom Airtable extension. But accidentally  I deleted the extension connection from the Airtable base. So how can I run this extension on an Airtable base? Here is only a single option to add a new extension. There is no option to run the previous extension.However, if I try to run by localhost:9000 it shows an error{ "error": "FORBIDDEN", "message": "blockId mismatch. Make sure you are entering development for the correct block." } 

I have the following use case: I have images saved as attachments within a table. I need to automatically upload any newly created images via API (not Make or Zapier due to volume) to an 'Input' bucket on S3. From here the images are manipulated by another API and saved to an output folder. When a file is uploaded to the output folder we would send this back to airtable.Can someone give me some general direction in writing a script to enable this? I understand I will need a presigned URL from AWS which is well documented, but I'm struggling on how I might do this using Airtables API. Any help very much appreciated!Many thanksEdward

I create a Make.com automation that sends out a transactional email to the customer when a new record is created in my enrollments table.  The last step in the automation is to update the Enrollment record so show that the Confirmation Email was sent out by updating the record with today’s date.It’s a rather basic setup, but every time I test it out I am getting a “404 Not Found” error when Make tries to update the record.I have checked the Input / Output in the error, but I’m not finding anything useful.  The OAuth connection is working fine to pull the records, and the Base / Table / Field names are all pulled from the dropdowns.  I also checked the Base ID, Table ID, and Field ID from the output bundle, and they are correct.Airtable Update node 404 Error  Input Bundle  Output Bundle  Airtable Field 

Hi everyone,Has anyone implemented an integration between AirTable and qTest? We’re looking to connect the two systems to sync test data or manage test cases more efficiently.I’d appreciate any guidance, documentation, or best practices on how to set up this integration — especially around API configurations or automation workflows (Zapier, scripts, etc.).Thanks in advance!

Hi,I am the owner of a workspace and I created a base that I would like to generate PAT but when I go to the developer Hub, I can’t find the workspace or the base in the add base field.  😭I must be missing some permission somewhere and I just couldn’t figure it out.  Help please! Thanks,Cynthia

Add static Google Maps to attachments based on addresses in a table. Source Code /** * Copyright 2020 Bocoup * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to * deal in the Software without restriction, including without limitation the * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or * sell copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGE

Hey everyone,I'm working on a personal project to automate my daily finance reports, and I've hit a wall that I'm hoping Airtable can help with.I absolutely love Airtable - it's been perfect for managing my financial data. But here's the thing: I can automate everything through the API except for creating and duplicating views. Every month I have to manually create new views and tables for the new month expenses.What I need:Create and duplicate views through the API Duplicate tables and rename them through the APII've tried every workaround but it didn't work. I just need to automate this.This would honestly save me so much time and make the already great product perfect for my needs.Has anyone else run into this? Any thoughts or workarounds I might have missed?Thanks!

Hi! I get a “Connection error. Please check if your local block is running.” when running the extension I created locally. It works on Firefox. This was working previously. Initially, I thought it was related to a Windows 11 update that broke development with localhost, but I rolled it back, and it works on Firefox…I’m using the latest build as I plan on using the new multi table feature (I’m currently using the Web API to query a second table).

Hello All,Complete noob here, so, please be patient!I want to connect to the HighLevel (GHL) API here: https://marketplace.gohighlevel.com/docs/Authorization/PrivateIntegrationsTokencurl--request GET \--url https://services.leadconnectorhq.com/locations/<location_id> \--header 'Accept: application/json' \--header 'Authorization: Bearer <YOUR PRIVATE INTEGRATION TOKEN>' \--header 'Version: 2021-07-28'How can I accomplish this with Airtable? I want to poll the connection to populate various tables.The Airtable AI wasn’t much help.thanks in advance,Eric

Hi, right now, one of our databse APIs is down sind 2h, while all other of our databses are reachable.  Anyone experiencing something similar or has an idea what we can do? thanks so much for the help

I recently obtained a certificate in Airtable Admin but it's carrying my email address which is not my real name. Please how do I change it

We are a not for profit organization involved in promoting a fascinating Indian Sport called Mallakhamb.We use a combination of Airtable for data storage and sharing and fillout forms connected to Airtable base for  use by public for signups.I would like to understand the contribution of each part of Airtable - data, calculations, automations, shared views and fillout forms , towards the Public API usage. 

I want to send emails via SendGrid. this is to be done through an automation baed on a trigger of when a record enters a view, like this:The email text contains many personalisations, pulled from the database. Some of these fields are lookup fields from other databases. Below are all the personalised fields: And here is the script:// Get your SendGrid API key (store securely)const SENDGRID_API_KEY = "-KEYisHERE-";// Get the record that triggered the automationlet record = input.config();// Extract values from arrays BEFORE building emaillet firstName = Array.isArray(record.firstName) ? record.firstName[0] : record.firstName;let projectLeadName = Array.isArray(record.projectLeadName) ? record.projectLeadName[0] : record.projectLeadName;let task = Array.isArray(record.task) ? record.task[0] : record.task;// Debug - verify values// console.log("Project Lead Name:", projectLeadName);// console.log("Task:", task);// FOR TESTING// console.log("All record data:", record);// console.log("Type:

I know it ha been discussed MANY times, and I even clicked on the “contact developers” to submit a question/suggestion to see if they ever think this will fully integrate with Airtable…. aka upload the PDF upon a trigger via automations, or just a column that IS the page designer. Can anyone at Airtable make this happen? It seems that Airtable is the developer, and with all the chatter here, this one small thing would make a huge difference to so many. Currently the only options are to use external PDF creation tools, which is beyond frustrating when you’ve created the perfect PDF page and all you need to do is link it to the column. The fact that someone can’t even click a link to view the PDF, ugh. Anyway, maybe if enough people “like” this, it can get to the Developer and they can actually follow though. With all the AI and automation of today, I know this is possible! Please help us get there. 

Hello Community,First post here. I am attempting to connect my Airtable to Power BI.I am receiving the following error message in Power BIExpression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type]I am following this guidance and using a Personal Access Token. I setup Power BI Parameters successfully but received the error code in the Query. I suspected that it may be the M Code so I followed a link to a GitHub resource for alternate code."If the above script seems to be causing an error, then please refer to this GitHub resource, as the code may have changed.I have tried both versions of the M code.I don't know enough about tracking down this error code. Any ideas of what it might be?All assistance is greatly appreciated.

Has anyone had any success integrating Airtable with MRI Real Estate Software using API keys?  If so what steps did you take?

In another topic, I recently explained how you can instantly sync your Shopify metaobjects to Airtable.The good news is: you can now sync your Shopify metafields with Airtable too (thanks to SyncBase app) 🤩 How does it work?During onboarding, you can choose which metafields you want to sync (Product metafields, Variant metafields, Order metafields, etc.). The app then creates one table per metafield group (e.g. Product metafields) inside a brand-new Airtable base, or an existing one if you prefer. In each table, you’ll find all your metafield definitions and one record per product, order, customer, etc. You can then edit your metafield content directly from Airtable!It works for all metafield types (list, reference, etc.) and all Shopify objects (Products, Variants, Orders, Customers, Collections...) and everything syncs instantly ⚡️ A few use-cases from our users:Bulk edit Product metafields Auto-fill metafield content using Airtable’s AI features Add values to an Order metafield bas

Hello! I’m having more difficulty than I’d like to replace text with a newline.In the Airtable Find & Replace extension script, I’ve modified it to support RegExp find and special character replace. However, when I replace the text with a special character like a newline, it always comes out in a literal text format.Here’s a real basic example of what I’m doing:let originalValue = record.getCellValue(field);let findText = "<br>";let replaceText = "\n";let newValue = originalValue.replace(findText, replaceText);Every time I view the replaced results, there is always a \n in the output: Is it possible to ensure that Airtable treats \n (I’m even doing \u{005C} to try to get around it and it doesn’t work) as an actual newline and not literally as “\n” ?

Hello,I work for a print company and want to send Airtable data through API to make what's called a JDF ticket which Esko’s Automation Engine can then use.Does anyone have any experience with this?Our main label database software does this, but I want to replace it with Airtable because it is heaps better. Thanks!

When using the Airtable JS SDK, it seems impossible to use the offset with select to do proper pagination. The type specifies `number` but any value I pass gives me an invalid value error. The web API uses a string offset that's returned from the request. Since this is TS, you can't use a string value with the SDK. Is it possible to paginate with the JS SDK?

Hi there,I'm facing this issue unfortunetly i checked on the community but none of the solutions work for me.This is the error: "type" Invalid_Offset_Value - The value of offset 100 is invalid.I'm trying to get 350 rows. I already did a first api call to get the first 100 rows, what i need is to continue with the second call.When i try this url https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome everything work fine, when i use the same URL adding the offset value, i get the error: https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=100What am i doing wrong? I can't work much on the code, i just can modify the URL. I've also tried to put the recordId instead of the "100" but i get the same reply. Hope you can help, thank you very much