Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
Jim_Bain
Jim_BainNew Participant
asked in Development & APIs
Junction records automation

I need help writing the following script: Tables: Classes Students Grades (junction table) Each time an Enrollment form creates a new record in the Classes table, the script creates a record for each Student in the Grades table. Grades table is a junction table linking Classes and Students tables. I know there are several community scripts regarding junction tables but I need one that works from just one Class record at a time.

21
Jim_Bain
A
Alberto_ConsonnNew Participant
posted in Development & APIs
How to get users through API

Hi community, I’m working on the integration between ServiceNow and AirTable, the goal is to manage AirTable subscriptions through ServiceNow, so I need to get AirTable user subscriptions into ServiceNow. Looking at the AirTable API documentation, I don’t see anywhere how to do a simple “Get Users”. Using the Enterprise Account > Get Information, I’m only getting the userIds without the other parameters. https://api.airtable.com/v0/meta/enterpriseAccounts/EnterpriseAccountId How can I get the list of AirTable users including all the following basic information? "state": "provisioned", "email": "foo@bar.com", "name": "foo baz", "lastActivityTime": "2019-01-03T12:33:12.421Z" Thanks a lot for your support Regards Alberto

778
ScottWorld
S
Shaun_HughstonParticipating Frequently
asked in Development & APIs
Produce JSON for linked records

I am using Airtable to send data through to another platform (Formstack Docs aka Webmerge). My base has a main record with a number of linked records per main record. The use case is that each item from the linked records will be a new row on a document. In order to do that, I need to send the data through to the document in JSON. Is there a way that I can produce the JSON of the linked records with a script within Airtable? Ideally I could put that JSON into a long text field. Failing that, is using a code step in Zapier the only other option? Thanks Shaun

630
kuovonne
M
mdmtrKnown Participant
posted in Development & APIs
Displaying HTML in Scripting block

Hello! I just wrote a quick snippet to turn records and linked records into labels, but I ran into the nasty surprise that the scripting block doesn’t allow HTML formatting. I can’t really do this in markdown due to the flexibility constraints of the labels I print on. Is there any way to either a) make the Scripting block render HTML or b) easily convert a script to a custom app? Thank you!

154
S
E
Eric_Goldman1Inspiring
posted in Development & APIs
Airtable API slowing down? Base adjustments to keep it fast

Our company is deeply integrated with the Airtable API. In fact, we help other companies build on Airtable - so we monitor the Airtable API closely. Up until a month ago, all our API requests to Airtable were GET requests. With the launch of our proxy, we’re now servicing PATCH/POST/DELETE requests as well. With these new requests, we began to notice some unusual API performance. Requests could intermittently take up to 10 seconds to complete. So we started an investigation to determine what caused this erratic API performance. Our first hypothesis was that base size was the culprit. We ran a benchmark across bases of different sizes, and oddly the 10K base was much slower. Granted, each base had different data in it - but the consistent performance on the other 1K base and 49K base indicated that size wasn’t the issue. So it must be something with the structure of the base that impacts API performance… Read the full post to learn what elements of your base cause the Airtable API to s

122
ScottWorld
D
Dominik_BosnjakInspiring
posted in Development & APIs
Some more info on btoa "troubles" in the Airtable Scripting block

