Development & APIs

Hi All,I'm juste trying to write a small script in node js to get a list of a db I have here in Airtable.As the documentation said, I've used https://www.npmjs.com/package/airtableand my code is as follow :  import Airtable from 'airtable'; const baseId = '****'; const tableIdOrName = '****'; Airtable.configure({ apiKey: **** }) const airtable = new Airtable({endpointUrl: `https://api.airtable.com/v0/${baseId}`}); console.log("airtable",airtable); ==>>> {} console.log("airtable",airtable.getTable("tableIdOrName")); ==> "TypeError: airtable.getTable is not a function" Thank you for your help!

I prepared an api script (with the baseId, tableId and the token). I tried to run it on a console and I get error massage. We should I run it?

Does anyone know whether the Webhook API contributes to the new API limits on the Free/Team plans? 

Hi everyone! We're excited to release a new feature into beta: the Sync API.It's a new sync integration that accepts CSV-formatted data through our REST API. We're hoping this makes it easier to plug in data sources that Airtable doesn't natively support.Developer documentation is available here. Usage limits are currently 10,000 rows/500 columns/2 MB per request, rate-limited to 1 request/10 min.Sync API is available as a table sync source right now - tucked away under "more sources" in this menu. A full setup guide is available here.

Hello, I'm trying to integrate Airtable with the Flexera SaaS Manager tool to capture details regarding usage and license in Flexera. I went through the steps of generating a token and landed on a page that says I need to grant Flexera Access. However, the "Grant Access" is not active - or if I click on it nothing loads. Can someone please help me? 

I’m currently running a script that creates a set of records. There are 67 records that need to get created. Usually it works. However, sometimes only a portion of the records are created. If I run the script a second time it works. Why does this happen and how do I resolve this?

 Good afternoon,We have two databases, A and B. We need to be able to run a query that searches the Postcode Column in databse B that matches the fist 3 or 4 identifiers ( i.e. SW4) from a postcode column in Database A.Obviously a radius or top 10 closest criteria would be preferred but trying to find the best way to do this.ThanksTreena

Hello to everyone, First of all, thanks in advance for your responses. I want to make an automation via Airtable Automations that changes the content of a text record (actually, add a word at the end) when a checkbox is enabled. For that I have made a new automation, when a record matches a condition  (in this case, when this field is true) and I pretend to run a script action after that, but I don't know what to put in the script.The idea is that when the checkbox is enabled (true), the script grabs the content of the "Event" field, save it to a variable, add a word at the end (For example, "CANCELED") and in the last step update this field with the old content plus the key word. Any idea of how to do this? Thanks in advance again.

Invoke-WebRequest -Uri "https://api.airtable.com/v0/{baseId}/{tableIdOrName}?maxRecords=3&view=Grid%20view" -Headers @{"Authorization"="Bearer YOUR_SECRET_API_TOKEN"} Error Message in Windows Power ShellInvoke-WebRequest : {"error":{"type":"INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message":"Invalid permissions, or therequested model was not found. Check that both your user and your token have the required permissions, and that themodel names and/or ids are correct."}}At line:1 char:1+ Invoke-WebRequest -Uri "https://api.airtable.com/v0/{baseId} ...+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [I

Hello everyone! I use an external software to manage payments and such. When a certain action is made in that software I want to send a webhook to Airtable with the purpose of creating a new Record with information about the change in the payment software. So far so good, I have started looking at Automations for this and found the trigger 'When webhook received'. Then I got a webhook URL. What kind of Action should I choose to use? Would it be possible to just pick 'Create Record' and then pick the data from the webhook call? Or is it necessary to write a Script? The data could be something like: - Contract ID- Payment methodThanks in advance!

Hi, Is there a way to know if specific base was selected or a future bases in a workspace ?https://api.airtable.com/v0/meta/whoami endpoint provides only the selected scopes.Thanks,Davit

Hi allBeen trying to pass a simple body through to one of my tables using Metatrader 5:{ "records": [ { "fields": { "Ticket": "abc", "Notes": "Notes here" } } ] }However, it fails with the error: {"error":{"type":"INVALID_REQUEST_BODY","message":"Could not parse request body"}} I've been using webhook.site to test sending from Metatrader, and passing it through here works fine. Body recieved ok when I just switch out the URLs.I've also tested with Postman and the raw body works fine sending the raw body through to both airtable and webhooks.siteSo I've kinda backwards and forwards tested both ways to airtable but can't figure out why sending it from Metatrader is not working when using it to send to webhooks works ok.Is there any way of bug tracing this a little more or getting more info from airtable? 

Is there a way to make this interface less bulky? it's not very user friendly when looking at certain overviews to leave comments. Is it possible to make it look more like basecamp?

 GreetingsI work with MAKE and I have a very strange problem with the remove function to remove a value/array from an arrayI receive in MAKE an array of linked fields and I want to return the entire array except for one ID that I received from a separate module in MAKE for some reason it didn't workI tried to insert the ID that I want to remove manually into the remove and it did work for meI checked what the difference is between them and I saw that when I receive it from the second module it is surrounded by square brackets and when I insert it manually it is not surrounded by square brackets (meaning the square brackets make it not work...) why is this happening to me? (What's interesting... that add even if you enter with square

Hey All,I maintain a fork of one of the R packages for manipulating data in Airtable and have run into some issues while trying to create a function that uses POST to handle extremely long queries or queries with more than 22 fields and the offset values to retrieve a table with more than 100 records. See package here: https://github.com/ecohealthalliance/airtabler/tree/masterThe function in question is this one: https://github.com/ecohealthalliance/airtabler/blob/master/R/air_post.RWhen using POST, the  offset param seems to have no effect. The offset ID changes with each request. So if i have 600 records, the first offset id is "itr72y1g3QhvFAKE1/rec9RPMSRlQrWVyum", then the second is l ""itr72y1g3Qh

