Development & APIs

I currently am using Airtable as the backend for my company's app. The automations functionality and populating information automatically from a form are the biggest game changers we've had in a while. I understand that Airtable is not a backend and loading times are going to be slow. However, is there a way to improve loading times? our main table only has a list of 27 items (running a single formula). Reference files such as images and videos are also being compressed. I've tried pagination but the loading time still seems slow? It takes around 3 to even 7 seconds to load information. Thanks in advance.

I tried searching for an answer to this without any luck. I’m trying to create a button (linked to a script) that will add a specific comment to a record. Is that possible?

Hi all,I'm a complete beginner and have never worked with API's before. So I'm really sorry, but I'm hoping someone could help me, as I've been googling for days and don't know what is what anymore!I am trying to link my shipping solution (Shipstation) to my Airtable database.So far, I've managed to successfully set up a webhook, so when an order is shipped, Shipstation sends a webhook to Airtable. However the webhook is just a "resource_url", not actual useful data (like an order number). I've gone to the "resource_url" (which needs a username and password) and it has all the data I need.So I guess I need to "run a script" and write an API to go and fetch the data from the "resource_url", so I can then use the order number to "update record".I've added the "resource_url" from the webhook as a variable / input config.So what I need the script to do is;Go to "resource_url" (which is the input config called SHIPSTATION)Login with Username and passwordOutput the dataCan anyone h

I am working on Zoho 's cliq communication platform and I am developing an Airtable extension for that platform. When I tried to create connection with Airtable (actually the platform has a internal frame work kind of thing ) through which oauth connections can be made by providing the client id, secret and other credentials and the rest of the things are taken care of by the backend. And when I tried to create the connection. The authentication tab tried to load and closes automatically without any sign. I have provided below the url sent from the Zoho cliq platform to establish connection. I have intentionally provided the redirect uri wrong to catch the req formatRequest:http://airtable.com/oauth2/v1/authorize?client_id=<clientId>&redirect_uri=https%3A%2F%2Fdeluge.zoho.com%2Fdelugeauth%2Fcallback&response_type=code&scope=data.records%3Aread+data.records%3Awrite&state=fbfa4c39db9a4a9cd58b66b4126468dcda979b338eb5cb3ebefd4d7fe88403ad47b0683e85a

Hello! I have two tables "Event" and "Speaker". An Event can have multiple speakers, and a Speaker can belong to many Events. This is configured by a linked record column on both tables.I am currently querying 20 Events at a time, and though the response give's me the Speaker's linked primary record_id (~15 of them), it does not give me the full Speaker object.After some digging I see I can use the `filterByFormula` as part of the Speaker query, but the method I came across seems very cumbersome (chaining together multiple `SEARCH()` queries using `AND()` Link )Is there a way which I can pass an array of Speaker record_id's that return the full records of the requested Speakers? Similar to a SQL `IN` statement:```SELECT * FROM speaker WHERE id IN(< ARRAY_OF_SPEAKER_IDS >)```Better yet, is there a way to return a response that includes both the Event and it's associated Speakers? This would be ideal as Rate Limiting would be less of a concern. 

Hi everyone! I've recently started using Airtable and absolutely love it ❤️However, I'm getting an error while trying to use the PATCH request to update a field in my table.My code is shown below:UrlFetchApp.fetch('https://api.airtable.com/v0/' + baseID + '/' + tableID + '/' + recordID, { method: 'PATCH', headers: { 'Authorization': 'Bearer ' + api_key, 'Content-Type': 'application/json' }, body: JSON.stringify({ "fields": { "OpenAI_key": userApiKey } }) });Error message:Exception: Request failed for https://api.airtable.com returned code 422. Truncated server response: {"error":{"type":"INVALID_REQUEST_MISSING_FIELDS","message":"Could not find field \\"fields\\" in the request body"}} (use muteHttpExceptions option to examine full response)Any help will be appreciatedThanks!

I see I can input the record ID of the modified record and any specific field of that record into my script, but what if I don’t know which field will be changed and I want to get that record’s field’s value? My early testing found script automation to be kinda slow, so I want to try and be as optimized as I can be from the start. My goal is to monitor >200 fields of a particular record type, then if any are changed, add those records together, create a running total per time period with that summed array, then update a separate record for running totals with that array. I found that addition and subtraction for this many fields at once took almost 30 seconds to update, so I want to only update the fields necessary. EDIT: Updated to give more details about my intentions

Good day,Since my site is integrated with Airtable, I would like to ask if I delete records in one table, would that affect the viewing in my Softr page? Is there a data retention for this?Thank you

Hi, is it possible to issue E invoice using Airtable based on ZATCA standards, like now KSA government linking all invoices via API in there portal from external apps.So if we create records it will generate QR code (contains company details) then the invoice send to govt portal via API for approval.This process flow is possible in Airtable ?

I noticed that running a script as part of an automation flow has some limitations in place, which are outlined here. I want to know if the same limitations apply when I am using the Scripting extension.Thanks!

Is there any way to access the extension APIs outside of an airtable extension? The view metadata provided by the extensions resources Airtable Blocks SDK includes visible fields and other view metadata that the public view metadata API does not have Airtable Web API

