Development & APIs

I'm creating a new extension that will automatically update records in a table based on data returned from a server API endpoint that I control.This API computes a lot of data and will take longer than 30 seconds to respond, so this can't be a normal synchronous API call.What is the best strategy for doing this in my extension? I can think of three possible ways -* Can extensions listen for webhooks, where I call an API and get a webhook back some minutes later?* Or maybe the server writes directly to the table when the data is ready - can an extension facilitate this automatically?* Alternatively, can I have my extension automatically & continuously (without user interaction) poll an endpoint every hour for new data and update the table?Thanks for your ideas!

I’ve noticed my (custom) apps are taking much longer to load lately, coinciding with a steady increase in records. The apps load records from filtered views, which don’t necessarily have a ton of records in them at a time. Would the amount of records in the whole base affect the speed of the apps, even if the apps in question aren’t loading all of the records in? Thanks!

I am working in Postman. The field in question is "Taxes Owed - PDF". I get the error shown below. If I change the field type to single-line text I don't get an error. I don't want to change the field type. How do I avoid the error?  I have also tried other values: $3333, $3333.00, 3300.00, $3,333.00TIA{    "error": {        "type": "INVALID_VALUE_FOR_COLUMN",        "message": "Field \\"Taxes Owed - PDF\\" cannot accept the provided value"    }} {    "fields": {        "Case #": "12345",        "File Date": "1/13/2024",        "Taxes Owed - PDF": "3333"    }}

In Postman I am trying to set/select the value of a single select field. This is an exsiting defined value.A simplified version of my post is:{"fields": {"Case Status": "HC - Tax Lawsuit"}}I am getting this error{    "error": {        "type": "INVALID_MULTIPLE_CHOICE_OPTIONS",        "message": "Insufficient permissions to create new select option \\"\\"HC - Tax Lawsuit\\"\\""    }} please advise

Good day all,Over the past year I have moved from the old API key to PAT successfully accessing the base from third party apps (in particular filmmaker & MAKE ) just needing the API key swapping with the new PAT ... all good.I have a couple of scripts that work on the base in question which effectively moves the records to another Archive base ... this has been working great for years. until now that I have tried to change the API key to the PAT.  It just refuses to create the record in the Archive base, Make and Filemaker both canAny assistance would be very much appreciated as I cannot see what is wrong the PAT has full access to all scopes and I'm baffled and have even tried a new PAT codeRegardsGordon

How to connect email message and SMTP inside airtable if trgigger is executed?

I have imported a table into airtable and need to trigger an email message just to companies on a certain filter like companies without a website. How to manage using airtable?*Need help.

Hello all ! (It’s my first post in this forum, if i’m not following guidelines please feel free to tell me !) I quite new in the Airtable world. I’m currentlty trying to create a script (with the script app powered by Airtable) in order to fetch data from my (test) shopify store. But here is my point : → Airtable do not allow to use the class authentication used by Shopify, which is : GET https://{username}:{password}@{shop}.myshopify.com/admin/api/2021-01/shop.json → So i need to use Basic Auth as it’s explained in theire documentation. But it’s not working, and i get this error message : “[API] Invalid API key or access token (unrecognized login or wrong password)”. Did someone ever face this issue and know how to solve it ?(I’m sur about my credentials, and i also delete and recreate my app in order to prevent this mistake). I’m surely missing something but i don’t know what it is… Here is my code : const apiKeyShopify = "MY_SHOPIFY_API_KEY"; const passwordShopify = "MY_SHOPIF

I have pasted around 500-600 URls in a column and I want to know 404 statuses of all the URLs in the Next Column or in “view Blocks” (want to know which URLs are live and which are not). I am not so good at scripting. Can You Please help?

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!