After creating my tokens i cant see my api keys and i have tried everything Now im trying to create an Oauth and i cant seem to get the hang. i'm Trying to get my bot to input data into airtables and also get information from the same table but i have not been able to get it to work on make.com i already figured out how to get it to my google sheet via make.com but im not able to call back information hence my need for airtables

I have written the script below to select records from one table in my base and insert them as new records in a second table.  The script is working, however it times out after running for 30 seconds.  The process is selecting and creating about 200 records.   Is there a more efficient way of writing this script so that it happens faster and doesn't hit the 30 second limit?   I've read that maybe i need to create an array so that multiple records are inserted at once, but I am brand new to scripting and not sure how to achieve this.Any updates / changes / suggestions would be most welcome!Thanks    //Script Purpose: //1. Select fields "Client" and "Client Family" from all records in the table "Client Master" //2. Using these values, create new records in the table "Bank Recs" //Define source table let table = base.getTable("Client Master"); //define fields

Hi folks,This is my first post on the forum as I'm just getting started with AirTable. I've set up a sample AirTable project to explain what I'm looking to https://airtable.com/appEMeJBL3Crynbxm/shrghnubXMunVieh1There's an "Orders" table with all of the orders we receive from customers, and the parts that we need to fulfill those orders. There's an "Inventory" table with those exact same parts listed as records/rows rather than fields/columns. I want to sum all the parts required for open orders and display them in the Inventory Table "Required For Orders" field. Then it's just a simple calculation to get a read out on whether or not I have enough parts in inventory to fulfill the order. My actual process has about 60 parts and hundreds of orders, but if I can figure out how to do the above it should be the same to set i

Hi there,I would need some help. I have entries with a field "Description" this field contains a lot of text (coming from calendar entries). Part of the text is the name of a store. it's the words after "Name des Stores: ". I need to extract these words and make them available for the next action. Any help is highly appreciated!!thx!!!!!

Hello,I would like to develop a script using scripting extension that would take 2min to run. Is it possible to schedule this script to run in every 5 min? If I schedule using this method there will be a 30 sec runtime limitation?https://support.airtable.com/docs/at-a-scheduled-time-automation-triggerThanks.

I can't seem to get a valid access token in Airtable based on JavaScript code that works in a Google Apps Script. Here is the working code:  var clientId = '...'; var clientSecret = '...'; var url = 'https://accounts.spotify.com/api/token'; var headers = { 'Authorization': 'Basic ' + Utilities.base64Encode(clientId + ':' + clientSecret) }; var payload = { 'grant_type': 'client_credentials' }; var options = { 'method': 'post', 'headers': headers, 'payload': payload }; var response = UrlFetchApp.fetch(url, options); var accessToken = JSON.parse(response.getContentText()).access_token; This code relies on objects and methods that don't exist in Airtable's automation coding environment, namely Utilities.base64encode() and UrlFetchApp.fetch(), so I have tried rewriting the script to work in Airtable. To bypass an encoding method, I simply encoded the clientId and clientSecret manually and substitute

I’m using the scripting app to send data via API request to another application. It’s currently functioning, and the other application is able to take the data and perform as required. However, I’m having trouble getting a response from the API request that doesn’t timeout. It works for one or two records, but beyond that it’ll return a Request Timeout error. Surprisingly, the code does wait for the function to be fully performed (I get a loading icon), but the response information doesn’t seem to be waiting. Is this a limitation with remoteFetchAsync/Airtable or is something wrong with my implementation? Related code: (I’ve replaced the URL and header/x-functions-key with dummy strings): const stringifiedData = JSON.stringify(data); const url = "private_url"; const requestOptions = { method: "POST", headers: { "Content-Type": "application/json", "x-functions-key": "private_key", }

I keep getting to the point where I have no errors, but its still not working, I need help// Personal Access Token const token = 'pathr64Bev1PpaiJH.90e1e914f174f02f52979575ca3b30053bf32953f6727af49891b97a2a0c6f57'; // Base and Table Information const baseId = 'appNQ88GsYacjfeij'; // Your Airtable base ID const sourceTable = 'tblho4tbUAGTxgcB4'; // Replace with the source table name const destinationTable = 'tbl596fVOoOn3g2y2';// Replace with the destination table name // Fetch function for making API requests async function fetchAirtableData(url) { try { const response = await fetch(url, { headers: { Authorization: `Bearer ${token}` } }); if (!response.ok) { throw new Error(`Failed to fetch data from Airtable. Status: ${response.status} ${response.statusText}`); } return response.json(); } catch (error) { throw new Error(`Failed to fetch data from

I have setup my new personal api token in Airtable and have followed the instructions for accessing it via GET call in Voiceflow yet my token refuses to grant data access to Voiceflow.   I'm fairly new to API calls so it could be that I'm missing some detail here.  I have included images showing all the steps I've followed and what information I'm using.  If there is anyone else that is having success with this, I would love any advice you can provide.  Thank you in advance!

Hello!We are attempting to connect using OAuth 2 but the development team says they are not getting any answers from Airtable.We are being asked to login first - which we do, succesfully.Afterwards, we are being asked to select the base and be granted access.That's fine but after we click Grant Access, nothing happens. The team expects to receive a code of some sort.Would you kindly help me out?Thanks,Andrei