Development & APIs

I currently use the Airtable API connection to pull data into Google Sheets. I've gotten an automated message that the API key will no longer work in 2024. Is there a new solution that I can use? 

Hi,I am trying to generate an OAuth token via servicenow and I am running into some issues. When trying to get my OAuth token I am faced with the follow error:"error=invalid_request&error_description="state"+parameter+is+invalid.+Note+that+it+is+required.&state=-68948287"I am reading through the documentation of OAuth reference just now (OAuth reference - Airtable Web API) and see the state parameter should follow certain rules and I believe I am not breaking them with the below state value:'Jt8WzfnT7dSbXn2xL1dY.mJq3-UvN4Kz0oGcRbH6pEjViI9Xy_OgZAkCs5lPuehr' I have created a rest message and application registry record for this integration and using the 'Get OAuth Token' ui action withing servicenow to do this. If anyone can provide any help or has integrated sn with airtable using oath tokens before, tha

Hey, I have seen many people asking for amazon and airtable data connector which can help them get thier amazon seller data like inventory, sales, orders, etc into airtable. But those posts were almost year old. Does anyone needs this? I am looking to build this if there is enough demand. You can show your interest by filling your email in this form and can also ask for feature request to be included.

I work with a team and we have a field that we write notes in it (I don't like the comments section), the field type in Long text. It is very easy to accidentally delete contact from it. I want to defend it from this by demanding the user to manual saving the changes in the field, i mean like without auto save, that a user will have to hit Save button in order to modify the content. Is it possible? and if so, is there any built-in tool that i can do it with or we will need code / other external tool. By the way i know that we can Undo actions with Ctrl+Z but the problem is that we are not always notice that we've accedantlly deleting something. 

Good afternoon everyone! I’m trying to create custom currency conversions for a project I’m involved with. We’re traveling around the world selling concert tickets at the door of the venues, and each country has a different currency. I want to be able to take the ticket price for each country’s currency and convert to USD which will then be displayed on that record. I’ve seen this script is available to convert currencies, but I don’t know how to make the currency type dynamic as it only seems to show a single currency in the example. How can I edit line 7, where is says “GBP” to take the currency abbreviation from a field that exists within the record (ex, EUR,NZD,AUS). Any help is appreciated!!

Good evening,I'm at a dead end. I would like to create a way with Voiceflow to send information to each question asked by the AI. Unfortunately they put it on several lines instead of putting it on the same line, can you help me please ?  

Hi everyone!I was wondering how easy/complicated it is to have a programmer build a custom frontend for an Airtable Database. I am still looking to build a Report tool, where workers can create a Report for the day and choose from a number of project specific Tasks and document how long they worked on each task for that day. Each project specific task also has an underlaying task template and is part of a project specific task List at the same time. Basically its a bunch of tables linked with each other and then in the End I can see how long each task has been worked on etc. I already build the structure in Airtable and you can add contents but its obviously not userfriendly at all with the standard airtable interface. Now if I hire someone to build a custom frontend build for this, is that something thats doable relatively easy or is it just going to be a giant pain in the ass for whoever builds it? 

Hello! I am trying to use Make.com to connect to another company's airtable base for read-only purposes. The company that owns the airtable account is a client of mine.  Thus, I believe I need to use the OAuth method with a client ID (and a secret? I don't think the secret is necessary?). We also tried connecting make.com with a client id + a secret, no luck either.I receive the error This third-party app failed to properly construct a request to Airtable: invalid client_id or mismatched redirect_uri.I opened make.com in an incognito window. now, when I try to connect in the same way, a new browser tab automatically opens and redirects to airtable.com login. this also doesn't do me any good as I'm trying to connect to my client's airtable base via API.In the Airtable developer hub, the client has registered a new oauth, provided me the client ID, and added the redirect URL that make.com requires:

I am trying to set up an OAuth for Make, as API keys are no longer available to use, and it says not to give Personal Access Tokens to third party companies.I do not understand what the 'OAuth redirect URL' is supposed to be, at the moment I have tried the web address for Airtable https://www.airtable.com/, https://airtable.com/oauth2/v1/authorize, the web address for my Airtable base, but no luck. I'm not sure if this is the issue?I have used the same name and have copy and pasted the client ID (deleted from the screenshot for privacy).The error message I am getting is: This third-party app failed to properly construct a request to Airtable: invalid client_id or mismatched redirect_uriPlease can someone help?I have used API

Hello all – Is there yet a way to access (i.e. read/write/update) a record’s fly-out comments via the API? We have another app in which there are comments that we want to merge with the appropriate record’s comments in AT. If not, is it anywhere on the roadmap? It totally affects how we plan this integration. Thanks!

