Development & APIs

Hi all - my IT team has some technical questions about Airtable that I don't know the answers to (or even really understand!). Can anyone shed light on any of the following questions?Is there AD integration for employee users?Is there 2-Factor Authentication for all users?Is the data backed up? For how long?Are the backups encrypted?Is all the technology patched and current?Is the vendor solution patched on a scheduled basis?Are critical patches applied as soon as their identified, both to the solution and to related technology?Is storage provided, and how much?Is it a Cloud/Saas solution (non on-premise-managed by vendor)?What other security measures are taken?Please provide details on the SOS verification.Thank you,Kelsey Deusterman

Hi, I'm creating an attachment via API and it shows the attachment but then gets deleted a few seconds later. Any tip on why this may be happening? Is it a bug in Airtable or the third party I'm using?  

i write this simple script, and get an error:await table.createRecordAsync({"Singal Select":"1"});Error: Field "fldVrE9PBN0HBkpRn" cannot accept the provided value.tried allsow this script:await table.createRecordAsync({"Singal Select":{name: "1"}});and same error all the premission are open...TY!

I am a business specialist for a company and I also teach workout classes for the women in our office 3 times a week. I have a fitness Airtable base where I have added all the exercises I like with a muscle group field. I am trying to find a way to automatically generate a workout to reduce the time I have to spend coming up with a set of exercises. For example, we worked chest and triceps yesterday so today I want to generate a workout that includes x number of exercises with x number being bicep workouts, x number being back workouts, and x being ab workouts.I have very minimal developer experience but I can edit and update pieces of a script if given the outline. 

Has anyone created an API between Workfront and Airtable? We currently use Airtable for project management/planning and sharing of projects, but creative requests/approvals go through Workfront… would be looking for one-way communication from Workfront to Airtable (specifically relaying dates from Workfront tasks and moving final assets/creative files from Workfront to Airtable once they are approved in the Workfront system). I’m only familiar with Zapier to connect platforms and unfortunately Workfront is not available there, so wondering if anyone has had success connecting these two with a custom API? TIA!

I have written several Scripts and an Extension. Both of these use the Base, Table, View, Record, Field classes provided by Airtable. I would now like to create a node service running in the cloud that needs to get and set information stored in Airtable. Is it possible to use the same JavaScript classes as with a Script or an Extension to access Airtable data from node? Cheers  David

Hi there,I am creating a simple extension that creates a record with an attachment. I am using createRecordAsync  from the blocks API for the record creation and the the native URL interface from the Web API to create an URL from the file loaded in by user via an `<input type="file"/>`.URL objects const handleFileChange = (e) => { (...) const newFiles = Array.from(e.target.files) const fileData = newFiles.map((file) => ({ filename: file.name, size: file.size, type: file.type, status: FILE_STATUS.LOADED, url: URL.createObjectURL(file), })) setFiles(fileData) } then (...) table.createRecordAsync([{attachment: {filename: file.filename, url: file.url}}]) A record is created successfully and I get no error or warnings, however, the file is never attached to the record. I wanted to avoid having to go through the Airtable API.  Is it possible to create an attachment directly from an extension?   Thanks,Pedro

Hey everyone! Im using a script (that I found here in the community, thanks btw!) to pull data from Airtable to Google Sheets in order to make some weekly reports for employees in a company. Problem is, it seems each time the script runs it retrieves the Fields in a random-ish order, which is a problem because those fields are referred to in the reports. Using Zapier is not an easy option since we have more than 400 fields. Here is the script var api_key = "XXXXXX"; //ADD YOUR API KEY FROM AIRTABLE HERE var baseID = "XXXXXX"; //ADD YOUR BASE ID HERE var tablesToSync_fromSheetRange = "A14:B15"; //UPDATE CELL RANGE HERE (for tables that you want to sync) ////////// add items to UI menu /////////// function onOpen(e) { SpreadsheetApp.getUi() .createMenu('Airtable to google sheets sync') .addItem('Manually sync all data', 'syncData') .addToUi(); } ////////// function to trigger the entire data syncing operation /////////// function syncData(){ //fetch table na

I'm doing an extension and I need to get some data from the table. Specifically all the records from the table or selected records, but when I go and select records it only  shows me the ids or names of the first field or "primary field". Is there a way to get all of the other ones? 

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.    Sync API is currently limited to Pro and Enterprise customers.

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) [Invoke-WebRequest], WebException+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeWebRequestCommandI tried using curl command also, curl "https://api.airtable.com/v0/{baseId}/{tableIdOrName}?maxRecords=3&view=Grid%20view" -H "Authorizat

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 brackets and if you enter without square brackets it works)  

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 ""itr72y1g3QhvFAKE2/rec9RPMSRlQrWVyum" etc. Only the Offset ID (the bit that starts with `itr`) changes, not the record. By contrast, with GET requests, only the record ID changes.here is an example of the body of a post request:  { "offset": ["itr72y1g3QhvYZw5Y/rec9

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