Development & APIs

I am working on an Alexa skill that executes a GET from an Airtable base where the record contains a field whose field type is Attachment. The GET in the Alexa skill assigns whatever is passed from Airtable to a variable. I don’t have a means of displaying the Alexa variable to see the contents. From the API documentation, I understand an attachment field will pass a field ID, the URL of the object and the file name of the object. Could someone provide an example of what is passed from the API using the following example: AudioField=api_response.records.0.fields.AirtableAudioFile; After execution, what is the contents of AudioField? Audiofield = ‘xxxxyyyyzzzz’ Thanks in advance for your reply!

There’s been a few recent posts about using fetch() in the new scripting block. Here’s another question/use case that’s not currently working for me. My office uses Airtable for, among other things, tracking course videos through the editing process. Videos are hosted on Vimeo and one task we do is pull in the latest runtime. This can be done easiest through Vimeo’s oEmbed API which includes a “duration” field that provides the length of a video in seconds. The problem: our videos are private and accessible through (able to be embedded on) a small whitelist of domains. Using the “old” API, this worked as I could set the referrer to our domain (the code was written in NodeJS and called the https.get() method). I’ve tried adding “airtable.com” and “api.airtable.com” to the video whitelist, but it still returns a 403 error. Some initial searches indicate this might be a CORS issue with fetch() and it may not include the right options to make the request? Or it could be a bug in the script

Hey, I’ve been looking on all the sample blocks, but couldn’t find an example of how to use the watch / unwatch functionality in a fine grained matter. Specifically, do I need to call unwatch to cleanup after I call watch and if yes, use react useEffect to do that? I don’t want to call useWatchable, because then I have to store a copy of the watchable key value in useState and compare new watchable value to current value in state and it seems like overkill. My use case involves tracking the cursor.activeViewId. Thanks, Ronen

Hey everyone! Trying to figure how to to get data from MongoDB to Airtable. Out of all the connectors/automators, Parabola seems to be the one to do the trick. However, on the final “API Export” step I am running into difficulties. I am non-CS, so maybe I am missing something super silly :grinning_face_with_sweat: Parabola asks for the following: Request Type API Endpoint URL Body Max Requests per minutes Authentication Type Bearer Token Here’s what I did: Opened the Airtable API page for the corresponding base. Copied the Endpoint URL from the top of the cURL interface Copied the snippet of code starting after "fields": into the Body { "User ID": "{id}", "First Name": "{first}", "Last Name": "{last}", "Email": "{email}", "Business ID": [ "{business}" ] } Inserted the Parabola values with {} (all strings) Found my API key and put that into the Bearer Token Testing things in Parabola works. However, when I publish the flow and run it, I get a 422

In my data science work, I often need to find outliers. There are many ways to do this and one might think it can be done reliably using a simple filter - e.g., Show me anything that falls outside this range. This assumes (a) you know the correct range of outliers, and (b) the context for the range is never likely to change. In practice, your data will prove you wrong about these assumptions time and time-again. In cases where transaction flow is small, a quick scan will usually suffice to see if your data passes the sniff-test. But when you have many thousands of records and dozens of fields to consider, you might want to audit your data with powerful statistical analysis. Ideally, you need a process that can learn based on all of the data available and apply its rules consistently, even when you’re not in the room. To that end, here’s a script block that uses the multiple interquartile methodology to find outliers. Once again, this is a pretty good use of a Script Block because doi

Hi, I’m tryin to do api-request with “filterByFormula”. I want to filter by date and to filter by range. I tried something like that, but it doenst work (Gettin no records): AND((DATUM) >= “02-01-2020”, (DATUM) <= “02-31-2020”) How do i have to implement this kind of filter? Thanks for your help!

Hi - not sure if I’m doing something odd here, but I cannot get fetch to work in the Scripting block. Getting this: cannot find name ‘fetch’ Normally, I would think this is my user error, but I have another base using the “original” pre-beta version (2 weeks ago) and fetch works OK in this. Any thoughts @Kasra ? Thanks JB

Hey there, Is there a way to get the block id at runtime? I need it for authorization purposes, to see if my customer is still authorized to use the block. Thanks, Ronen Babayoff Superblocks.at

This script block code seems to crash the Block… any ideas? output.text('# IndexOf() Bug?'); let str = "This is a test ..."; let positionOfIs = str.indexOf("is"); output.text(positionOfIs);

There’s a saying in NASCAR, although the origin is largely unknown, really fast cars are often described as “stupid fast”. In my early and limited experience with the Script Block, I’ve noticed that barebones reading and enumeration of data sets are exceedingly fast - indeed, stupid fast. This is great news - the team at Airtable cared greatly about the performance in script block apps when accessing and processing large numbers of records with potentially numerous fields. I think there’s a little magic going on inside this new feature which, in my experience, is quite impressive. Writing data - updates to a field - not so fast. But this could be my poor design choices. I haven’t spent any time thinking about field and record updates thus far. Here’s the base I used for these tests. It includes a quick-and-dirty benchmark block. I’m curious if these performance results vary by client.