Hi,I'm really wrestling with finding a solution here and I am sure I am not the only one who has the issue.  I have 2 tables in Airtable:1) Skills Table - fields include SkillId, Name, Description, Link to Skill Definition table via DefinitionId2) Skill Definition Table - fields include DefinitionId, Definition, Level (Level is either Beginner, Intermediate or Expert)When I call the API and GET a skill from the Skill Table I would like the Skill Definition to nest as an object in the response.  I noticed this behavior is possible with the Collaborator type, shown below for the Assigned fieldAt the moment when I link the Skills Definition table to the Skills table and add lookup columns from the Skills Definition table, then call the API from Postman, the fields are shown in a flat structure as an array

I would like to ingest Airtable data into backstage. Frankly I'm shocked this doesn't already exist. I am currently building a plugin to facilitate this. If anyone wants to have an input, please reach out to me at hanfordn35@gmail.com.

I am trying to create a script using curl which basically would download the image from the url embedded within the field of the JSON I downloaded with the API. curl is supposed to use the whole value of the key `url`(https://v5.airtableusercontent.com/v3/u/29/29/1716998400000/APymLz9oGAW4AZ1vM_9z3w/53CMUJ...) + the value of the `filename` (SKM_36722071214070ff.pdf) and then the desired output name of the file. It would be the same that browsing the url + filename, but when passing just the url to the browser it displays the attachments as the are in the Airtable field, but if I add url + filename in the form url/filename it doesn't displays the file. Is there any other

Hi! It seems like the OAuth refresh flow randomly fails for no apparent reason even though nothing has changed. It doesn't happen predictably, it's quite random and this forces our users to re-authenticate Airtable which is a lot of friction. Has anyone else experienced this or found workarounds?Thanks!

i'm tryng to create a record in a table from base "B" by running a scritp from base "A"but how can i get the table from base B in my script that is in base A?

I'M TRYING TO UPLOAD PDF FILES TO AN AIRTABLE BASE USING PYTHON, BUT I'M FACING ISSUES WITH THE PROCESS. I'VE TRIED MULTIPLE PYTHON LIBRARIES, BUT NONE OF THEM SEEM TO WORK CORRECTLY FOR MY USE CASE. Here's the code I've been using (replace with your latest code snippet): import osimport globfrom airtable import Airtable # Configure Airtable connectionairtable = Airtable('base_id', 'Table 8', api_key='api_key') # Path to the folder containing PDFspdf_folder = r"C:\Users\camip\Desktop\_adjuntos_prueba" 

Hi. In the past week, I started getting random "[500] Server error" when calling various Airtable modules via Make. No other information is provided. If I retry the scenario, usually then it works.Any idea what this could be? Could it be that I'm hitting some kind of limit? According to this page (https://airtable.com/developers/web/api/rate-limits), it says the error code in case of a limit should be 429 not 500. Screenshot below shows an example of the error. Note that it is not happening only on one type of module like 'Update a Record', but even say 'Get a Record' or Search.

¿Como puedo hacer para que despues de guardar un archivo, sea descargado en mi disco local, utilizando PyAirtable?El siguiente codigo muestra el comando para guardarlo, pero ¿Como puedo descargarlo mediante PyAirtable? archivo='https://archivos.ujat.mx/pagina2020/index/divisiones/dacsyh.png'#Ingresar Datostable.create({'id_division': 'DAViS',                    'nombre': 'Division Academica De Soporte',                    'ubicacion': 'Cunduacan',  &nbsp

I have 2 bases (Payments and Ledger)And on Ledger base i have a sync table from Payments baseI'm making a script that runs on a table in the Ledger database. This script will create a record in the Payments base and then link that record to a table in the Ledger base.But I'm having problems because the synchronization table has a different ID and recordID than the original table in the Payments base.If I pass the recordID from the Payments base to link it to the table in the Ledger base, will that work?

We see that from last three days we are frequently getting 502 Error in spite of no changes on the URL and how we retrieve the data from airtable.It's even seen that Api calls are working for some time of the day and failing for some cases.We would like to know from community what and all trouble shooting can be done.Troubleshooting done.1. Called the API locally and it's working fine.2. Checked the number of calls as well its well in limit only of the Teams subscription.

Ever since personal token system came in Airtable, my data is not showing in Kodular. I have tried everything, tried putting personal token instead of api key but got no result, can't understand where is the problem. 

Does anyone know of documentation that has an example of creating each field type using Node.js?There are certain field types I am running into issues with such as date fields and currency fields and I can not find much documentation of when an example for each field completed looks like.

Hi, we are configuring a new OAuth App, and would like to configure multiple redirect URLs.Is that supported? Can we provide multiple URLs? Thanks

The past week or so, we have experienced intermittent issues with the Jotform + Airtable integration.1. Some Jotform submissions indicate they were successfully sent to Airtable, and never showed up in Airtable.2. Fields that contain more than one attached file (like multiple photos) are only sending over the first file.In both cases, the integration log shows success. It is not every submission, just some of them, making it hard for me to troubleshoot the problem.

I'm trying to filter my extract by the bank that the user select, but i'm always getting null.What am i doing wrong?const extract = await Extract.selectRecordsAsync({    fields: ["Name", "Data", "Valor", "Bank"]}).then(query => query.records)let bank = await input.recordAsync(