Development & APIs

Hi,I'm attempting to locate a know record with an email address containing a "+".  I've tried introducing a '\' and '\\' before the '+' to no avail.  Tried CURL with your API encoder, no luck.CURL EXAMPLE:curl -H "Authorization: Bearer patZZZZZZ" https://api.airtable.com/v0/appXXXXX/tblYYYYY? filterByFormula=%7BEmail%7D%3D%22bob%5C%2B1%40gmail.com%22I can get results with an email without a '+' character in nodeJS and CURL.How do I specify a filter that enables the retrieval of a record by email address containing a plus?  This does NOT work:const header = {   maxRecords: 1,   filterByFormula: `{Email}="${email}"`,   fields: [      "Record ID"   ],   view: "BulkEmail"} 

Hey, I plan to use an Airtable form for my event’s registrations. Can I add Stripe into Airtable forms (directly, without Zapier), to help users make ticket payments for the event? Thanks, in advance!

Hi there,I understand that Airtable webhooks have this limitation:The number of webhooks per base is limited to 10. A single OAuth integration can create up to 2 webhooks per base.In a nutshell, users of our integration are creating automations picking Base and Table, and configuring what they want to happen when an event is received. Meaning, a user may build 5 automations for the same Base, which obviously conflicts with the above limitation; however, our users aren't and shouldn't be bothered w/ these API limitations.In order to mitigate this, I'd like to register notifications to a Base (and all, or all relevant tables within that Base), and would then like to broadcast events that I receive from Airtable to the interested consumers. A problem here is that the event payload only contains `base.id` and `webhook.id` (along w a timestamp and the content-mac header). That's pretty unfortunate, as it prevents me from doing that broadcast.Is there a chance we could have the table.id spec

Currently, I need to integrate my app with Airtable, my customer can connect Oauth with Airtable and sync data from my app to Airtable view calendar. I need to get a list workspaceId to create a new base or table, but I only can get workspaceId with enterprise API, I am a little confused should I buy plan enterprise with my account developer or do all my customers need to have an enterprise account?

I'm so stumped on this. I've been creating automation to autolink my records, but now I have a messy array field and I cannot for the life of me figure out how to autolink it. I've tried six ways from Sunday using all the code available here. Here's the code I've been using: //Define the main table and query let mainTbl = base.getTable("BIOD CALC"); let mainQuery = await mainTbl.selectRecordsAsync(); //Define link table and query let linkTbl = base.getTable("ECO ↔ CREDIT"); let linkQuery = await linkTbl.selectRecordsAsync(); //Loop through the records and find the field to update for (let mainRecord of mainQuery.records) { let mainId = mainRecord.getCellValue("ECO ↔ CREDIT"); //Loop through linked table and match ID values for (let linkRecord of linkQuery.records) { if (linkRecord.getCellValue("eco_id") === mainId) { //Update field mainTbl.updateRecordAsync(mainRecord, { 'ECO ↔ CREDIT': [{id: linkRecord.id}]

Hi, I’m looking to build MVP using Airtable. So, I would create Airtable form where customer would choose answers. After form is filled based on the answers, at the end of the form customer should see XY amount. Customer should be able to pay that amount via PayPal or Stripe. Is something like this possible to do with Airtable? Thank you for help.

I've just read that there will a limit of 1000 calls per month to the API... I use the API on several base to expose data on small website but I can't find where is current state of those usages... So I can't have any idea about my monthly number of calls - How can I check this ? There are statistics of items in base, automations, users... but where is the API consumption state ?Thank you.

Hi! I'm building an extension and I need to make sure that now that is done everything is working like it should. I need to test it but I was wondering if there's any way I can test it live or upload a beta version? 

Hello, I am trying to integrate with AWS, but I keep getting the issue of “Missing Authentication Token” when running my script to update records onto my AWS DynamoDB. I am following the guide given by Airtable on how to integrate this. Has anyone had a similar issue? Thank you, Sahith

If anyone from airtable is reading this my extension was submitted several weeks ago and I've heard nothing so far. thanks. No reply from the reply address I was given when submitting it.

