Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,632 Topics
  • 11,602 Replies
3632 Topics
A
Ajay_KumarNew Participant
asked in Development & APIs
How can I transform ‘List’ or ‘Record’ field types from Airtable into readable values in Power BI, especially for selects, linked records, and collaborator fields?

Some field types including single selects, multiple selects, linked records, and collaborator fields will show “List” or “Record” instead of the values you may be used to seeing in the Airtable grid view. This is consistent with how the Airtable Web API returns information.

323
Alexey_Gusev
U
UmerSajjadNew Participant
asked in Development & APIs
How to Prevent Webhook Retries

Hi there,I am using webhooks to send data from our base to our application endpoint, but we've observed that if our endpoint fails to respond correctly, the webhook is retried many times.While we work on making our endpoint more resilient, the volume of retries can cause issues.Is there any setting, configuration, or recommended best practice from your end that we can use as a workaround to prevent or immediately stop a webhook from retrying upon the first failure?Our goal is to have more direct control over the retry behavior to avoid overloading our systems during an incident.Thank you for your guidance.

162
Mike_AutomaticN
B
BobbyANew Participant
asked in Development & APIs
What does User role: Enterprise admin refer to?

I’m having trouble making a successful API request via Postman, and a co-worker pointed out that the documentation says a requirement is for the user to be an “Enterprise admin”.See here: https://airtable.com/developers/web/api/hyperdb-table-read-recordsWhat admin roles, listed on the page below, does that refer to?https://support.airtable.com/v1/docs/admin-roles-in-admin-panel-overview-and-managementMy current role is an “Integration admin”. Does this role count as an “Enterprise admin”? Do all those listed roles count? Are these different contexts? 

101
TheTimeSavingCo
H
HokNew Participant
asked in Development & APIs
Batch_Upsert vs. Batch_Update performance

Heya everyone!So I noticed that on the Airtable update API endpoint they note about upserts:Airtable reserves the right to throttle upsert requests differently from the standard rate limit throttling policy.Intuitively, I’d assume that differently means that they’re more strict about it as they’d be doing comparisons on their end.Does anyone know whether upsert is throttled more aggressively than plain updates? I’d assume so but I thought I’d get it cleared up.Thanks!

422
H
C
chris64New Participant
asked in Development & APIs
How can I use input.config to get object not just an item from the object

I have an object that I output from another script using the Output.Set(key: value) method. The value that I’m passing is an array of json objects. It seems that there are a lot of objects to transform the object but I would prefer to just pass the object to my script to iterate over the object and use dot notation to get the values that I would like.  I don’t see anything that just lets me keep the object as is and pass it through input.config only transforms or operations like length? Is there no way to pass an array or object??

313
T
Q
QPerryNew Participant
asked in Development & APIs
Airtable Token Permissions

Hello everyone, I hope you can help me! I am creating an product database for internal purposes. I have created a Softr interface and I want to have a customer chat bot to can answer basic queries such as “Does this product have x feature?” “What is the price of this product” etc… I have managed to create everything with the help of Chat GPT (I can’t code!) but once issue remains, when I try to trigger a database search, it constantly returns with “I can’t find this product”. I have searched the console, it says it cannot access the database because authentication is required and returns an error 401 or 403. I have checked the token, the database ID all and everything is correct, so I am a bit at loss! I am the owner of the database. Hope someone can assist with this, thanks in advance for any advice!

6310
Q
N
Nagendra Babu PasamNew Participant
asked in Development & APIs
OAuth Error on Authorization request

I've registered a new OAuth integration record on my dev instance of Airtable, however when trying to perform the first step of authorization by getting a code I am presented with the following error:There was an error during grant authorization. Close this window and try again or contact your system administrator for details.

333
BuildForAT
R
Rose_Haft1Inspiring
posted in Development & APIs
Create Custom PDF

Hi there - I have a list of outputs and am trying to create a PDF listing those. Is it possible to create a PDF via script? Or what other methods are there other than one line per PDF? How could you use the PDFs if linking all records to one record in another table?

5598
P
4N85_2
4N85_2Known Participant
asked in Development & APIs
0Auth Permission Window won't load

We are trying to set up an 0Auth connection for retool. Unfortunately the Dialog to define Scopes and select the Base does not load/open at all. When I click “grant Access”, a loading wheel appears but nothing ever happens. Does anyone have an idea where the problem could be ?  

292
Mike_AutomaticN
B
bchannellNew Participant
asked in Development & APIs
Sync Jira on premise (not Jira cloud) sync?

Is there a solution to sync Jira which is an on premise version NOT Jira Cloud. When in the office I have access to both Jira and Airtable which are behind firewalls. Are there any solutions maybe with MCP Browserbase or other type of way to extract data not via API but through the browser and sync with Airtable. 

351
H
M
Markus_WernigInspiring
posted in Development & APIs
Can Airtable's own "Export CSV" be triggered via a script?

Here’s my thinking. I like the simplicity of Airtable’s own “Export CSV” function. Data in a spreadsheet as a simple backup is all I am after. If “Export CSV” could be triggered via a script, the entire process could be automated. A new record could be the trigger to run this script. Does anyone know if this is even possible? Thank you!

20928
ScottWorld
T
thataspieNew Participant
asked in Development & APIs
Can’t Import from Google Sheets — “Something is wrong with Google API” Error

Hi all — every time I try to import a Google Sheet into Airtable, I get this error:"Can’t import from Google Sheets — Something is wrong with Google API."This happens regardless of which sheet I try. The sheet is shared properly and I'm logged in with the right Google account. Is this a known issue with the Google Sheets sync or a permissions problem? Would appreciate any tips on fixing or working around this (besides switching to Excel!).Thanks!