Continuing the discussion from Base64 conversion: Wanted to resurrect this 2020 topic for a second because it was locked without a definitive explanation, so maybe I can offer one and help some future coding prodigy keep their anxiousness in check instead of wasting 30 minutes of their life looking into random commits for an answer to what these mean red lines might want from their binary schemes as their own twisted way of procrastinating. So, it would seem that this is a visual bug specific to Monaco, an open-source text editor from Microsoft which powers Airtable’s Scripting app. On my end, these squiggly eyesores only appear if I write btoa instead of BtoA immediately after a DOM refresh. But if I reload the page and use BtoA first, I can btoa as much as I want all over the place. Sd linting quirks don’t affect functionality and the inconsistent accounts from the previous thread suggest the lines might actually originate from a third-party spellchecker (or a rare example of a secon

70
D
E
Edmunds_PriedeNew Participant
asked in Development & APIs
How to show linked records?

how can i show linked records for a selected table record that changes dynamicly when i select/deselect rows? i can get selected row ids from cursor, but i am struggling to to select and show linked recods

90
Kamille_Parks11
H
Hannah_CussenNew Participant
posted in Development & APIs
Silent Failure of updateRecordsAsync

I am trying to write a script that will look at 4 fields from an older version, and copy the contents of those 4 fields to a newer version of the same data. When I run this, the script finishes super fast, and no records are updated. I know that some matches are being found due to the console.log statement. However, when I check my table that is supposed to be receiving the updates, there are no changes. What is going wrong when I try to update the records? let oldTable = base.getTable("Updated 4/15/21"); let newTable = base.getTable("Imported 4/29/21"); let oldRecordsQuery = await oldTable.selectRecordsAsync(); let newRecordsQuery = await newTable.selectRecordsAsync(); let oldRecords = oldRecordsQuery.records; let newRecords = newRecordsQuery.records; newRecords.forEach((record) => { let found = oldRecords.find((old) => old.name === record.name); console.log(found); if (found) { let newCalledBy = found.getCellValueAsString("Called By"); let newCalled = found.

31
H
S
Simon_BowyerInspiring
asked in Development & APIs
[Misdiagnosis, Airtable not at fault] API reporting creation success but records missing

I noticed three records missing from a table, which had been created via an API call. The API call response indicated success, including a response object containing the same number of records (and with recIDs) as had been POSTed in the call. However, these records do now not appear in Airtable. There is no record of manual deletion in the base trash, and the view is not filtered. I was wondering what could be going on and so decided to look at an automated Airtable snapshot taken on the same day. The records were not in the snapshot, but I did notice that the snapshot was taken at the exact same minute that the API record creation POST call was made for the missing three records. Is it possible that the snapshot process has interfered with the record creation call in some way (perhaps a DB transaction lock or similar), resulting in the Airtable API response to prematurely report successful creation?

1910
ScottWorld
Y
YakInspiring
posted in Development & APIs
Reading remote JSON

Hi! I am learning to build my first Airtbale apps, I completed the basic tutorials, and now would like to be able to add the ability to read a remote JSON to my app. First question I have is: The API methods that work within the scripting app will work for custom apps? In that case is fetch the right way to go for reading remote data? Also, if anyone has a very basic example of an app reading remote data I will really appreciate that. Thanks a lot for your time!

11
Y
E
Edmunds_PriedeNew Participant
asked in Development & APIs
Noob problems, running a custom app

i have set up nodejs and did block run. then i copy the url in App Url field and i get Can‘t connect to your local app, did you block run ? https://localhost:9000/ on local comp is working

160
D
R
Rob_WicksNew Participant
posted in Development & APIs
Expand Record from a Checkbox

Hi All, I’m wondering if there is a simple option to run a script when a checkbox is ticked. The Reason is i am going to take a timestamp and modified by when the check box is ticked. So if I was working: I Would Tick check record and that particular record would open in expanded card view: so it would need scripting, but I cannot work it out at all. any assistance would be appreciated. Rob

11
kuovonne
E
Eugene_KimInspiring
posted in Development & APIs
Using environment variables

I’d like to pass in environment variables to my Airtable Block Code whenever I run and release so that I can configure things like endpoints dynamically based on the environment. Is there a way to do this?

130
E
R
Ryo_KonishiNew Participant
asked in Development & APIs
Upload images by Airtable API and S3

Hi, everyone. I have a question about Airtable API. As far as I know, Airtable API doesn’t allow direct image uploading and needs a public URL that images are stored. However, the images include very sensitive information in my case, so that they can’t be stored in public. In this case I guess I can use S3 presigned URL. My question is, can Airtable API retrieve images even if the URL is only temporarily available to public? Thanks, Ryo

432
R
dilipborad
dilipboradBrainy
posted in Development & APIs
Does Enterprise plan has a more API Rate Limit?

The API is limited to 5 requests per second per base. If you exceed this rate, you will receive a 429 status code and will need to wait 30 seconds before subsequent requests will succeed. Anyone has experience with what is max request per second allowed by the AirTable Enterprise plan

51
ScottWorld
R
Randi_TraversNew Participant
asked in Development & APIs
Generating Task from Task Template

I’m new to Airtable scripting but I have figured out quite a bit already. Using many different sources I have written a script that copies my task template into my task table bases on picking the name of the template you want to use. Now I’ve been asked to add some additional fields with different types and my script does not work anymore. Let’s start with the first field type with an issue: Multi-select Current error: P: Can’t create records: invalid cell value for field ‘Test Multi-Select Copy’. Could not find a choice with that ID or name at main on line 54 To me this error means that the lists aren’t the same but I there are only three and I checked that yesterday I’m a little confused on how to show everything that someone might need to assist me. I put a screen shot above of my task template and below is my script: //declares and then gets the project from the select list or from the row the button is on const projectsTable = base.getTable(“Projects”); let record = await input.r

246
R
C
Chintan_Savali1Known Participant
posted in Development & APIs
Webflow API call through airtable script app

Anyone has used a scripting app to run API calls to add/update webflow cms items?

64
C
A
Aleh_TanasiukNew Participant
posted in Development & APIs
How do we access tables and their structure with regular API key

Hi, team! We’ve noticed that “GET https://api.airtable.com/v0/meta/bases/BaseId/tables” is a part of Metadata API now. Are there any announcements about excluding this from regular API? The endpoint was listed in baseID specific API docs, so we were expecting to access tables and their structure with regular API key. Is there a way to get this data with regular API key now? Thanks

20
A
D
Drew_SNew Participant
posted in Development & APIs
Do we have access to the actual field type via API?

Hi! I’m trying to generate a csv file of a table similar to a file generated by web UI. Using Airtable API I get data only in JSON format, which supports only numbers and strings. Thus I have to guess the type by value shape. For example: Does a string contain a template DDDD-DD-DD? ​Is it a link to another table? Etc And it is a mess. So my question is - do we have a way to get the type of the field, the same as what we are able to see when reading API documentation (Currency, Lookup, URL, Link to another record, etc)?

21
kuovonne
R
Rip_GillNew Participant
posted in Development & APIs
Airtable + Elementor

Hi all, I noticed the Airtable has announced better integration with Elementor. I am new to Airtable but have been using Elementor since it launched. Is there any documentation regarding Elementor integration please? Thank you.

842
R
A
Ashwin_PInspiring
posted in Development & APIs
Use UI components from Blocks outside Airtable Apps

Is it possible to use the UI components from Airtable Blocks SDK outside the Airtable Apps environment? Are there any Airtable React components implementation that can be used outside the Apps environment? Thanks.

31
J
B
Bret_EmmerichNew Participant
posted in Development & APIs
Dotenv file not loading variables into process.env.MY_ID_HERE (React Project)

I have my .env file with my variables, its in my src folder, I have my YOUR_ID_HERE, YOUR_BASE_ID and that in it. BUT, when I use “process.env.MY_VAR_HERE”, it gives me a a error: “Airtable requires a api key” … I already generated one, I know its the dotenv file, because when I switch the vars in the field for the raw api code… it works. so its the dotenv file that’s not loading.

40
B
A
Alon_MamiaNew Participant
posted in Development & APIs
Get Specific User

Hello, I would like to run the script every time the user enroll to my app. How can I access the current user in the script?

20
A
S
Scott_HelikerKnown Participant
posted in Development & APIs
Date Field Integromat Stoped working

I am using integromat and airtable update record module. If my data coming in date fields are empty its failing to pass into Airtable. This used to work and it just would negate the date fields since there was no data but now getting invalid date field. I tried using ifempty formula but that does not work either. Any suggestions here? The rest of the fields if I have them mapped and no data is there , it just treats them as if they were not mapped. Not sure what is going on with the date fields.

21
S
D
Dustin_LangeNew Participant
posted in Development & APIs
Zapier: Find Record in Airtable without an exact match?

I’m using Zapier with Airtable and a New Record in Airtable trigger. The new record has an email address like d12345@… Then I have a Find Record in Airtable action. There is a record with the email D12345@… - with a capital D. The Find Record action doesn’t find anything. Is there any way to make this work so that the Find Record action will match on similar strings like this?

193
D

Badge winners

  • Welcome
    YvonneHhas earned the badge Welcome
  • First Topic
    Dwalz3has earned the badge First Topic
  • Welcome
    Dwalz3has earned the badge Welcome
  • Certified Airtable Admin
    nitinjainhas earned the badge Certified Airtable Admin
  • Certified Airtable Admin
    CaitlenBerghas earned the badge Certified Airtable Admin
Show all badges
Terms & Conditions