Hi, Airtable Scripting Block Documentation wrote: " In your script, you can use anything from the JavaScript standard library, except for DOM APIs that interact with HTML on the page." Suggestion: In place of DOM API that is not the right way to do it, could you open any other way you should prefer like passing States to Props to UI Components ? Best, oLπ

From people’s experiments so far, are we seeing Scripting as an alternative to third-party automation like Zapier? I suppose by that I’m talking most simply about Airtable > Airtable automation.

Less than a few hours after Airtable released its long-awaited integrated scripting block, I was asked by more than one community member what I thought about this new shiny toy. By looking only at one example by @JonathanBowen, I am able to say – This toy has teeth! I needn’t write a single line of code to recognize a game-changer for Airtable users, and specifically, consultants, power-users, and anyone interested in taking their solutions to a higher level. Certainly, there are bound to be a lot of missing elements of this integral tool to manipulate data in tables. And there will be significant complaints about the tight guard rails imposed to prevent “coders” from doing dumb things on a platform that is ostensibly hosted for joint tenants-in-common. Teeth? Yes, teeth. This early implementation can put a huge dent in many of the common deficiencies of the beloved Airtable that this community has railed about for almost a half-decade. This new block will ultimately demonstrate tha

Is there a way to lock fields in a record that are updated through the API? Use case: We use the API to update the airtable according to certain parameters on our company servers/backend. These fields ideally need to be locked as the scripts on the backend/server side does searches for these fields and if they are accidentally changed the endpoint s missed.

Hey everyone, I am trying to write a script that call my airtable and “Pending” orders. I need to write a json script that calls to the server, retrieves any orders and makes them into seperate windows so you can see them like tickets. (i was going to include the airtable to show but it will not allow me to add link) It has name - what drink they want - what the status is - the time it was created. I’ve messed round with the airtable API but it doesn’t allow me to retrieve the information I want and throws them into a long line. To be honest I am not a programmer at all, I dwabble a bit and try to get things to work but out of my element on this one. Any help would be greatly appreciated. Thanks, Bobby

Hey, would love to be able to not only get the cursor.selectedRecordIds, but also the selected fields, if any fields are selected in a grid view. Seems like there will be many use cases that would require such functionality. I personally have a few. Thanks, Ronen

This category is for developers to share the scripts they’ve built, provide feedback, and connect with each other. https://try.airtable.com/scripting

For discussion around customizing and extending the Airtable platform with our API, scripts, and third-party integrations.

Hey folks, I’m receiving a 403 error during a Patch after having patched 19 times successfully. If I have invalid permissions, as the 403 indicates, then why am I able to do it successfully 19 times with a similar payload before the error is raised? I’ve looked carefully at the patch payload for weird escape characters or data type issues but I don’t see any anomalies. I’ve also tried slowing down the patches with a time.sleep(). I’ve tried reducing the size of the payload to the minimal size. I’m at a loss as to what else to try. hmmm. bugs bugs bugs.

Hey Guys Is there a do a filterByFormula to find an exact match? filterByFormula=(FIND(%221234%22%2C%7BProject+Name%7D)) will find records within the Project Name field containing 1234 or 12345 but I need to return the exact match (1234) not the partial match. Hope that makes sense??

Not sure if I understand the use cases for Blocks but I am trying to create a little mini GUI to pull data from Google and save into Airtable. How do I go about securing my API key? Is it secure to bundle with code that gets released to Airtable?

Hello, I’ve been trying all evening to get this to work, but I’m out of ideas: I’m making the following request to the API, and getting nowhere - The fields are exactly as in the docs but I get the response: Could not parse request body. This can occur if the information entered into a field is not in the correct format. Double-check that you are using the correct format for entering values into a field. The problem is, it works perfectly in Postman, but when I run it in Zapier it falls apart. The JSON payload is as follows, and I’m using “User-Agent = Postman” { "records": [ { "fields": { "Gap Details": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur", "Category ID": "12",

Forgive my ignorance, but is there something in my browser settings that is causing this?

Hi, This one is an API enhancement request. I know that the Cursor allows me to get the record ids of selected records. But it doesn’t provide the ids of expanded records, which I recommend should be treated as “selected” as well, especially taking into account you can move to previous and next records from within the expanded record UI, by using the arrows above the record primary field. I tried to work around that by trying and track changes to the top window location (i.e. the browser url), since it includes the record id of the expanded record: https://airtable.com/activeTableId/activeViewId/expandedRecordId?blocks=blockId Problem is that in dev mode (haven’t checked it in a release yet), I cannot access window.top.location - I get a cross origin error: Uncaught DOMException: Blocked a frame with origin "https://devblock--....airtableblocks.com" from accessing a cross-origin frame. Straight forward solution would be to get expanded record IDs as well via the Cursor. Thanks, Ronen

Hi there, Tried different ways, without luck as of yet. It’s lacking documentation and I also couldn’t find an example in any of the block examples. Thanks, Ronen