Development & APIs

HEy All I’m trying to create a CURL API request that Searches for records that are {WEEK} = “24” AND{PAGE} contains “22”. My PAGE field is a look up so it might have more than one page number in it. If PAGE has one one record in it I can use filterByFormula=AND(%7BWEEK%7D%3D%2224%22%2C%7BPAGE%7D%3D%2222%22) I think I need to use SEARCH or FIND but I cant work out the syntax. Thanks in aadvance

Hi, I’m struggling with the Airtable API, I’d like to download the content of one table, all 3k+ records and save them as a csv file using python (I can’t code JS). My issue is that while trying to connect to Airtable Base and trying to get the first 100 records, I get blocked by a user authentication challenge page and get returned a 403 response saying. Our systems have detected unusual traffic from your computer network. Please help us with a quick security check to validate it’s you sending this request. This may be happening because: Javascript is disabled or blocked by an extension (ad blockers for example) Your browser does not support cookies Please check your settings to ensure Javascript and cookies are enabled that are not from loading in your browser. It’s actually referring to this user authentication page: Airtable User Authentication Challenge Page | Airtable Support Here’s my code: import requests import pandas as pd # Environment Variables AIRTABLE_BASE_ID = "appxxxx.

Hello everyone, I have a table Company and a table Benefits. Company has many Benefits. When I get the list of linked records (Benefits) from a Company record (trigger by update), it gives me an array of the linked records but with its name. I would like to get the array but with ids instead. I use the input variables interface to get the fields Benefits (relation) in my Company record. There is a way to get this array of benefits by id within the interface or do I need to code in the script (beginner in scripting) ? Thank you so much for your help!

