Development & APIs

I am trying to create new records via airtable.js, when I try to create a new record in Link-to column with row-value (i.e. name - string not Record ID), it does not work and reply Class {error: “INVALID_RECORD_ID”, message: “Value “VALUE” is not a valid record ID.”, statusCode: 422} Is there any way to avoid this condition? or there is not “typecast” command in airtable.js ? if yes, please let me know some example, var dataCompt = { "field1": "value1(text)", "field2(Link-to column)": "value2(text)" }; function createATData(){ base(tableName).create(dataCompt, function(err, record) { if (err) { console.log(err); return; } //loadArtists(); }); }

Hi guys,I have been trying to create a simple Make.com scenario to test the waters, where an Airtable record is created from a pre-specified Etsy receipt. The first step works great, all records are pulled from Etsy's API, but when we get to Airtable, I'm getting a repeated [404] Not Found error.According to Airtable developer @EvanHahn's answer here, Airtable only returns 404s in two cases. I quote:the resource you’re fetching is missing. For example, if we can’t find the table, or the base, or the record, or whatever.the URL you’re hitting is totally bogus. For example, a request to api.airtable.com/v0/garbage will return a 404.It seems that it's getting the base, the table, and the record just right, so I assume the URL it's hitting must be correct.The error persists regardless of smart link or column ID use.Make.com gets its access via a personal access token:The connection screen looks like this: You will see that Etsy has 4 acquired permissions whereas Ai

Good morning to you,I'm trying to create dynamic ToDoLists.At first, I thought I could solve my problem by using complete NoCode (see my post).Finally, after some advice, I turned to @Giovanni_Briggs code and post.I've never coded the day before yesterday, and I'm trying to use AI tools to understand what I'm doing.I've managed to adapt the proposed code to my base and half of what I want to do works.As it happens, my code copies the tasks from my original list very well,It links the new tasks to the event we've validated internally,But it doesn't create a link between parent and child tasks (I've been tearing my hair out for 24 hours trying to solve this problem).To explain, each parent task (main task) is linked to several subtasks (child tasks).example : The Hotel taskis therefore linked to several subtasks:Hotel searchValidation of a hotel according to quotation and price/quality ratioHotel reservationHotel paymentReceipt of invoiceWhen I use my script, everything works fine except

I'm writing a script in Airtable Extensions to pull data from Canvas API. I've set the per_page limit to 100, because that's the maximum number of objects Airtable will retrieve at once for an external API.I need to use pagination to download the rest of the results. According the Canvas API reference, it's in the response header Link value. I'm able to see this in Postman but how do I retrieve this in an Airtable script? How do I set up a loop to paginate until the end? All the online discussions are about Airtable's API and I can't find how to retrieve response headers.  let currentCourses = await remoteFetchAsync("https://XXXX?per_page=100", requestOptions); const currentCoursesData = await currentCourses.json(); console.log(currentCoursesData);    

It'd be nice if we could put a photo in base's appearance, although airtable offers several options, we could have more personalized bases, making it easier to identify each one  

Hey folks, just wanted to share that we created this pipeline which is free to use.It has schema inference and evolution, so the column names and data types will automatically be normalised to fit the destination and also adapt to any additions etc.you can configure it to load fully or incrementally.If you have feedback, please join our slack and discuss there or open a git issue. Pipeline docs: https://dlthub.com/docs/dlt-ecosystem/verified-sources/airtableour slack: https://join.slack.com/t/dlthub-community/shared_invite/zt-1slox199h-HAE7EQoXmstkP_bTqal65g

I am stuck 😫I am attempting to configure a webhook, but I continue to encounter a 401 error that seems to be related to the API token. I have thoroughly reviewed all the settings and ensured that I am inputting them accurately. Additionally, I am utilizing an Airtable pro plan, and there are no other users associated with my account, so I have all the permissions. Also if I put "Bearer" in front of the token it turns into a 403 errorAny guidance would be amazing!  

Hello,since recently I've a bug with embedding's airtable on my website. it says "airtable doesn't authorize the connection".Anyone knows how to solve this bug? thanks  airtable Support hasn't been able to help me

Hi All,I am having an issue with my script:When using an integer value in the condition, the script works.Example: return all records that have a value higher than 9 in the field name "Bedroom": const propertyTable = base.getTable("Listing"); // Read the data from my Listing table const recordsFromproPertyTable = await propertyTable.selectRecordsAsync (); //Filter records matching a condition const matches = recordsFromproPertyTable.records.filter((records)=>{ return recordsFromproPertyTable.records.find((potentialmatch)=> { return records.getCellValue("Bedroom") > 9; } ) }) console.log(matches) When trying to match the field value with a single select or multiple select field, I am getting the following error:This condition will always return 'true' since the types  and 'string' have no overlap."I am pretty sure this is due to the fact that I am comparing an Array with text but I am not sure how to solve this:Return all records tha

Hello,I would like to know if changing my extension name and the dev contact is possible. I tried to find the solution in the code but didn't find any information. Do I have to recreate a new extension with the name I want? (I know I can change the extension name after but I would like to see if I could do it directly)Best regards  

Hey can you kindly tell how to generate Api key for air table . Is air table generating api keys or not? I tried every method i get a personal token but key isn’t generating. I also pasted personal token at the place of api key but it gives error 401 in voice flow

Hi, my currency script can be run manually but fails when run via automation. I'm using the standard, "recommended" currency script.  See attached image. 

I want to download attachments from one of my tables via the API locally:If I open and download the file from the UI, it seems to download them from a S3 server. Is there any way to automatize or mimic this behavior via the API?

Hiya AT community, I was hoping someone would be able to shed some light on my issue, as I haven't been able to solve this one on my own!I have a script that is performing some updates to a stocktake via a script. It will find matching items and then update the value in the number field. My confusion here is that it is working for one field and not the other field, I have tried different strategies to try and get an error or figure out why, but the field ID is defs correct and the field name used instead also produces the same result. Any advice would be appreciated 🙂I'll try add the relevant code to the issue..This if statement works as expected if (newStockMatches){ if(storageLocation == "Warehouse"){ console.log(newStockMatches.id); recordsToAddStock.push({ id: newStockMatches.id, fields: { 'FIELD ID IN STRING FORMAT': newStockMatches.getCellValue('FIELD ID IN STRING FORMAT') + qty // Warehouse fiel

Hi... I can use a little bit of help here from the experts....  We currently have a Google API integration with Airtable  on a project and we have set up routing and it is working well to create and updates routes (route records) within AT for us, but we don't know how to do 2 things we want to do:I don't know how to get an actual link back from Google Maps to the route record (we are using Make for this integration) to just show the route (waypoints) on an actual google mapI am wondering if there is any way to update the route waypoints (drag and drop on the map into a different order) and have it actually update the route records in Airtable when we adjust the route order on the actual map?

in what i am working ?i am working with a bot the bot ask questions and the response have to apered in airtable but its not working i try to fix it with a staff of botpress that is were i do the bot but they told me that it was an error of air tableconst airtableAccessToken = 'patrKShGndYDE36XQ.c35584fd7450be9fba9669453b09eac22583d3aa7d584d5b42ce7ede4da3822b';const variables = {name: workflow.name,email: workflow.email,phone: workflow.phone,budgetforproject: workflow.budgetforproject,service: workflow.service,adress: workflow.adress};const url = 'https://api.airtable.com/v0/appFWL0WUh6Sd78Im/color%20flux%2023';const headers = {Authorization: Bearer ${airtableAccessToken},'Content-Type': 'application/json'};const response = await axios.post(url, { records: [{ fields: variables }] }, { headers });console.log('Variables sent to Airtable:', variables);console.log('Airtable response:', response.data);this is the code i dont know where is the problem can someone help me

I am attempting to authorize an AirTable application to use OAuth with Matillion ETL (an orchestration tool).I am getting a an error while trying to authorize the application, related to the "state" field not being configured correctly. Can anyone help?

Hello, I am creating a json object from my airtable data to send it to a google script: //Table Bail --> xxxxx //Table Locataire --> xxxxx //Table Facturation --> xxxxx //Table Roof --> xxxx //Table Chambre --> xxxxx let url = "https://script.google.com/macros/s/XXXXXX"; const id_bail = input.config().id_bail; //Recupere l'id du bail let table_bail = base.getTable("xxxxxx"); let query_bail = await table_bail.selectRecordsAsync(); let record_bail = query_bail.getRecord(id_bail); //on filtre la base en fonction de l'id du client ////////////////////////////////////////////////////////////////////// let error_log = record_bail.getCellValue("Error_Log") let bail_statut = record_bail.getCellValue("Statut_bail") if (error_log !== null){ console.error(` Oups, une erreur est survenue: \n${error_log}`) } else if (bail_statut !== "Fini"){ //Table Roof let id_roof = record_bail.getCellValue("Roof"); //id_roof associé au bail let table_roof = base.getT

I know that there is already an automation that allows for Airtable to send SMS to Twilio, however I am looking to put together something more advanced. I want to use Twilio Studio to create a flow that would remind clients of their appointments (the client's information comes from AirTable, the date/time, and numbers come for a table) I want it to call landlines or text cell numbers to ask if they want to meet remotely, in-person, or reschedule. then i want the responses to be recorded back into AirTable under the client. How can I set this up?

 Hi, i don’t understand… maybe API KEYS BUGGED ?   

I am running a function on gform_after_submission in WordPress. It creates an new record in a large AT. We are finding more often than not the submissions works in Gravity Forms but the record is not created in AT. I have error checks in my function that makes the AT connection and it doesn't throw anything, including any error from the curl itself. It seems to leave the function formatted correctly and without error. no curl_error.This happens maybe 8 out of 10 submissions. We can find nothing different about the data in this submissions. It seems to be on the AT side of things. No one throws an errorIs there any log where I can see if these submissions make it to AT and are being rejected? I need some help on where to look next! Please and thank you.NOTE: Updating records from the same form works just fine. Never errors. It is the creation of a NEW RECORD that doesn't go.Frustrated. Jon 

hi,i am interested by the update of API key, i have some application where i linked them with some table in airtable, so for that i have this question : after January 2024 the request of getting data from the table in airtable will stop working in my app, so if that true what i need to do, i need to update my application in store or not ?

I'm attempting to setup a Webhook from Jotform to Airtable. However, I'm never able to get past the Test portion.I have:Started the Automation in Airtable, selected When webhook received.Copied the webhook URL provided by Airtable, and pasted into the Jotform Integration Webhook.Submitting the form in JotformAirtable always says This URL has not received any requests recently.I setup a webhook API on https://webhook.site/, and updated Jotform with new webhookSubmitted form again, and immediately received webhook message on https://webhook.site/.This leads me to believe that Airtable is not functioning correctly. Is there a reason why Airtable would not properly accept my webhook? Account type? Form type?

We've removed forms because me and my other users need to input info on mobile most of the time and if one makes a mistake or needs to adjust data, a form is not user friendly (submit form > realise mistake (or not) > open airtable app > find relevant table > edit). However, a spreadsheet isn't *that* user friendly on mobile either. It can be easy to miss an input column. Some columns generate information for the user as they're submitting data, so inputting data is also creating actions for the user at the same time. Therefore, not every column is an input column, and it can be easy to miss one on mobile view.This could quite easily be resolved with colour coding columns - or some way to highlight input/vital columns. It would also make certain complicated tables easier to read and interpret! I use lots of filtered views, but some tables have 15 views for interpreting data - and to be honest, I'd rather have fewer tables, with clear sections so I don't need to fl

I'm writing a script that will update my airtable dynamically with new tags that will sit in a multi-select field. I know that I can use { typecast: true } in my call to airtable, but I'm still getting an issue when updating it. I'm pretty sure the issue is either in how I've set up my object for Airtable or the placement of the { typecast: true } option. Here is the partial method that creates a record in my airtable await this.table.create( batch, // batch of records to be updated, see below for structure { typecast: true }, function (err, record) { if (err) { console.error(err); return; } console.log(record.getId()); } ); Here is the object (batch) that I'm sending through fields: { name: 'a new record', categories: [ { name: 'Item 1' }, { name: 'Item 2' }, { name: 'Item 3' }, { name: 'Item 4' },