Development & APIs

How to export Table into MYSQL table file or CSV?Can be synced table from Google Sheet into MYSQL?

I am currently trying to set up the Google Cloud Vision API via an extension in Airtable. When adding the API key, I am currently getting the following error:'Cloud Vision API is not enabled. Enable the API.'However, I have followed all the steps required for the API to work:1. Created a Google Cloud project 2. Set up billing 3. Enabled the Google Cloud Vision API, added it to my project and generated an API key.I am still getting the error message despite having disabled and enabled again, removed and re-added the extension and deleted and re-created an API key.I would be grateful for any additional suggestions regarding how I can add this extension.Many thanks,Jamie

Dear Airtable lovers, could you suggest me how to create a simple Alfred App search workflow for simple searching of defined base? More about Alfred workflows: https://www.alfredapp.com/help/workflows/. Thanks!

Hello Community,I am new to airtable. I have already created different tables in airtable database. Now I want to add data in airtable from outside using python script and later I want to update certain airtable data. So is there any way we can do it ? I am new so any blogs or threads which provides answer to this will be helpful. Regards,Viraj 

Can the buttonAsync be created dynamically? I have an array of Order Numbers called filteredOrderNames. Can each value of the array serve as the button label? let selectedOrder = await input.buttonsAsync( 'Select Order Group from List below', [ {label: filteredOrdersNames, value: filteredOrders} ]);

Hey there,The "Insights" tab in our base is so useful for clean-up, and one of my favorite features is when it tells us which views in our base haven't been accessed for 90+ days. We're doing a base audit to clean things up, and we want to go through all of our views in a slightly more programmatic way. From the API docs, it looks like the metadata we can pull about a view doesn't contain its "last accessed" date, or anything like that:The only way I could think of to access this data would be to pull our Enterprise logs, search by view ID, and then grab the most recent date stamp for each access. That seems like a rather painful workaround, and since the data is already packaged so nicely in the insights tab, I was wondering if there's a workaround anybody knows of to grab it more quickly without having to do a brute force search. TIA!

Hi, I used the HelloWorld TypeScript example, installed and imported the @octokit/rest package to interact with GitHub and now I get the following error. The module is @octokit/rest present in the node_modules, vscode uses types from the package OK.Is there some caveat on using third party NPM modules?Running NodeJS 14 (per docs) and @airtable/blocks 1.18.1 $ block run --http Updating bundle... Bundle Error: Cannot find module '@octokit/rest' from '/workspaces/airtable-run-github-workflow/build/development/transpiled/user/frontend' Your block is running locally at http://localhost:9000  

Hello!If I want to add a checkbox to a rich text field I simply type [] and checkbox appears.But the same does not seems to work over scripting. I tried all kinds of combinations of `[] ` and `- [ ] ` and so on with no success.```let formattedInstructions = instructions.map(instruction => `- [ ] ${instruction}`).join('\n');```Maybe it's not possible right now?Thank you!

As per the title, has anyone connected a standard html form to Airtable? I’m struggling to work it out and need a little help.

Trying to set up the barcode generator (Little Appy Co) suggested by airtable - however the content field is not valid. I have tried all the suggested field types numbers / auto number / single line text etc but still telling me when I try to generate invalid field. Does anyone know what I am doing wrong. 

Field Type and Compatibility:Ensure Field Compatibility: Verify that the barcode generator field is compatible with the system or software you are using. Some platforms may not support custom field types or require specific configurations.Check Documentation: Review the documentation for your platform to see if there are specific requirements or supported field types for barcodes.Configuration and Setup:Field Configuration: Double-check that the barcode field is configured correctly. This may include setting correct parameters, like the type of barcode (e.g., QR code, Code 128), and ensuring it’s linked to the appropriate data source.Validation Rules: Ensure that any validation rules applied to the barcode field are correct and not causing it to be flagged as invalid.Integration and Implementation:API or Plugin: If using an API or plugin for barcode generation, make sure it is correctly integrated into your system. Verify that all necessary libraries and dependencies are installed and

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>();TestDbContext Db;var x = db.Master.ToList();}But I could not get a connection Services is null.Please help how to get connected. Thanks 

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. Example run script: Table#url Before: airtable.com/tblXXXXXXXXXXXXXX After: airtable.com/appXXXXXXXXXXXXXX/tblXXXXXXXXXXXXXX View#url Before: airtable.com/tblXXXXXXXXXXXXXX/viwXXXXXXXXXXXXXX After: airtable.com/appXXXXXXXXXXXXXX/tblXXXXXXXXXXXXXX/viw

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 tested way to coalesce async requests by a key value, which is much more comprehensive and powerful.npm warn deprecated are-we-there-yet@1.1.7: This package is no longer supported.npm warn deprecated npmlog@4.1.2: This package is no longer supported.npm warn deprecated gauge@2.7.4: This package is no longer supported.npm warn deprecated @babel/plugin-proposal-nullis

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": [ record.getCellValue("&#99

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' ) // Get records from viewconst woRecords1 = await woView1.selectRecordsAsync().then(result => result.records ) console.log( woRecords1 ) // Set new report name and descriptionconst reportName1 = 'Stores with 2+ WO in 30 days v01' const reportDescription1 = 'Locations with 2 or more Work Orders in the last 30 days v01' // create new report including linking of tasksconst reportsTable1 = base.getTable( "Reports" ) const reportRecord1 = await reportsTable1.createRecordAsync( {"Name" : reportName1 , "Description" : reportDescription1 , "Linked BR_Details" : woRecords1 } )if( reportRecord1 ) // Update{const res1 = await remoteFetchAsync( 'https://api.docsautomator.co/cr

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: "dependencies": { "airtable": "^0.12.2", This definitely seems broken, especially c

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 collaboratorposthttps://api.airtable.com/v0/meta/bases/{baseId}/interfaces/{pageBundleId}/collaborators

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:  {id: "fld*******j9", name: "StatusProducto", description: "", type: "singleSelect", opt