First, I want to say I am new to JavaScript so I could be doing something obviously wrong. I have a table that has user emails, and then linked fields to each “assignment” they submit. That is connected with an automation, when they submit a form, it links the record. Now, I am trying to assign points to each user, with each assignment having a different point value. let table = base.getTable("Assignment Tracker"); let query = await table.selectRecordsAsync(); for(let i = 0; i < query.records.length-1; i++){ let cohort = query.records[i].getCellValueAsString('Cohort (from Students)'); let email = query.records[i].getCellValue("Student Username (Email)"); let points = 0; // I have more activities than this, just putting it here so you can see how each is structured. if(query.records[i].getCellValue("(1) Cold Intro Call")) points = points + 15; if(query.records[i].getCellValue("(1) Free to Paid")) points = points + 3; console.log(email + " " + points

I’m fetching XML data text() but am running into a dead end when trying to find a way to parse the data. I tried using domparser and a few different functions I found on StackOverflow but most seem to require a non-native library. Does anyone have any suggestions on either how to parse XML in vanilla javascript or how to convert XML into JSON? For reference when using let parser = new DOMParser(); I get “ReferenceError: DOMParser is not defined”

I operate a booking system in Airtable and I have to generate months of recurring dates/times (one per record) in advance. Click, hold, dragging date sequences is very helpful in this regard (see: Quickly filling cells using fill handle – Airtable Support) However, I’m left wanting more. I’d like to create a script or automation to generate the recurring dates/records for me. As an example, let’s say I was teaching a yoga class every Mon, Tue, Thurs, and Sat at 1 pm and 4 pm. Instead of having to continually check my dates, then drag out hundreds of dates/records manually, I’d like to write a script or automation that would do it for me, thereby ensuring that the timeslots/records for the said class were always created several months in advance. Has anyone solved a similar problem to this one? Does anyone have any thoughts as to how I should approach a solution? I could imagine an Airtable app that had similar options to the “create recurring event” modal used by google calendars.

Hello! I am new to scripting. I am trying to replicate the action that is being performed on the variable below: “ :writing_hand: CREATE: Product Input”: [{id:${inputConfig.productInputName[i]}}], for: “ :writing_hand: ADD: Input Qty (Mass per Unit)”: [{id:${inputConfig.InputQty[i]}}] But failing, I believe because InputQty is a string of numbers (but formatted as a string) and the receiving field is a number field. What is the best way to convert from string to number?

I am sure this has been asked before, I have searched high and low, and have found no solution to do the following, even with Zapier. I have a .csv file that I want to import direct to Airtable. The .csv was created programatically (in Node.js), and exists on a Google Cloud VM (Red Hat Linux). There is nothing in the AirTable API that allows for direct insertion of a full CSV as a new tab in an existing base. I want to name the tab in the existing base the same name as the CSV file, without the .csv extension. If anyone has actually done this successfully, and smoothly, please respond. The only articles I can find on how to import a CSV to AirTable involve a human being and clicking in the browser.

I am building out a road trip planner and would like to calculate the distance between two inputted addresses in: Driving Miles Driving Hours I plan to set up a Button Field connected to this script, so every time I add a new stop along the route, I can manually run the script to determine driving distance and time (recorded in 2 separate fields) between the new stop and the previous one. There are a number of examples using the Script Editor in Google Spreadsheets alongside the Google Maps API: *Using the Google Maps Distance Matrix API *Using Script Editor *Sample Thank you!!

Hi, When trying to call the Airtable API using python in either vs code or straight from my browser using google colab, I get stuck on the user auth challenge page. I use the request library in python to do a simple get request, see my code below. Am I missing something? I can’t write JS which is why I chose to use python instead, my goal is simply to download the table content to then upload it in another tool to have a proper BI dashboard. I also tried using Postman and got the same 403 result. import requests import pandas as pd AIRTABLE_BASE_ID = "appxxxxx..." AIRTABLE_TABLE_ID = "tblxxxxx..." AIRTABLE_VIEW_ID = "viwxxxxx..." AIRTABLE_API_KEY = "keyxxxxx..." endpoint = f"https://airtable.com/{AIRTABLE_BASE_ID}/{AIRTABLE_TABLE_ID}" headers = {"Authorization": "Bearer " + AIRTABLE_API_KEY} r = requests.get(endpoint, headers=headers) Response code: 403 text (partial): Our systems have detected unusual traffic from your computer network. Please help us with a quick security ch

I am connected the API of Airtable to Power BI but at the time of displaying the data it only shows me 100 records when the base has more than 1000 records.

I have a table with Rating field which can have value up to 7. With current API I can get value for each record, but I can’t get metadata for that field, to know possible max value. Is it possible at all?

Send Airtable email address to a newsletter platform so that it is added as a subscriber. Click Automations and add this script after “When record is created” step. The script calls a Webhook which adds the email. Optionally sends a welcome email, if configured. PS Most email platforms have a similar Webhook, just replace with the platform of your choice. let inputConfig = input.config(); var email = `${inputConfig.email}`; var name = `${inputConfig.name}`; var list = `${inputConfig.list}`; var apikey= 'insert-sensorpro-webhook-apikey'; var apicall = { "AddToList": [""], Contact: [ { "FirstName": "", "LastName": "", "PersonalEMail": "" } ], "UpdateByKey": "email", "SendWelcomeEmail": false, "SignupFormId":"00000000-0000-0000-0000-000000000000" }; apicall.Contact[0].Perso

Hello, Can I somehow export data to csv file using Scripting block? I need to generate a pretty complex csv file (with more than 100 columns) with a predefined column order, values by default and specific formatting. That is why I do not see feasible using standard “Download CSV” functionality.

I would like to know whether it is possible to get the value of a Record Function when posting a request. I get that you can use these record functions such as RECORD_ID() or LAST_MODIFIED_TIME() in a filter formula to perhaps do something like this: ‘RECORD_ID() = “recXXXXX”’. Is there a way to get the value of RECORD_ID() or LAST_MODIFIED_TIME() to be returned?. I would also like to avoid having to add a LastModifiedTime field to my records and do this purely through the API.

Hey there, I am exploring AirTable pro trial and I was wondering if there’s a way to obtain user info via API. It seems that you can only query tables using the API, am I right? Also - is the admin panel only available for enterprise users? I cannot find a way to explore admin capabilities using the free pro trial.

Hi there, I have a use case I want to test with airtable. I would like to update some .cjs files that are located on github using airtable data to update the values of certain variables. So for example, the .cjs file might have 5 variables in, and i want to send the value of these from airtable to github and update the file. the values will have been gathered from various stakeholder using airtable forms and views embebed into confluence docs. is this possible using the airatable API?

Hi everyone :wave: We are currently part of the OAuth Private beta program. We successfully set up an OAuth flow for getting the token to access the Meta API. We’re also able to create a new table and update table’s name although there is no documentation about this features here: Sign in - Airtable, so we’re wondering if this is fully supported and if it’s possible to update a table’s schema (i.e.: adding new fields and update fields type). Thanks in advance.

Guys, why don’t we have the method createViewAsync()? We can create tables now with base.createTableAsync(), but not views. It would be such handy because for each new volunteer we need a new personal view with predefined filters, and the creation of it would be very easy to put on the shoulders of Extension.

Hi all. I have a fairly quick problem. I’m a relative novice to JavaScript and coding, so forgive me if this is a silly question. I found some code that will duplicate a record and copy all fields, with the ability to exclude certain fields. I can fill in my table and exclusion fields, and it works as intended. The original thread is here: Script to duplicate a record with select fields only or create new item based on another Extensions We’re using Airtable as a PIM for clothing and we sometimes do modifications that creates a new style code. A lot of the information is the same (as it’s just a modification), but I don’t want to copy over any linked fields or certain notes on an item. I was wondering if it was possible to create a script that would let you select an item you want to modify and create a new item with select information from the base item. The links are in the same table FYI. I am looking to do exactly what was described in this post. T

I’m trying to create a certain number of new records in a table based on a number in another table. For example, if the # Field in Table A is 4, then I want to create 4 new records in Table B. Is this possible? Any idea how I’d do it with either Scripts or Automations?

From what I can tell, trying several different codes that are supposed to paginate Airtable data in Power BI, some people are getting them to work and some are still just getting 100 records. Has anyone who was just getting 100 records who has now gotten these codes to work describe what change made the code they were using work? Examples of these codes are found in these threads: JSON string only contains 100 rows when connected to Power BI Desktop API Hello! Little bit late to the party, but I got Power BI to fetch the paginated Airtable pages. What has not been implemented yet is a timout to avoid sending too many requests. Here’s the “Power Query” you’ll need: let Pagination = List.Skip(List.Generate( () => [Last_Key = "init", Counter=0], // Start Value each [Last_Key] <> null, // Condition under which the next execution will happen each [ Last_Key = try if [Counter]<1 then "" else [WebCall][Value][offset] otherwise null,// …

Hello, I see that there is an example script of deleting duplicates but I’m a little lost as to how to apply it to my table. Can someone help?

Hello, I am struggling to write the code to retreive the intersection cell of 2 dynamic entries: Lets say I have a table with: Milan Berlin Bruxelles Paris Milan Berlin Bruxelles Paris With the distances at intersection How can I retreive the distance for each user choosing one city in a row and one city in a column? Any help would be great!!

Hello! I feel like I’m so close to getting my script to run- I keep getting the following error with my below code- any ideas on this? Does it have to do with my last line as an await? let table1=base.getTable("August 1 2022 Issues- Onward"); let table2=base.getTable("Sprints-"); let junctionTable=base.getTable("August-1 Onward Sprint Junction"); let firstJunctionField=junctionTable.getField("August 1-Issues"); let secondJunctionField=junctionTable.getField("Sprints"); let joinType="left"; let tableLink=table1.getField("Sprints-"); console.log(); async function createJunction() { if (table1 === junctionTable) { output.text("First table can't be the same as the junction table."); return; } if (table2 === junctionTable) { output.text("Second table can't be the same as the junction table."); return; } if (firstJunctionField === secondJunctionField) { output.text("First junction field can't be the same as the second junction field.") } if (