Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,660 Topics
  • 11,731 Replies
3660 Topics
M
Mduduzi_NdhlovuNew Participant
posted in Development & APIs
Airtable in serveless function throws "Expected signal to be an instanceof AbortSignal"

Hi all, Im trying to use airtable in netlify serverles functions. When I try to create a record, I keep getting this error “Expected signal to be an instanceof AbortSignal”. ` const { formattedReturn } = require("./helpers") const Airtable = require(“airtable”) const base = new Airtable({ apiKey: “APIKey” }).base(“BaseID”) const eventBookingTable = base(“Events”) exports.handler = async function (event, context, callback) { const newRecord = async () => { const rec = await eventBookingTable .create({ Name: “iamnotcrazy”, Event: [“recwrjfffffff”], Email: “mymomgotmetested@gmail.com”, }) .catch(err => err) return rec } try { const record = await newRecord() return formattedReturn(200, { record }) } catch (err) { return formattedReturn(500, { err: err.message }) } } `

51
M
T
Thomas_SolerNew Participant
posted in Development & APIs
Flight Tracker - ETA and Status

Hello everyone,I would like to track commercial and private flights using airtable. Ideally a flight number or tail number will be entered into a column and in two other columns the flights status and ETA will be displayed.So far there doesn't seem to be any native extensions and I have been investigate third party APIs and have yet to find a suitable match. Any recommendations or suggestions?Thank youTom

1154
E
R
rnavailleNew Participant
posted in Development & APIs
Zapier trigger on updated computed fied

Hi all, I use an airtable formula to calculate product prices. I want to use Zapier to automate the process of updating prices on my website when changes are made to prices.As I understand, Zapier wants to use the a "Last Modified Time" field as the reference to know when to trigger the action. The problem I'm having is that I'm not finding a way to point the "Last Modified Time" field at the calculated price field because AFAIK that field cannot monitor computed fields. The airtable documentation recommends pointing the "Last Modified Time" field at one of the editable fields used in the computed fields. This doesn't resolve my issue because Zapier seems to want to pull the value from the field being watched by the "Last Modified Time" field, not the computed field that I need it to. After consulting the airtable documentation I'm starting to be convinced that the workflow I have in mind is not possible (I would be happy to be wrong about that). So I'm wondering if anyone ha

41
ScottWorld
F
Francoloco23Known Participant
posted in Development & APIs
Ruling to Move Individual Records

Good day Airtable Community,I would like to ask for your assistance if there is a ruling that can be created to move records that do not have "Extracted for Ticketing" value all the way down?  Thanks

21
kuovonne
G
gislipalsNew Participant
posted in Development & APIs
Looking for a no-code frontend for PostgreSQL data entry. Am I in the wrong place?

I'm looking for an alternative to MS Access which will allow our employees to enter data through forms, with basic features like lookup tables and direct access to an AWS hosted PostgreSQL instance.Does Airtable do that? It seems like Airtable needs to ingest all data into its own 'base', but I'm really not looking to do that.If not, I'd appreciate any suggestions for data entry software.

101
BillH
E
ed_p_mayNew Participant
posted in Development & APIs
How can I work with 'Interfaces' via API?

Hi,I have an Interface I have created for one of my bases (simple summary page) - but I wonder:- Is it possible to access this Interface (and its summary data) via the AirTable API? It doesn't seem so, but maybe it is somehow?- Is it possible to embed this Interface within another site of mine via an iframe or something similar?thanks for any suggestions!@ed_p_may 

1192
E
J
Jack_ColeyNew Participant
posted in Development & APIs
Create multiple records from JSON Data

