Development & APIs

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

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 quic

 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('d

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 m

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

Hello,Can anyone help me?I'm trying to get the data from Airtable by using this scripthttps://github.com/sleiman/airtable-phpHere's the code<?phprequire 'vendor/autoload.php';$apiKey = 'tokenFromAirTableMyAccountSection';$database = 'AirtableTest';$tableName = 'Data';use TANIOS\Airtable\Airtable;$airtable = new Airtable(array(    'api_key'   => $apiKey

So if you have an Airtable Enterprise account and issue personal access tokens (PATs) tied to a service account.  Apparently, once you create 100 PATs, the interface WILL NOT let you issue any additional PATs tied to that service account:Honestly, this seems very arbitrary.  The workaround is to create *another* separate service account to issue new PATs, but this seems very, very janky.I don't understand why Airtable gates the max number of PATs per service account to 100 total, but it is what it is.  This is mildly annoying.  FYI. 

Hi, I have a client that uses an app working on a Firebird database. I'd like to develop new tools using airtable, connecting to the Firebird DB to extract data. How can I do it?Thanks! Frede

When automating from Airtable, all day outlook calendar events show as busy not free.Why is this basic functionality not available? It's causing issues for our organisation as users are not able to book time when we have an all day reminder from air-table. Other platforms like zapier etc have the ability to alter the state of 'show-as'.Is there anything in place to fix this?

How do I delete this orphaned sync?The original target table in Prospects is gone.

Hello all,I'm developing integrations with other third party providers where I can supply a URL and they ingest that information. However, I was told there were errors with the image.On investigation, the "type" provided by the API (image/jpeg). However, the HTTP Content type is actually binary (application/octet-stream) and the filename is inlined in the content-disposition. I understand this may have been used for file downloads, but this post seems to think this isn't necessary. This seems more like a bug, as really the "type" is provided by the API, so I'm not sure its not set b the content-type. Would this ask be possible? I've been running into this issue several times. My

Thought it's worth flagging the localhost security issue in Chrome again:I've tried setting various flags in Chrome without any luck. Am developing in Safari on Mac for now.

Hi everyone,I hope this message finds you well. I recently accomplished the successful synchronization of my Airtable base with my WordPress site using the Air WP Sync plugin. During this process, I also had to integrate Advanced Custom Fields (ACF).To map the content from my base, I utilized the custom field option within the plugin, and it worked seamlessly. However, when dealing with multiple selection type data from Airtable, I needed to convert it to checkboxes.Here's where I could use some assistance: I am unsure how to effectively utilize the selected options from these checkboxes. It seems that the plugin only compares labels, and I am unable to find any ID or value associated with the selections. I need to perform a verification of the received data but cannot rely solely on the label text.If anyone has experience or insights into working with the data received in WordPress through Air WP Sync, I would greatly appreciate your guidance.Than

Preamble: I’m still working on implementing some features in the Scripting/Custom blocks which I think would remove the need for most of the Airtable API calls the proxy server is making. But even with custom blocks, I think I will still need a “get records for base” call that needs authentication. Setup: Node.js app (12.x), Airtable.js (0.8.1). API key stored in .env file that’s loaded into process.env. My application relies on a setup like @Bill.French described here where there is a central “directory” that has a record per Airtable base. My proxy server can return a list of these records, which in turn gives me the Base ID to make CRUD calls to that individual base. This works great and performs cross-base operations that suit my need. The question: Until now, authentication hasn’t been much of a c

Trying to figure a code flow so that i can move some automation away from zapier and have them automated in scripting. the 1pm in delay just make it doesn’t work for our team.

Hi,I've been trying to learn and build a script with the help of ChatGPT. The script creates a report in Clockify and all works fine until I replace the value input variable from a fixed value to a feiled in the base from a previous step. The value is just a string but is actually a lookup from another table. I've tried to use a formula in another field and use that but both result in the error seen in the screen shot.I feel like I'm so close, any advise ?  

I am using a design tool (DBSchema) that can connect to most Databases in the industry, it typically uses a JDBC connection but has many others.  Does anyone know what drivers AIRtable uses and what the JDBC URL would look like?I could not find this in any documentation.Thanks in advance