Development & APIs

I had a AWS Lambda function that is to update an Airtable. And I am going to modify the function to adopt OAuth2 authentication. However, after testing in Postman, it requires user login in a browser and select workspaces and bases. But it is absolutly impossible for Lambda function and we don't want to store user account in the Lambda function.May I know if we can skip user login during the OAuth2 authentications? Also, can I predefine the allow list of workspaces and bases?

I created my own Extension under "Build an extension". Result was a full functional extension I was able to use in my Base over localhost:9000.Then I clicked "Delete Extension" inside the Extensions Menu in Airtable.Extension is gone, fair enough.But how can I reconnect the still existing Extension from my local machine to Airtable and use it again?Idea was to release it with `$ block release` add it in Airtable and find the "Edit Extension", like proposed here.FAQ sounds promissing:"When you run block release, the code is bundled and sent to the Airtable server — we host the released bundles for you. Collaborators in the base can then use your extension as well as install new copies of your extension in that base."But there is no hint how and where the released Extension is findable?!Google doesn't help, documentation doesn't help. What am I missing here 🥺?

Hey everyone,I am new to this forum! I thought id just throw this out there to see who I can stump and if I can get some help. I tried writing this with chatgpt but I dont think it has the most recent coding and API’s in its database.  I am on the free version of Airtable. The script I want to write is as follows.  First, the script gives a new entry or existing entry under the ‘ORGANIZATIONS table a random 6 digit number that no other entry will have and places it under the "Identifier Number" field which is a single line text. Once this entry has a number, it will never change. As a note, it would be really awesome if the first two numbers could be the year the record was created (for example its 2023 and the first two numbers would be a 23).  Next,  if any of the following fields match to new or existing entries: Street Address 1, Street Address 2, Zip, Organization Name. It will make sure all those above fields are correct and add the sa

Hi all,I'm trying to get the sender's url (within a strip) for an incoming webhook call so that I can response to call only from a specific domain.  I'm wondering how do i do that?  Thanks!EDIT Feb 24: I also need to get the sender's url for other reasons (such as deciding what the response will be); hence having access to it in the script serves multiple purposes.  Thanks!!!Best Regards,H8

I am attempting to fine tune by lead scoring in my Airtable CRM by sorting my Contacts by the amount of consecutive 'Voicemail' values in my 'Call Result' rollup field in Contact (which is a rollup from my Touch Points' table Call Result single select drop down.What I am looking to achieve is that those who have a lot of Voicemail unanswered get sorted to the bottom for my daily calls and the ones who have the least consecutive Voicemail unanswered get sorted at the top (so I don't keep calling people who just keep going to Voicemail when copy/pasting into my Touchpoints table).Any input on how I could do this much appreciated. Thank you!Video for context:https://share.getcloudapp.com/NQuWRnP0

I tried to use the API to create a new base. I copied and pasted the example from the official API reference, and the only changes I made is 1) used my own access token; 2) used the correct workspaceID. And the example returns{"error": {    "type":"INVALID_REQUEST_UNKNOWN",    "message":"Invalid request: parameter validation failed. Check your request data."    }} Not sure how this API could work if the example given by the official reference is not working.

Hello, I’m developing a custom integration to generate websites from Airtable. Wondering if there is any webhook to check when a field is updated via API. What i want to achieve is to receive it in my server. Thanks

Hey all,I am relatively new to using the Airtable API, and I might just be confused. I am hoping you all can steer me in the right place.I am used to using APIs to do things, but the Airtable Scripting Api seems weird to me.To my understanding, when I GET a record, I am only getting the record object with very little fields. Do I need to call getCellValue on all the fields to actually pull out the data or is there a better way to get the data out?

I am receiving a cryptic error when attempting to create a record using the code below:// Change this name to use a different table let table = base.getTable("Touchpoints"); //let ctable = base.getTable("Contact"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); let billTillString = await input.textAsync('Bill Orders till which date? (format YYYY-MM-DD)'); //let notes = await input.textAsync('Any Notes to mention'); let billTillDate = new Date(billTillString); /* //newRecs[0]['id'] = 'recDYGIT7fj80tTAH'; //let namer = new Array('recDYGIT7fj80tTAH'); //let Contact = record.getCellValueAsString("Contact"); // Contact RecordID //let recordID = record.getCellValueAsString("Contact RecordID"); //console.log("ID is: " + recordID); */ await table.createRecordAsync({ 'Start Date/Time': billTillDate, 'Contact': [{id: 'recI7YlI

I am attempting to setup a workflow for a Callback system for my Sales calls. My plan was that when a record in my Callback List View inside my Touchpoints table was updated to have the Call Result column be set to Voicemail select - that it would automatically duplicate itself and the duplicate would have 24 hours added to the Start Date/Time column - so that I would automatically see that record the next day in the Today's Calls View in the Touchpoints table.My challenge is that I am unable to find a way to duplicate a record based on the ID - so far I have created an automation and passed the record id as 'rec_id' variable to be accessed through the input.config() variable in the script that is set to run when my Trigger matches as per this screenshot:https://share.getcloudapp.com/p9uL4eKPAfter reviewing some other examples of scripts I have created a script which you can see in the Gist below:https://gist.github.com/HeadStudios/98c8837c02a0fb8540e3e36333281945While this script does

Hello,I am looking to embed the improved search extension onto my website when searching the database for select information.Is this possible?The basic search bar is extremely poor and doesn't pick up the information I require.

