Development & APIs

Hi everyone,Has anyone implemented an integration between AirTable and qTest? We’re looking to connect the two systems to sync test data or manage test cases more efficiently.I’d appreciate any guidance, documentation, or best practices on how to set up this integration — especially around API configurations or automation workflows (Zapier, scripts, etc.).Thanks in advance!

Hi,I am the owner of a workspace and I created a base that I would like to generate PAT but when I go to the developer Hub, I can’t find the workspace or the base in the add base field.  😭I must be missing some permission somewhere and I just couldn’t figure it out.  Help please! Thanks,Cynthia

Add static Google Maps to attachments based on addresses in a table. Source Code /** * Copyright 2020 Bocoup * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to * deal in the Software without restriction, including without limitation the * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or * sell copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COP

Hey everyone,I'm working on a personal project to automate my daily finance reports, and I've hit a wall that I'm hoping Airtable can help with.I absolutely love Airtable - it's been perfect for managing my financial data. But here's the thing: I can automate everything through the API except for creating and duplicating views. Every month I have to manually create new views and tables for the new month expenses.What I need:Create and duplicate views through the API Duplicate tables and rename them through the APII've tried every workaround

Hi! I get a “Connection error. Please check if your local block is running.” when running the extension I created locally. It works on Firefox. This was working previously. Initially, I thought it was related to a Windows 11 update that broke development with localhost, but I rolled it back, and it works on Firefox…I’m using the latest build as I plan on using the new multi table feature (I’m currently using the Web API to query a second table).

Hello All,Complete noob here, so, please be patient!I want to connect to the HighLevel (GHL) API here: https://marketplace.gohighlevel.com/docs/Authorization/PrivateIntegrationsTokencurl--request GET \--url https://services.leadconnectorhq.com/locations/<location_id> \--header 'Accept: application/json' \--header 'Authorization: Bearer <YOUR PRIVATE INTEGRATION TOKEN>' \--header 'Version: 2021-07-28'How can I accomplish this with Airtable? I want to poll the conne

Hi, right now, one of our databse APIs is down sind 2h, while all other of our databses are reachable.  Anyone experiencing something similar or has an idea what we can do? thanks so much for the help

I recently obtained a certificate in Airtable Admin but it's carrying my email address which is not my real name. Please how do I change it

We are a not for profit organization involved in promoting a fascinating Indian Sport called Mallakhamb.We use a combination of Airtable for data storage and sharing and fillout forms connected to Airtable base for  use by public for signups.I would like to understand the contribution of each part of Airtable - data, calculations, automations, shared views and fillout forms , towards the Public API usage. 

I want to send emails via SendGrid. this is to be done through an automation baed on a trigger of when a record enters a view, like this:The email text contains many personalisations, pulled from the database. Some of these fields are lookup fields from other databases. Below are all the personalised fields: And here is the script:// Get your SendGrid API key (store securely)const SENDGRID_API_KEY = "-KEYisHERE-";// Get the record that triggered the automationlet record = input.config();// Extract values from arrays BEFORE building emaillet firstName = Array.isArray(record.firstName) ? rec

I know it ha been discussed MANY times, and I even clicked on the “contact developers” to submit a question/suggestion to see if they ever think this will fully integrate with Airtable…. aka upload the PDF upon a trigger via automations, or just a column that IS the page designer. Can anyone at Airtable make this happen? It seems that Airtable is the developer, and with all the chatter here, this one small thing would make a huge difference to so many. Currently the only options are to use external PDF creation tools, which is beyond frustrating when you’ve created the perfect PDF page and all you need to do is link it to the column. The fact that someone can’t even click a link to view the PDF, ugh. Anyway, maybe if enough people “like” this, it can get to the Developer and they can actually follow though. With all the AI and automation of today, I know this is possible! Please help us get there. 

Hello Community,First post here. I am attempting to connect my Airtable to Power BI.I am receiving the following error message in Power BIExpression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type]I am following this guidance and using a Personal Access Token. I setup Power BI Parameters successfully but received the error code in the Query. I suspected that it may be the M Code so I followed a link to a GitHub resource for alternate code."If the above script seems to be causing an error, then please refer to this GitHub resource, as the code may have changed.

Has anyone had any success integrating Airtable with MRI Real Estate Software using API keys?  If so what steps did you take?

In another topic, I recently explained how you can instantly sync your Shopify metaobjects to Airtable.The good news is: you can now sync your Shopify metafields with Airtable too (thanks to SyncBase app) 🤩 How does it work?During onboarding, you can choose which metafields you want to sync (Product metafields, Variant metafields, Order metafields, etc.). The app then creates one table per metafield group (e.g. Product metafields) inside a brand-new A

Hello! I’m having more difficulty than I’d like to replace text with a newline.In the Airtable Find & Replace extension script, I’ve modified it to support RegExp find and special character replace. However, when I replace the text with a special character like a newline, it always comes out in a literal text format.Here’s a real basic example of what I’m doing:let originalValue = record.getCellValue(field);let findText = "<br>";let replaceText = "\n";let newValue = originalValue.replace(findText, replaceText);Every time I view the replaced results, there is always a \n in the output: Is it possible to ensure that Airtable treats \n (I’m even doing \u{005C} to try to get around it and it doesn’t

Hello,I work for a print company and want to send Airtable data through API to make what's called a JDF ticket which Esko’s Automation Engine can then use.Does anyone have any experience with this?Our main label database software does this, but I want to replace it with Airtable because it is heaps better. Thanks!

When using the Airtable JS SDK, it seems impossible to use the offset with select to do proper pagination. The type specifies `number` but any value I pass gives me an invalid value error. The web API uses a string offset that's returned from the request. Since this is TS, you can't use a string value with the SDK. Is it possible to paginate with the JS SDK?

Hi there,I'm facing this issue unfortunetly i checked on the community but none of the solutions work for me.This is the error: "type" Invalid_Offset_Value - The value of offset 100 is invalid.I'm trying to get 350 rows. I already did a first api call to get the first 100 rows, what i need is to continue with the second call.When i try this url https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome everything work fine, when i use the same URL adding the offset value, i get the error: https://api.airtable.com/v0/appOwBv51ihqo****/TableName/?fields%5B%5D=Mese%20Nome&offset=100What am i doing wrong? I can't work much on the cod

