Development & APIs

Hai,I am trying to connect Airtable in .net maui. I installed Airtable 1.4.0 ,AirtableEfcore 1.1.0 and CData.Airtable.EntityFrameworkCore. This is my codepublic class TestDbContext : DbContext{public TestDbContext(DbContextOptions options) : base(options){}public DbSet<Student> Master { get; set; }protected override void OnModelCreating(ModelBuilder modelBuilder){base.OnModelCreating(modelBuilder);}}public class Student{public string Id { get; set; }public string Name { get; set; }}protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder){var services = new ServiceCollection();services.AddDbContext<TestDbContext>(o => o.UseAirtable("app66666Xep", "patSOBFs83Vv6"));var sp = services.BuildServiceProvider();var scope = sp.CreateScope();var db = scope.ServiceProvider.GetRequiredService<TestDbContext&

This connector method exposed the PAT in cleartext. If I share the Excel spreadsheet, the user can discover my PAT and query other company tables. They would need to know different table and base IDs. If my computer storage gets compromised, the hacker will get access to this PAT. Is there a better way to authenticate than using a PAT as a parameter?I do see a method in data source settings of query editor (PowerBI or Excel) called Web API but Airtable has deprecated its use.https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query

Hi all,I have a question about exactly when an 'update' change type notification would be sent via Airtable new Webhooks API.For example, say I'm writing some text into a 'Single Line Text' or 'Long Text' field, will my webhook subscription for 'update' notifications be called multiple times as the text is being entered, or will it debounce and wait some x number of seconds after I've stopped typing?In the documentation for webhook notification delivery, it states:If multiple changes occur in rapid succession, then we may generate only a single notification for them.Does typing text into a field, at a normal typing speed, fall into the category of 'rapid succession'?

From January 25th, 2022, we are rolling out a small change to the URL format for Airtable tables, views and records used by Automations triggers and actions. The change is that the base ID (appXXXXXXXXXXXXXX) will appear at the start of the URL. This change coincides with the recent decision to include base IDs in Airtable URLs throughout the rest of the product. The change in the record URL format will occurs in these places: The url property of a record output by a trigger/action. Example record output by a trigger/action: Record#url Before: airtable.com/tblXXXXXXXXXXXXXX/recXXXXXXXXXXXXXX After:airtable.com/appXXXXXXXXXXXXXX/tblXXXXXXXXXXXXXX/recXXXXXXXXXXXXXX The url property of a Table or View model retrieved by the Run Script action.

How can I change the API key to access token and get records on my browserhttps://api.airtable.com/v0/appJiy**pcKfS****p/Users?&api_key=keycj***N8PUCH***Previously it works like this^^^∆

Following is the error I encounter :  npm warn deprecated source-map-url@0.4.1: See https://github.com/lydell/source-map-url#deprecatednpm warn deprecated urix@0.1.0: Please see https://github.com/lydell/urix#deprecatednpm warn deprecated resolve-url@0.2.1: https://github.com/lydell/resolve-url#deprecatednpm warn deprecated source-map-resolve@0.5.3: See https://github.com/lydell/source-map-resolve#deprecatednpm warn deprecated osenv@0.1.5: This package is no longer supported.npm warn deprecated inflight@1.0.6: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and te

i have a button field that run a script, i need to get tha field id(recordId) after press the button in the script, in some examples they recommend to use recordAsync(), but i have to chose the record, and i need to get it after press the button

Hi,I would love to able to share custom apps with external users. Maybe someone has an idea if I can realize that using the airtable interfaces. Dashboards can be build super quickly. In general, I have a straight-forward use case:We are using Airtable as CRM and would like to allow customers to access their data / i.e. an overview of their data. It would be great if we could just send them a link and they immediately have access to a dashboard. Is this somehow realizable? 

I am syncing my Google Calendar with airtable - one way: I'm adding the bookings on Google Calendar and they display on my airtable calender view. Today, none of my bookings after tomorrow is showing on my Airtable. Is there something wrong? 

I have a database with two tables “gifts” and “status”. I'd like to use a button to update the status automatically via a script. I searched the documentation and the forum, but I couldn't find any solution to adapt the script to my problem. Here's the code I've already added, and the options I've explored.This is my code :// Récupère la table Cadeaux let tableCadeaux = base.getTable("🎁 Cadeaux"); console.log(tableCadeaux); //Récupère le champo statuts de la table Cadeaux let statut = tableCadeaux.getField("✅ Statuts"); console.log(statut); // Récupère le record.id de la table Cadeaux let queryResult = await tableCadeaux.selectRecordsAsync({fields: []}); let record = queryResult.records[0]; console.log(record.id); // Récupère la table Statuts let tableStatuts = base.getTable("✅ Statuts"); console.log(tableStatuts); let newRecordIdToLink = '🎁 Réservé'; tableCadeaux.updateRecordAsync(record, { "✅ Statuts"

Here the working script extension: // Create script output descriptionoutput.markdown( "# Stores with 2+ WO in 30 days" ); // Set Tableconst woTable1 = base.getTable( "BR_Details" ) // Set Viewconst woView1 = woTable1.getView( 'Stores with 2+ WO in 30 days' )

I have the following TS code (using the Airtable REST API) export const updateInstanceQRCode = (instanceId: string, qrCodeUrl: string) => { return base('Instance').update([ { "id": instanceId, "fields": { "QR Code": [{ "url": qrCodeUrl }] }, }, ]); } which works great when I am testing in development, but the moment I try to build the project, I get the following error: > tsc -b && vite build src/externalAPI/AirtableClient.tsx:127:21 - error TS2739: Type '{ url: string; }' is missing the following properties from type 'Attachment': id, filename, size, type 127 "QR Code": [{ ~ 128 "url": qrCodeUrl ~~~~~~~~~~~~~~~~~~~~~~~~~~ 129 }] ~~~~~~~~~ Found 1 error. In my package.json, I'm using the following version of the official airtable module:&n

Is it just me or is anyone else having trouble with api calls on interfaces?Get / Delete / Add workspace or base collaborators work perfectly fine. But seems like anything to do with interfaces in not found. The below specifically.Even putting the URL directly in my browser gives 404, instead of a permission error. Anyone else? 🤔 🤔Get interfacegethttps://api.airtable.com/v0/meta/bases/{baseId}/interfaces/{pageBundleId} Delete interface collaboratordeletehttps://api.airtable.com/v0/meta/bases/{baseId}/interfaces/{pageBundleId}/collaborators/{userOrGroupId}Add interface collabor

Hello there, I'm trying to write data from one base to another through Airtable's API. My JSON is something like this:  let body = { "fields":{ "prod_serv_cia_id": inputConfig.cia_id[0], "NroParte": inputConfig.codigo[0], "DescripCorta": inputConfig.descrip[0], "DescripLarga": inputConfig.descrip[0], "Marca": inputConfig.marca[0], "Cantidad": inputConfig.disp[0], "Costo": inputConfig.costo[0], "AlmacenesScript": inputConfig.cia[0], "StatusProducto":[ { "id": "selq********yr", "name": "1. Producto seleccionado" } ], "typecast": true }, }  And the response I'm getting from the Airtable's API is:  {error: Object} error: Object type: "INVALID_VALUE_FOR_COLUMN" message: "Cannot parse value for field StatusProducto"  The "StatusProducto" field is:

I'm developing an api in which Airtable will request information, I was configuring cors for the api to accept requests from airtable, but I don't know which domain they use

Probably a simple solution, but I can not figure it out. I am using the following script to try to get a list of all of the records in a specific table.let table = base.getTable("Codes");let query = await table.selectRecordsAsync();console.log (query) When I run this, I get the following error O: No field with ID fldwfud1d0wv3rdVD in table 'Codes' at main on line 2When I run this same coding using one of the other tables, it works as expected. Any ideas on how to fix t

Hi there, This question is for the Airtable team. I see that you are using browserify to bundle the block code, would love to also be able to bundle external css files with the block, instead of loading them asynchronously using loadCSSFromURLAsync (which also makes development and deployment more complex). There are quite a few browserify transformation packages that can make that happen, but I haven’t been able to make them work so far, when trying to control browserify transformations from the package.json file. Here are the packages I tried / found so far: brfs - doesn’t work with es6 modules brfs-babel - doesn’t do the transform, for some reason, even when i add {"browserify": {"transform": ["brfs-babel"] } } to package.json

Hi, We are looking for ways to pull data from our Linnworks.NET account (basically and order and inventory management platform) to Airtable. So far we have been using MiniExtensions to import csv files with data exported from Linnworks to Dropbox or FTP server. This has worked well, but MiniExtenions have a limit of 10 instances of their csv import app, meaning that we are limited in the type of data we can import. We have already hit this limit. I realise that the best solution for transferring data would be via api, but I am not yet very familiar yet with writing api calls. The big stumbling block to this going ahead, from what I can see, is managing Linnworks Authorization. Linnworks Developer Resources - API Home My question is a general one. Does Airtable scripting allow means to acquire auth tokens an

I am building a web application for my students using Node.js/Express that displays information from an Airtable base.  Instead of embedding a table of news stories, I want to pull several fields from the table and insert them into the DOM so I can design the display of information. I've been able to send 3, 5, 10 stories to the console, but when I try to send a second story to display on a web page, I keep running into this error:  TypeError: Cannot read properties of undefined (reading 'offset') which points to part of airtable.js that compares result.offset with params.offset. I've tried to find an offset in the json but I don't see the key or values beginning with itr.I tried to call record.offset but it is undefined.

When adding data to Airtable records using Softr, I encounter a significant delay of around 4-5 minutes for the data to appear upon refresh if the records contain foreign keys referencing another table. This delay contrasts sharply with the immediate addition and display of data when records are added to a normal table without foreign key references. The presence of foreign keys seems to introduce a lag in the synchronization or processing time, leading to a noticeable delay before the updated data is visible. This issue may be attributed to the additional steps required to validate and integrate the foreign key relationships within the database, causing a slower response time compared to simple table updates.

I am using Voiceflow to retrieve data and send it to Airtable via the API. However, I keep encountering the above error despite my request appearing to be correctly formattedThis is in my body.  { "records": [ { "fields": { "first": "test", "second": "test2", "tel": "000000000", "email": "test@test.com" } } ] }   And in Airtable my table looks like this: firstsecondtelemailAny help would be good, thanks

Hello ! Is there a way to download the documentation of the API in an OpenAPI  / .yaml version ?Thank you!

How to access all WordPress posts using AirTable using REST API?

Hi, I am getting an error when using POST via Postman. I am copying the example exactly from the API documentation and changing the authorization key. I have tried changing the content type, modifying the fields, but nothing worked. GET method is working. Why is this?

Hi AllI am having issues with linking information between tables.I have the below linked:1) Master Order Table 2) Order Line ItemsI wanted to create a new table called Purchase Orders (POs) which is just relevant purchase order information (excluding any sell price etc from the master order) so i can send the PO to my suppliers.The issue i am having is that the information on the POs table is not linking with the Master Order or the Order Line Items tables as per attachments. Please help me with solving this.Thank you!