Looking at the great PowerShell community posts on GitHub, I cannot find an example of a JSON body formatted for Airtable for multiple records. the following CURL works, APIkey removed. While I can format the JSON Airtable likes for a single record in the payload, I cannot seem to get the script write to wrap the JSON with the "records";[ values that Airtable wants. I currently am trying the following in Powershell but the JSON is not formatted correctly. Any tips?  Depth 3 is works for a single record. #now wrap with fields value Airtable wants[PSCustomObject]$AirtableRecordsWrap = @{records = $AirtableWrap}# Convert the object to a JSON string depth of 3 is required to get extra '$jsonBody = $AirtableRecordsWrap | ConvertTo-Json -Depth 4  ============this CURL script will work, with API removed====================curl -X POST https://api.airtable.com/v0/appQxHpZdplpm8i6V/IPConnections -H "Authorization: Bearer [APIKEY]" -H "Content-Type: application/json" --d

All of sudden this morning, when I logged on to my base, I realised all of my PDF attachments are gone. Instead the cell displays a broken picture logo.  How do I get the attachments back, this is very important to me.

Hello! I’m trying to put together node js logic to find record ids for two concatenated fields as the key field. I’ve gotten through my issues of having commas in my search strings, but now I have compound issues with both commas and single quotes in my strings. I’m ending up with a filterbyformula variable that looks like this: {Song ID} = ‘“A Midsummer’s Breeze”-“Meditations for Relaxation, Vol. 1”’ My logic has found both the single quote and the comma, enclosed both of the constituent pieces in double quotes and then enclosed the entire string in single quote. Airtable doesn’t like this and cannot find the record. In the DB, the record looks like this: A Midsummer’s Breeze-“Meditations for Relaxation, Vol. 1” Before I make myself nuts trying to suss out a solution, I thought I would ask you trustworthy and kind fellow coders… Thanks in advance for any help! Cindy

I am trying to replace some code in Excel VBA that used API Key with a Personal Access Token. But when i just replace the API key with the new Token ID. It does not work, as in it fails in connecting to the airtable.Set objhttp = CreateObject("MSXML2.XMLHTTP")url = "https://api.airtable.com/v0/BASE ID/FSRates?api_key=API_KEY"objhttp.Open "GET", url, Falseobjhttp.SetRequestHeader "Content-Type", "application/json"objhttp.SetRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"objhttp.Send ("")UCase (objhttp.ResponseText)Dim json As ObjectDim usermatch As Booleanusermatch = FalseSet json = JSONTools.ParseJson(objhttp.ResponseText) ' root arrayjsncnt = json("records").countDim rng, cell As RangeFor i = 1 To jsncntSheet57.Range("a" & i + 1).value = json("records")(i)("fields")("Title")Sheet57.Range("b" & i + 1).value = json("records")(i)("fields")("Base")Sheet57.Range("c" & i + 1).value = json("records")(i)("fields")("SellRate")Sheet57.Range("d" &

I have written a guide for this and explained the difference between API Key and Personal Access Tokens. I speak a little bit about scopes too. I thought it may be useful here:https://www.csvgetter.com/blog/airtable-api-key-deprecation 

Hello everyone and Happy New Year,I have a few tables in my bases which get updated on a nightly basis, via airflow jobs. I would like to lock some of  those columns down so only certain users can modify the contents, but that would mean I'd need to have Airflow as one of these approved 'users' so the nightly update jobs can continue. How would I go about adding a user for a 3rd party service like Airflow?Thank you in advance!     

Hello 👋I am trying implementing Airtable OAuth flow for the first time.So far I'm pointing my OAuth application back to localhost. But I am getting stuck on this view: I can't Grant access here and there's a failed request in the network tab with error "You are not permitted to perform this operation".It seems like something is going wrong on Airtable side, because the user should have permissions to bases that they select in the select box, and also the error is hidden in the console and not printed in UI in any way.I can share CLIENT_ID if that is helpful.Thank you for any advice here!

Greetings!  New to Airtable.I have a survey table that I need to load blank records (roughly ~120 records for every new survey).I currently have automations set to add records one by one - it's a major pain.Is there a way to write a script to (1) load "seed" records from a table in my base and then (2) add them to my survey table? 

Hi, I need a script to detect duplicates in a list with many records (15k+), I need the records column to work as a flag and that by means of a text or a checkbox notify me if I am adding any mail that is already above. The idea would be a real time process as fast and efficient as possible, that when someone finishes copying the new mail it will notify me if it is already up there Thanks!

Hi, I’m trying to fetch all my table records that has a 500 columns inside but in this json result view it only fetch a random of 100 records in my existing table. Here is my code. Thank you //base1 const MY_API_KEY = “API_KEY”; const AIRTABLE_BASE = “BASE_2”; //base 2 const results = await remoteFetchAsync(AIRTABLE_BASE+?api_key=${MY_API_KEY}) const data = await results.json() // for(let view of data.fields){ // console.log(view); // } console.log(data);

I hope this message finds you well. I am a graduate student working on a time-sensitive project that involves creating an app using Figma, Bravo Studio, and Airtable. I've successfully designed the interface in Figma, transferred it to Bravo Studio, and set up the API on Airtable. However, I am currently facing critical integration challenges and would greatly appreciate your insights and assistance.The main issues I'm encountering are:1. Get Request for Details: I've successfully implemented the get request for a list, but I'm struggling to make it work for details in Bravo Studio. When attempting to retrieve detailed information for a selected item, it consistently displays all items from the database rather than the specific details of the chosen one.2. Post Request: Despite ensuring the correctness of the bearer token, the post request consistently fails. This is a crucial aspect of the app's functionality, and I need a quick resolution as my deadline is approaching.I am reaching o

 HiI currently hold an account with make.com and I've been eager to set up some automation using Airtable. However, I've encountered a recurring issue where, upon utilizing make.com for various scenarios, I consistently encounter the error message "Waiting for server."Despite trying to replicate processes outlined in multiple YouTube videos—where others seem to achieve success through copy-pasting—I remain frustrated as I'm unable to progress beyond this roadblock. The lack of a proper response or guidance has left me feeling stuck, without a clear understanding of why this error is occurring or how to resolve it.I was wondering if anyone within the community has encountered or is familiar with this issue, as I'm convinced it's a significant hurdle that requires attention.Your prompt assistance or any insights would be immensely appreciated.Thank you for your time and consideration.Warm regards,Olivier 

Hi,I am trying to register my localhost rest API endpoint as a notification URL for the Airtable webhook. I am hitting a roadblock with the server sending the following response: [body] => {"error":{"type":"INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message":"Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct."}}[raw] => HTTP/1.1 403 ForbiddenNow my questions are:1) Can we register our localhost endpoint as a notification URL?2) I am using the pated below php code. Is it a problem with the code?$headers = array('Content-Type' => 'application/json','Authorization' => 'Bearer ' . $airtable_api_key,);$body = wp_json_encode(array('notificationUrl' => $webhook_url,'specification' => array('options' => array('filters' => array('dataTypes' => array( 'tableData' ),'recordChangeScope' => 'tblgR4tt66WVctY11',),),),));$response = wp_remot

Schedule repetition frequency of a transaction or event based (daily, monthly or yearly). Kindly provide suggestions or feedbacks for improvements. Especially, I want to workout more edge case issues. // Query for every record in “Table” let table = base.getTable(“Table”); let query = await table.selectRecordsAsync(); let srcDtl = await input.recordAsync(‘Select the row to repeat?’,table); if (srcDtl) { // Begin logic of creating repetitive transactions // Replace ‘Field’ with name of the field in your table let field = srcDtl.getCellValueAsString(‘Field’); output.markdown("#### You selected “”+field+"" as the source budget"); // Display frequency options let freq = await input.buttonsAsync('Frequency',['Daily','Monthly','Yearly']); // Replace 'Date' with date field in your table let srcDate=new Date(srcDtl.getCellValue("Date")); let nextDate = new Date(srcDtl.getCellValue("Date")); let ctr=0; // Obtain how many times the operation is to be repeated let freqLen = await input.textAsy

DEAR ALL,Column type "link to another record" with "Limit record selection to a view"✔️When you try to select a value manually, the list is OK⛔When you copy/paste a value which is not in the list/view, it works ! Why ?BR