I've been trying to do this in way too many ways. I haven't figured it out ChatGPT and Bard haven't figured it out so I though I would ask actual people 😁I'm making an api call to usaspending.gov and am able to to get the information I want returned, but I can't figure out how to use the data I'm pulling down to create multiple records based on the objects returned. Has anyone run into this and how did you do it?let uei = 'PLACE-UEI';let startDate = '2023-10-01';let endDate = '2023-12-31';let data = {"filters": {"time_period": [{"start_date": startDate,"end_date": endDate}],"award_type_codes": ["A","B","C","D"],"recipient_search_text": [uei]},"fields": ["Award ID","Recipient Name","Start Date","End Date","Award Amount","Total Outlays","Description","def_codes","COVID-19 Obligations","COVID-19 Outlays","Infrastructure Obligations","Infrastructure Outlays","Awarding Agency","Awarding Sub Agency","Contract Award Type","recipient_id","prime_award_recipient_id"],"page": 1,"limi

1252
J
S
Steve48New Participant
posted in Development & APIs
Error trying to POST an attachment using API

The field in question is an Attachment field.This is what my POST looks like (from Power Automate Desktop. Note variables are enclosed in %s). The field in question is highlightedI receive this error{"error":{"type":"INVALID_ATTACHMENT_OBJECT","message":"Invalid attachment object for field Lawsuit Docs - PDF: \\"https://drive.google.com/file/d/1Y_4OYYb7NjIKremnh3aiuFFEh6smESFK/view?usp=drivesdk\""}} TIA   

110
S
D
David_SmedbergKnown Participant
posted in Development & APIs
List Interfaces / Pages via API

Hi all,I see in the API documentation that there's an endpoint which can provide information about an interface (aka page bundle, aka section).But in order to use it, I need the interface ID, and I don't know how to list the interfaces. I know that as an Enterprise admin, I can visit https://airtable.com/admin/[enterpriseId]/interfaces and search or download a CSV, but as you can imagine all that proves is that there is an actual API endpoint, I'm just not sure how to access it 🙂 Making it even more frustrating, the interface IDs aren't even available in the URL when you're browsing the interface, as far as I can tell.Does anyone know if I'm missing something and there's a way to get the page bundle IDs programmatically?PS if anyone is aware whether Airtable has shared anything about developing a more robust metadata API for interfaces (list pages, list fields and their configurations, etc) that'd be awesome. 

552
D
Vianney
VianneyNew Participant
posted in Development & APIs
How to share Web API Documentation

Hey there 👋Web API documentation generated for a particular base is very well built and very useful.I wonder how to share this API doc because the dedicated URL is not public.Thank you for helping.

70
Vianney
S
SPRCHRGR_AirtabParticipating Frequently
posted in Development & APIs
Comments on Record - Is there a way to get notified of a new comment?

Is there a way to get notified of a new comment on a record? Either through the API or within Airtable itself?

796
Y
Y
yoblinNew Participant
asked in Development & APIs
Calling async API endpoints from a custom extension?

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!

230
Y
S
Sticker_ninjaInspiring
asked in Development & APIs
Should my Airtable apps slow down as my base gets bigger?

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!

140
TheMortgageMeister
S
Steve48New Participant
asked in Development & APIs
Getting Error with POST to currency field

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"    }}

125
ScottWorld
S
Steve48New Participant
posted in Development & APIs
Getting Error in POST when trying to select dropdown value

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

131
S
G
Gordon_SzulcInspiring
posted in Development & APIs
Change Api Key to PAT

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

702
G
N
NEF1QLSZ4UInspiring
posted in Development & APIs
How to connect email message and SMTP inside airtable?

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

190
N
N
NEF1QLSZ4UInspiring
posted in Development & APIs
How to send notification e-mail messages only for companies without a website?

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.

10
N
T
Thomas_RodierNew Participant
asked in Development & APIs
Airtable Script fetching Shopify's data - Invalid Key

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

170
B
S
Sanjida_BegumNew Participant
posted in Development & APIs
Checking 404 status of all URLs in a Column

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?

647
P
S
scubachrisNew Participant
asked in Development & APIs
List records API with filterByFormula: find email address with a '+' fails (like bob+1@gmail.com)

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"} 

1130
dilipborad
V
Vinish_GargNew Participant
posted in Development & APIs
Stripe in Airtable forms

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!

92
P
M
matthias11New Participant
posted in Development & APIs
Webhooks API: table metadata?

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

220
M
A
AnhTuanITNew Participant
posted in Development & APIs
Confused about payment api

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?

00
A
D
Drea_BurbankNew Participant
posted in Development & APIs
Script to autolink an array field with an automation

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}]

297
J

Badge winners

Show all badges
Terms & Conditions