Hi smarter people than me, I hope you can help?I have an integration with CraftMyPDF where I send a payload I build in script through to be used to populate the PDF template. 2 of the fields passed through are date fields: Contract date and Event date. I have noticed that these fields are always offset by 1 day in the past.In the base grid view (or any other Airbase view or interface) these dates reflect accurately, as captured. When I use these same fields in my payload and inspect it, they reflect with -1 offset. The dates are formatted "friendly" and set to my local timezone.Does anyone have any suggestions on how to get the API to honour the date as it is shown in grid views?thanks in advance!

Hi all, I have a docupilot/Airtable integration set up where every time a student submits a form via Airtable, it sends them a PDF of their responses. There is an automation set up via Zapier that creates the PDF and an automation in Airtable that sends out an email confirmation with the PDF as an attachment. Some of the fields in the submission form are long line text with the rich text formatting option so that people are able to italicize text when needed but the problem is that when the PDF is created, it doesn't capture the italicized text and instead adds an underscore before and after the italicized text. (Ex. _text_ instead of text)Does anyone have any idea as to what may be causing this issue? Thanks!NeptuneDev

i have a json with specific format. can i use api to build a new base with the specifation?

This is happening on trigger from record creation, another script triggering a webhook, etc.  The automation just hangs on the first script step endlessly.I've confirmed that the script executes successfully when run by itself.  According to status.airtable.com everything seems fine.Anyone have an idea on what might be the issue? 

Hello community, after the implementation of prsonal toekn if i use curl method it retrives i get only 100 records.. How can i use offset method? earlier i used offset using api key and it works good but now api key was deprecated. Awaiting for solution

Hello,I have successfully created new table from a custom extension. Nevertheless, I want to create "Button" field in that table that will invoke my custom extension.There is an example in documentation which says I must obtain the URL of the block here:  { // The label of the button label: string, // URL the button opens, or URL of the block that the button opens. // Null when the URL formula has become invalid. url: string | null, }   What I am obviously missing is how to get URL of my blockThanks in advance.

Hi, currently Zapier can only connect to Airtable via an API Key per https://help.zapier.com/hc/en-us/articles/8495995404173-How-to-Get-Started-with-Airtable-on-ZapierIs it the Airtable dev team's responsibility to update their integration with Zapier, to make use of personal access tokens or the new oauth mechanism?Or, can someone on the dev team prompt Zapier to do it?

Hi i’ve created an attachment cell and attached an mp3. If I grab the url from the api it does not play? Any ideas?

I am now working on integration the Airtable OAuth to my existing system.So I am trying to test on Postman first.But when I send the GET request (e.g. https://airtable.com/oauth2/v1/authorize?client_id=xxx...) for Authorization in Postman, it return the web page "verify it's you -Airtable". The page also says "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".But if I run the GET request on a Chrome browser, I can get the return code without issue.Can anyone help? 

I am going to integrate the OAuth2 authentication with my existing apps.The first step is to send a GET request to https://airtable.com/oauth2/v1/authorize .But I failed on the first step.Here is the error:http://localhost/?error=invalid_request&error_description=%22code_challenge%22+must+be+a+valid+url-encoding+of+the+the+sha256+of+the+code_verifier+variable+generated+%28length+43%2C+alphanumeric+characters%2C+%22_%22%2C+or+%22-%22&state=e3f98sdasfdafsafdafsdasfwerwersfa03Below are the parameters for the GET request:client_id = //not exposed hereclient_secret = //not exposed hereredirect_uri = http://localhost/response_type=codescope=data.records:read data.records:writestate=sadjfhkjDFHKJShk23489sldfhjksdkssdffsf // random textcode_challenge_method=S256code_challenge=MTA4ZDJhYTQ1YTVhMGE3M2MwNTc3NmJiMzYyZTdhNDc3ZjgyNGUzN2U3NGZhYzA0ZGQ1NDAwYTE5OGM0OTMzYw// where the code verifier is SLAJFlksdlksfjljasldjflasjflasjflasfjisfjjdI already encoded the code verifier with SHA

I am creating a new record triggered by a script with the following code: let newRecs = {};newRecs[0]['id'] = 'recDYGIT7fj80tTAH';await table.createRecordAsync({'Start Date/Time': billTillDate,'Contact': newRecs,'Notes': 'New Record note'});I am getting the following error:  TypeError: Cannot set properties of undefined (setting 'id') Can you please modify the script - assuming the record Id is correct - so I can populate my Contact link field? Thank you!

I will be processing a very large number of social media posts in both image and video format. Due to this I will inevitably run into storage issues very quickly. I have image URLs set up like this within my table:https://ik.imagekit.io/sq64zigvs7/tr:w-2700,h-2025,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1500,h-1000,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1200,h-630,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1080,h-1080,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1600,h-900,/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpghttps://ik.imagekit.io/sq64zigvs7/tr:w-1080,h-1920,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1.jpgIs there a way to automatically download these as an attachment (like if time to scheduled post is say less than 2 hours or

Is it possible to create one collumn that contains name with a hyperlink combined?I know how to do it manually. Is there a way how to do it automatic?I can easily do this in bulk on google sheets. But when trying to paste the data from sheets to airtable it just shows the name without the hyperlink.How do I do this automatic?

I am configuring a Learning Management System that has a master table of all trainings that could be assigned, which are then linked to an "employee type" table that contains every possible role. This is a modified re-creation of the "create new tasks for certain project type" script/tutorial found here: https://youtu.be/zHQjljEov30I was able to repurpose the script to create new tasks but I just realized, I think that the script is ignoring applicable trainings that are linked to multiple employee types. I am pretty sure the way the script is filtering through the templates is to blame. This section is what I think I need to fix. I am new to scripting and I'm not sure if there is a different way to basically say "if any linked records in "employee type" for task match the specified employee, return that task" Since right now I think it is only reading the first linked record employee type... does this make any sense? I can definitely link the whole base/script if unclear &#128578