374
Andy_Cloke
G
GrimiKnown Participant
posted in Development & APIs
How to convert emails to PDF?

Hi all 🙂 Please, is there any way so I can convert emails to PDF?I have a TaskRobin integration, and would like to save my incoming emails in PDF format.Thank you 🙂

221
Daniel_C
C
Chef TarikNew Participant
asked in Development & APIs
airtable for kitchen management

Hi Dear community I'm building an app for kitchen management specially recipe costing Need somebody to guide me for developing the apps introducing interface and adding tables for inventory management I'm  new and passionate to aittable  Please give me advice without costing a fortune .…Kind regards 

514
T
P
pazhamalaiInspiring
asked in Development & APIs
Can we have a function to convert record object into serializable format as per the Get Record api?

I’m creating an extension here. Often times I want to send record from extension to my backend api. My backend already supports the json serialized format returned by get records api. It would be very helpful if there is a method to convert record object in blocks sdk to that format. Or is there already a way for that?Thanks

221
hwmedhin
M
Maria_AlvarezNew Participant
posted in Development & APIs
Same Table Linked Records Backlinks automatically

Thanks @openside for your famous post "New Script: Same Table Linked Records Backlinks".Is there a way to use this in automation so that whenever the Parent task is updated, the child task runs? How would you need to modify the script?

943
ScottWorld
D
divingintuxNew Participant
asked in Development & APIs
Airtable Script to Multiple A (Record) Value by A Constant

Hi, I’ve been using Airtable for a few years and a heavy automation user with Make.com and Zapier. However, I don’t have any programming experience whatsoever.The script is used as one of the steps in my Airtable automation. I’m in need of a script that:Takes a value from a field Multiple that value by -1 (negative 1) Return that value as input for the next step in my Airtable automationI’ve just started online course on Javascript, but this course obviously takes time and I need the script right away. It would be great if someone can help me out with this so I can implement it right away. From my online course, I know that the code should be straight forward enough even for someone with basic command of Javascript.Thanks!

485
D
N
ncl1805New Participant
asked in Development & APIs
Deleting and Reordering Fields

I’m using the pyairtable python package, and I’m looking for a way to delete columns in a table and reorder columns based on how they are named (e.g. if the columns are dates, I want the most recent date to be the left most column). Not sure if there is a way to do this using python, but I’m hoping I wont have to do this manually. Thanks in advance!

614
Alexey_Gusev
A
alfredoigmenNew Participant
asked in Development & APIs
Is there a way to scan documents in Airtable?

I have a lot of documents that want to organize. Airtable only allows photos. It would be great to add a scan feature.

603
Andy_Cloke
M
mpalsfNew Participant
asked in Development & APIs
How long before Twilio activation

I just signed up for Twilio, including a A2- 10DLC registration. I tried to send a couple test from Airtable, but Twilio says Undeliverable because I’m not registered. Does it really take up to two weeks to have an A2p 10DLC registration approved? Is there anyway to send or test twilio in the meantime?

231
ScottWorld
A
atusrKnown Participant
asked in Development & APIs
Airtable MCP for CLaude

Any plan to launch an Airtable MCP to allow us to manage AirTabLe from CLaude chats as efficiently as we’re currently able to manage Notion from CLaude?

6311
Mike_AutomaticN
O
opensideInspiring
posted in Development & APIs
New Script: Same Table Linked Records Backlinks

Explainer Video: Base: Airtable Same Table Backlinks - Airtable Universe Title: Same Table Backlinks License: MIT Author: Openside (Team behind On2Air products and BuiltOnAir community) Sites: https://openside.com - Openside... Code: gist.github.com https://gist.github.com/on2air/b68450a877ab99fe4a93ef7f9c387568 same-table-backlinks.js /***** * Title: Same Table Backlinks * License: MIT * Author: Openside (Team behind On2Air products and BuiltOnAir community) * Sites: * https://openside.com - Openside Consulting Services * https://openside.com/#products - On2Air Products * https://builtonair.com - All things Airtable Community * * Reach out for all your Airtable needs This file has been truncated. show original

15465
Mike_AutomaticN
Théau12
Théau12Known Participant
posted in Development & APIs
Airtable Shopify Integration

If anyone is interested we created an Airtable Shopify Integration (SyncBase) as we needed it.It instantly syncs your store data both way so you can update your products catalog, received orders to follow your raw materials stocks and do a lot of others importants operations.We planned to create our custom ERP on Airtable and then use this app to received and send data to Shopify.Happy to get your feedbacks in order to improve it!

22710
Théau12
W
WalleyeNew Participant
asked in Development & APIs
ODBC, MailMerge or Complete Multipage Letters

Howdy all, I promise I really have looked at exisitng topics but there is information overload. Ideally I would like ot use ODBC driver to connect to AT to Windows via ODBC driver, I found several but they are all expensive subscriptions.  It seems AT may have its own ODBC driver now??  But I can’t find it anywhere in the AT documentation. What is the best extension or method to use data from multiple tables within a base, fill in essentially form letters WITHOUT using the extensions that you have to put the information boxes on the template.   The data I have for the body of the “letters” is sometimes several pages and I can’t find an extension that doesn’t chop off the rest of the text once it goes beyond the bottom of the information box or window we placed in the page setup.  We are printing the letters to PDF. Any suggestions for something that would act as “mailmerge” or is an annual ODBC sub to CCData or Devart the best way to go?? Thanks!!!

402
W
D
dodo21New Participant
posted in Development & APIs
How to create a new base with api

I'm following the documentation correctly but getting"error": {"type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message": "Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct."}Even though my access token has all the permission that I can add init. Also it has permission for viewing all the bases and all the future base

203
K

Badge winners

Show all badges
Terms & Conditions