Hi there! So, I have a funny case. I wanted to connect to a webhook and grab some properties. I needed to create a script since I had nested data. I did that and noticed that I can't use updateRecordAsync() procedure inside scripts in automation. I then switched to Scripting Extension and managed to implement the script there. But, then I can't have inputs from a webhook, that is, I can't add a script from extensions to automation. Am I wrong and is this possible? (I hope) If not, is there another way to use the updateRecordAsync() procedure in automation or to add webhook input into the Scripting Extension?

Hi I hope you are doing well,I am new at using Airtable and I have created 4 tables in Airtable : clients, sites, projects, partners and agencies, the relationships are that to each client we assign sites and to each site we assign projects and to each project we assign agencies that are related to partners based on the region so in the table project for one project we may have more than one agency but I want to creat a column in project where we can only keep the agencies that are checked in the table of agencies.Thank you for your help

<iframe class="airtable-embed" src="https://airtable.com/embed/<share view id>?backgroundColor=green&viewControls=on" frameborder="0" onmousewheel="" width="100%" height="533" style="background: transparent; border: 1px solid #ccc;"></iframe>How do I get the <share view id> part of this url via  api?? I would like to integrate iframe in our platform Thanks!

HiI'm reading my Airtable data using the API which is working fine, I'm now trying to write back to Airtable but I am having issues.I can write to Airtable successfully if the field is a string or a number but I can't when it's a currency. Any ideas how I do this?This is how I am currently doing it: Request.headers['Authorization'] = 'Bearer API here'const obj = Noodl.Object.get(Inputs.ObjectId)  Request.content = {    records: [      {        fields: {          "Overhead": obj["Overhead"],          "Amount": obj["Amount"]        }      }  ]} Amount is currently a number although it doesn't matter if it's a string or a number as they both work but currency does not.

hey!  trying to get this script to run, and I cannot seem get it right.  Any help would be appreciated!Scenario:  I'm trying to update a list of Records as a step in an automation.  I have my automation to receive both the row for which the values will be inherited from, and the list of records in which to deposit the values.  I've modified what seems to be a popular script, below:Script     let config = input.config(); let StackerEmail = config.StackerEmail let ALink = config.ALink let records = config.RowIDs let table = base.getTable("Projects"); for (let record of records) { await table.updateRecordAsync(record, { "[For Stacker] A Email": [{StackerEmail}], "A Link": [{ALink}], }) }    The error I receive:    ERROR Error: Field "fldLpHsJuxicnS2eZ" cannot accept the provided value. at main on line 8    input (With examples & field types)RowIDs |&n

Hey Guys, My question is how many external API calls we can make in Scipting Extension Block per execution.FYI, my usecase is to read records(around 2000) from a table view, make 2000 API calls for all of these records, and then finally update the records in a batch update of 50.I particularly want to know that if there's any limitation on making external API calls in scripting extension block?Thanks!! 

Hey. I need some help scripting to generate next available SKU when adding a new product through an Interface.My table is called PRODUCT MASTER and my column is SKU. Depending if product category (column category) is Software, Subscription or Hardware, it should look for and create the next available SKU number in the 100000, 200000 or 300000 range. And how can I add this automation to the Interface form that I have created? Or do I need to add the automation to a button? Appreciate any help! 🙂

Admittedly, I'm super new APIs in general, and I'm using ChatGPT to generate the code. So, if you're looking at it and you're like 'you and chatbot are wrong about everything and this can't be done', please let me know.Here is my use case:Imagine I am a duplicating a base and all of its tables and records from one Airtable account to another via API. I push a button, and it runs a script which performs this action.My first question is, with the new API, is this even possible?If so, my follow up question would be related to the code ChatGPT gave me. I filled out the placeholders with the appropriate information (I think), but I get a 404 error that returns 'Error Copying Base: undefined'.I'm using the new token api with all scopes allowed on the particular base I'm trying to copy to another Airtable account.My main question would be: what the heck am I doing wrong?And also: is the SOURCE BASE ID and YOUR APP ID not the same thing? They're both just app ids for the base, yeah?<script&

Hi folks! I have an API I’d like to interact with in the Scripting block which requires AWS V4 signing in the headers. There are a dozen ways to do this very easily using npm libraries but I’m wondering if anyone has some guidance or resources on how to do that with the standard library instead. I imagine there are standard library functions for hmac and the like.

I got a user table and all the users link to a Company table to a specific company. How can I query all the users under that company?

Hi everyone, I'm trying to create a new formula copy the product link and add my id to the end please help. Also any resources on formulas fr babies would be great because i feel my last hour was jumping down a rabbit hole to beginners which for me was in a completely different language. Thanks much. ={Product link}(gngimportsus-20)

We utilize the QR Code Extension in our data base & am looking for simple automation to trigger said extension when a form is submitted.  I have all the steps down but the trigger from the automation to hit the manual button on extension. I expect its a script but Im fairly new to this platform.

Hi!following the public api of Airtable, I tried to create a new field to an existing table of an existing base. It all goes as expected though the new field that I create is hidden. I wonder if there’s a flag I need to send in the api to have the new created field not hidden, or to show fields through another api calls?Thanks! 

Hi everyone,I currently use Airtable as my backend and bubble as my web application interface.There is a plugin on Bubble to synchronize data from Bubble to Airtable quite easily through the API.But I saw that API keys will be replaced by tokens starting next year and I was wondering if you know how to use these new tokens to synchronize from Bubble to Airtable, thanks!