Development & APIs

Hello I use the library airtable.js and i would like to change the auth methode before jan 2024.Actually this is my code new Airtable({apiKey: vars.API_KEY}).base(vars.ID_AIRTABLE_TABLE_BUG);but i would like make something like : new Airtable({ endpointUrl: 'https://airtable.com/{BASE_ID}/{TABLE_ID}', oauthToken: { clientId: 'CLIENT_ID', clientSecret: 'CLIENT_SECRET' },}); but it's not working, do i miss something ?

Edit:This is no longer needed, AirTable has updated the official script with a superior correction.https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-queryOriginal Post:Here is a version of the M Query code for Power BI/Excel with a small correction that resolves the issue of the query endlessly pulling the first page of results:   let Pagination = List.Skip(List.Generate( () => [Last_Key = "init", Counter=0], each [Last_Key] <> null, each [ Last_Key = try if [Counter]<1 then "" else [WebCall][Value][offset] otherwise null, WebCall = try if [Counter]<1 then Json.Document(Web.Contents("https://api.airtable.com", [RelativePath="v0/"&BASE_ID&"/"&TABLE_ID&"", Headers=[#"Authorization"="Bearer "&PERSONAL_ACCESS_TOKEN,#"Content-Type"="application/json"]])) else Json.Document(Web.Contents("https://api.airtable.com", [RelativePath="v0/"&BASE_ID&"/"

Hi Guys, Wondering if anyone can help me out with this one. I want to create a script that incorporates an API to weather.com. The script will draw the information from the field and the field in Airtable and the result will be the weather forecast for that location on that day into a field called in Airtable. Im pretty new to all this, so the most descriptive information would be really appreciated! Thanks guys! JH.

Hello there, I'm a recent customer of Airtable, i really love this solution but i have some issues with scripting automation. When i run my code on scripting app i don't have any problem but when i try to create an automation like a button on click i receive this error message -> Error: Exceeded quota of 30 table queries per script invocation. I checked the forum but i don't find the real solution of this issue. Could we help me ? Thx a lot My code : // Clean all table let table = base.getTable("fetch_articles"); let query = await table.selectRecordsAsync(); let recordsToDelete = query.records; let batchedRecords = []; while (recordsToDelete.length > 0) { let batch = recordsToDelete.slice(0, 50); batchedRecords.push(batch); recordsToDelete = recordsToDelete.slice(50); } for (let i = 0; i < batchedRecords.length; i++) { await table.deleteRecordsAsync(batchedRecords[i]); } // Run code function btoa(token) { var Base64={_keyStr:"ABCDEF

I'm looking to add a quick estimate feature to our website that allows a customer to use a drop down menu to select the year, make and model of a vehicle and have up to two options with two prices displayed, from data stored in one base, then be able to book an appointment that would go into another base including the information from the selections made.Is there already a way of accomplishing this or would this be a custom job?

Hello all, I was trying to optimize a website and reducing the size of the images and I ran into a problem which is not occurring in other projects. When converting the images to webp and uploading them to Airtable, Airtable is converting them back to PNG and feeding a 50KB file and making it 700KB. So I tried a few options and upon uploading smaller PNG’s in order not to have airtable convert, I noticed that a PNG file is 170KB yet, Airtable is still feeding it as a 700KB+ png file to my website. How is this possible? I have other projects using airtable and I can fetch webp files for starters with no issues. But with this project I don’t get webp, only PNG’s and they are also not the same size as the uploaded versions. I tried creating a new column and adding only webp files and the result is still the same. Any suggestions on what I can do? Thank you in advance.

Hello I am still struggling to find a solution for the Currency Value Format. Seems impossible to have a field as : € 1.000,00. The only option seems the american one $ 1,000.00. Does somebody can help? Thanks a lot guys A

Hi there,I am getting this error message back, when I test my HTTP request flow in Webflow:{ "error": { "type": "INVALID_VALUE_FOR_COLUMN", "message": "Value is not an array of record IDs." } }Strange that it doesn't name the column. Strange that I am not writing any data with reference to other records into reference fields. It's a simple form with text fields, number field, an email field, a phone field and a checkbox.No matter how I manipulate the form, this message comes up. The request as such is successfull.Has anyone experienced this?

I apologize if I missed recent updates about this. I couldn’t find anything through searching. Is there any way to pull the revision history on a record via script? I have a client who wants to see a daily recap of certain fields. Right now they have a view that shows them the records updated in the past 24 hours and they can open records to look at the revision history. But they want a daily recap email that goes to a couple people with changes to certain fields. I know I can create a modified field for a given field but I’d rather not have to do this for each field they require visibility on. Thank you in advance for direction on this.

Hi all i am struggling with uploading woocommerce image from airtable url. Now airtable doesnot provide ".png" on the url.Is there any ways i can upload it using REST api curl method?

Hello.  I have been using an API token (the original method) for authenication to get records from a particular table.  I have been using the 'airtable' Python library to do this.  We are now switching to use a personal access token (PAT) because the API token authentication method is going away.  So, I can no longer use the 'airtable' Python library because it doesn't support PATs. So, I am simply using the 'requests' Python library this time around.  For whatever reason, I have a handful of columns that will not download when using the 'requests' Python library with my PAT.  However, I can download these columns when using the 'airtable' Python library and my API token.  Below is my code.  In the field list, I put a comment to denote the fields that won't download  when I run my code.  These columns just don't appear in my final downloaded file.  Is there something I'm missing?  Or is there a better library that I should be

Trying to connect MAKE with Airtable following the OAuth method. Getting an error that says: "Your OAuth application requested the scope \\"schema.bases:read data.records:read data.records:write\\" which \n your application does not have access to.Is this because I'm connecting to a Mac, because Make and AT are paid plans, or other reason???(error message attached)Thanks  

Hey folks,We are trying to implement OAuth integration and getting the following error: This OAuth application cannot be used outside of development Can someone help us understand what this means? We don't see any reference to this in the doc. I guess the integration needs to go through a review, but it would be great to get some pointers on the docs.

I've tinkered a bit with the NLA Beta from Zapier using LangChain and LLM's from OpenAI. Anybody else tried out to hook it up to Airtable?So far I've been following the guide from LangChain (Here's the 🔗 Quickstart Guide) for 🔗 Zapier Natural Language Actions API. I've been successful with the example of finding the latest email of XX in your Gmail and making a summary of it but when it came to Airtable it became a bit more tricky.I've set up an action on Zapier's side and tried out a few different trials for finding records. It often hallucinates imaginary values/records.Here's the result: agent.run("Let's think step by step. Search in Airtable and find three records where in the name field, the word Hogwarts is mentionned. Then, provide me a list with the fulle name field of each record.") > Entering new AgentExecutor chain... I need to find three records that have the word Hogwarts in their name field. Action: Search Record Name Field Action

Hi everyoneI've been trying to use the "Create records from multiple select field choices" script from Airtable Marketplace by @Alex_Wolfe1 but unfortunately it doesn't work for my use case where the source fields are not the Multiple Select type but multiple linked text fields that are pulled from another table.I've been advised by Support to change my source fields to multiple select but the thing is that this would not be practical as I have 75+ entries (and growing); besides the fact that I need them to be neatly stored in a separate table as text along with various other attributes for each.Anyone please reckon if this is doable by a simple alteration of the existing script as I'm not familiar with scripting?Thanks for any tips!

Hello! I wrote a script that creates multiple days worth of events people can book at a time, but it takes into account some settings to determine how long those slots are, when the lunch break is so it wont create a slot then, etc. I'm also making an automation to create a new day's worth of these every day at midnight, so that after we run the manual script once we can leave the rest of it to happen automatically. I'm wondering if there's any way I could grab the settings from the manual script for use in the automation. 

Here is a script that will count records per table and output the result as a little CSV output. It is a little quick and dirty and will take ‘some time’ to run if you have large record counts. Hope it is useful to someone. let tableCount = base.tables.length; let totalRecords = 0; for(let i = tableCount - 1; i >= 0; i--){ let name = base.tables[i].name; let table = base.getTable(name); let result = await table.selectRecordsAsync(); totalRecords += result.records.length; output.text(name + ' , ' + result.records.length); } output.text('Total Records in ' + base.name + ', ' + totalRecords);

Hi everyone!Nice to meet you.I am trying to load rich text content through api, but it's broken.But when I put the content with HTML tags, format is working properly.https://prnt.sc/r3ys_DfPjzFKBut my client is not a programmer. He can't add content with HTM tags.So I want to load rich text content as I entered without any HTML tags.Please help me.Thanks.

Hi everyone!I am trying to build an airtable extension, but when I create a new extension from scratch, I keep getting an error even if it's a fresh project(Hello World project), and airtable.com is running with http. Not https.  https://prnt.sc/vez_k5mb4PQ8https://prnt.sc/wXpGYOFcv3p2 https://prnt.sc/7xxP2ahjpOYV  Please let me know, how to solve this issue.

Hello, I have created a custom Airtable extension to dynamically update AirTable data. When I install an extension setup from a base a baseID and blockID are automatically added to the .block file and all table names are fetched based on the baseID by useBase hook. But when I will deploy it and users will install the extension, how will the baseID and blockID be set? Or how do I set the default configuration of Airtable to get baseID and blockID?

I have an airtable base that I have read-only access to. I created a personal access token (PAT) and gave it read-only permission to that base.I am using an angular app to display that data on a web interface, but I'm having difficulty successfully using the API. I have added both my airtable base and PAT to my environment variables, and have been using the auto-generated documentation to try and actually list the records. I continue to get a 'FetchError' detailed here:FetchError: request to https://api.airtable.com/v0/{BASE}/{TABLE}?maxRecords=3&view=Grid+view failed, reason: self-signed certificate in certificate chainat ClientRequest.<anonymous> (C:\EPandA\scorecard-metrics\code\backend\node_modules\node-fetch\lib\index.js:1505:11)at ClientRequest.emit (node:events:513:28)at TLSSocket.socketErrorListener (node:_http_client:502:9)at TLSSocket.emit (node:events:513:28)at emitErrorNT (node:internal/streams/destroy:151:8)at emitErrorCloseNT (node:internal/streams/destroy:116:3

I followed the directions from this handy Airtable Support Page: Sending Airtable data to Microsoft Power BI & Power Query to get data from one of my tables to Power BI. It worked perfectly. Then I transformed one field/column on Power BI by mistake, meant to transform it from text to number but instead I chose binary. I am quite new with Power BI and SQL–anyways I tried to ctrl + z to revert but I wasn’t successful. So instead I just closed it all out and left it unsaved, but of course when I opened it, the mistake change was still there. So then I exited out of Power BI and started a completely new Query, basically redoing everything I did from the Airtable Support steps above, but now the Table_ID parameter always gets a triangle with an exlamation point after I copy in the M Query and click “Done”. I also get the following error message: “Expression.Error: A cyclic reference was encountered during evaluation.” I’ve restarted my computer and tried everything again, and still get

An Airtable user tagged me with a question offline today. It caught my attention. … has Airtable (or have you) made any progress in using Vega Lite for non-table-based data?I believe he's referring to the ability to blend Airtable data with external data to product visualizations. This is a data-sciency thing that touches on aggregations.Allow me to reframe the narrative.Analytics designed to expose findings about data sets is typically based on aggregations. I often refer to these as viz-ready data.Aggregations are post-processes that are typically applied over collections of transactions or observations that are detailed. It's the data no one wants to look at except for perhaps auditors or data scientists designing aggregations.Airtable has rollups and other mechanisms to create aggregations. They're weak, poorly implemented, require new fields and keys, and almost always slow.Dynamic aggregations in a late-binding process (at viz-time) are needed because data changes

Dear talented Developers, I hope this message finds you well. I am writing to you today as a Ph.D. student in entrepreneurship at the University of Calgary. I am part of a research team led by Dr. Mohammad Keyhani, conducting a study on the no-code / low-code revolution. Your expertise as an Airtable extension developer is highly regarded, and we would be honored if you would be willing to participate in our study. Your knowledge and experience would be invaluable to our research, and we would greatly appreciate a 45-minute interview to gain deeper insights. However, if a 30-minute slot would be more convenient for you, we would be grateful for your time nonetheless.https://calendly.com/mahdieh-s1994/interview  I provide a calendar link or work with any preferred scheduling tool that you may have. Please rest assured that our study has been approved by the University of Calgary ethics board, and we strictly adhere to ethical guidelines to ensure the confidentiality

Hi everyone, I have a main base, I want whenever I create new record in main base, the other specified base will be updated, and whenever I edit or create new record in that specified base, the main base also be updated. It looks like sync but I want to way to provide task into the base I want. Thanks for your helping.