let twoLettersToNumber = { "ah": 5, "ch": 8, "wh": 16, "tz": 18, "sh": 21, "ta": 22, "th": 22,};let lastLetterToNumber = { "m": 12, "p": 12,};let letterToNumber = { "a": 1, "b": 2, "c": 11, "d": 4, "e": 5, "f": 18, "g": 3, "h": 5, "i": 10, "j": 10, "k": 19, "l": 12, "m": 13, "n": 14, "o": 6, "p": 17, "q": 19, "r": 20, "s": 15, "t": 9, "u": 6, "v": 6, "w": 6, "x": 15, "y": 16, "z": 7,};/** * @param {string} token * @param {{ ah?: number; ch?: number; wh?: number; tz?: number; sh?: number; ta?: number; th?: number; a?: number; b?: number; c?: number; d?: number; e?: number; f?: number; g?: number; h?: n

In my automation script I am running a fetch request. In some cases the fetch requests takes longer than 30 seconds which results in an error. I don't really care about the fetch request result because it is a post request that is doing all it needs to however the error each time it runs is annoying.Does anyone have any suggestions on how I can run the fetch request without waiting for a response? Or perhaps there is a way to handle the error gracefully?

I am trying to understand how Airtable API Rate limits work. It says 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. Is the limit per base per API key or per base per IP address?. Saw an answer in the forum but it is 4 years old and mentions airtable plans to change how it works. I ran a simple code to try and trigger rate limiting but airtable api was able to successfully respond to more than 20 api requests per second without running into api throttling

Hi, in order to consent my bank service platform to receive api requests from airtable, I need to put on his whitelist the ip address from which API Requests comes.Reading documentation I found they should be 52.44.24.118 and 3.215.151.50but not working...Any suggestions?ThanksPeppe 

Hi everyone,I’m working on a workflow where I’d like to bring live job costing data from QuickBooks Online into Airtable, specifically linked to Projects (i.e. QBO “Customers” with IsProject=true).The goal is to have Airtable show income and costs by project, so that project profitability and job cost tracking are always up to date. Ideally this would cover both accrual (Invoices, Bills, etc.) and cash-basis (Payments, BillPayments, Expenses, Checks, etc.) transactions — pulling the amounts tied to each project’s CustomerRef and syncing them into Airtable tables for Projects and Job Cost Lines.Has anyone here implemented something like this — a live sync or near real-time integration between QuickBooks and Airtable for job costing by project?

Hi everyone,I'm looking for advice on implementing a nightly data sync workflow.My Setup:CSV file with 25,000 records that needs to sync to an Airtable table Currently using the Sync API, which has a 10,000 record limit Need to perform a complete refresh (delete all + re-sync) every nightThe Challenge: Since my dataset is 2.5x larger than the sync limit, I need to send the data in 3 batches. However, I'm struggling to find the right approach to:Clear the entire table before syncing Successfully sync all 25,000 records in multiple batchesWhat I've Tried:Various sync configuration settings Setting up a webhook-triggered automation to delete all records before syncing Different batching strategiesMy Question: Has anyone successfully implemented a nightly sync workflow for CSV data that e

Dear Airtable community I need your help, please. We’re currently using Pipedrive (PD) to track our customers throughout the sales process and I’d really like to automate adding information to Airtable (AT). Does anyone know if there is a way that, when an orders is WON on PD that this customer record can automatically be created in AT? We have broadly similar fields, but from looking at Zapier, I can only see this linked to all activity updates/ creation of records, but not specifically something that ‘runs’ when an order is WON. Really hope you can help…! If I’m missing something that would help answer the question, do please ask and hopefully this is something that I can get up and running. Thanks in advance, Mark