Development & APIs

To create a base through API you  need to provide a workspace_id -> https://airtable.com/developers/web/api/create-baseBut I can't find a way to list the workspaces a token/user has access to. How do I get the different workspaces for a token (in non-enterprise accounts) ?

Greetings devs! First post here after doing a bit of googling to no avail… I’m looking for an example of how to upload a zip archive to an attachment field. In the documentation there is mention of attachment objects but no mention of how to create one pro-grammatically. Any sample code or general guidance would be helpful regardless of language although Python would be greatly appreciated! Cheers, Jean

Hello, we have had 422 errors in our integrations suddenly, when trying in post man everything works correctly but from the VB.NET application the same record gives error 422, this is happening in several integrations from different databasesEdit: for now all api integrations are working fine, check yours

Goal: importing JSON from an open API into my airtable base.How: Using a script extension in the base (at the bottom of this message), with proper error logging.Result: No return after “let response;” The script just seems to stop without any error triggering. The last log is “console.log("⏳ Start fetching domeinen data...")”Test that does work: A curl request to the API does yield the complete JSON, just as a request through postman. So the API is reachable.The code to request and import the data:  // API credentials let apiKey = "(API key censored, but it's working)"; let apiUrl = "https://opendata.slo.nl/curriculum/api/v1/domein/"; // Function to fetch the domeinen data async function fetchDomeinen() { console.log("⏳ Start fetching domei

I have implemented OAuth integration with Airtable.However, if the users want to switch another account, they cannot do that because browser stored last login session. Are there any way to get rid of it ?

I am looking to Run a script in an Action. basically whenever the Category “Done” or “Postpone” is set to the record by single select field. I like to run a script that deletes those records. The trigger is pretty much easy to do by the automation configuration. The script is the one I didn’t figure out how to do.

If anyone is interested, I wrote some code to sync over new Shopify orders to Airtable using the Shopify Order Created webhook and the APIs of both platforms. The code can be found in this Github repo:https://github.com/codeupify/functions/blob/main/shopify/airtable-order-integration/README.mdThe code is in Python and using Flask as a webserver that you can host somewhere. There is also a serverless solution available here if you don’t want to spin up your own server:https://codeupify.com/f/yMYerkEaOB

Hi there, I have the automation example in Airtable that sends a digest email of certain records for yesterday (in our case, overrun on tasks). On days when there was no overrun, the email would still send but would be blank, which is not appreciated by management. I found this script in the forums here that helps prevent the email going out BUT it means I get an error alert & email instead, and it makes me go and check the automation is still working: // A script to stop the automation running when no records are found. // This prevents blank emails being sent. // See: https://share.support.airtable.com/2NuwnyDD?method=GET let numRecordsFound = input.config().numRecordsFound; if (numRecordsFound < 1) { throw Error("No records were found. Aborting so no blank emails are sent.") } Is it possible to stop or exit the automation silently, without throwing an error? Many thanks in advance, Chris

I am trying to use the API request to retrieve comments from a record using the following URL: v0/{baseId}/{tableIdOrName}/{recordId}/comments. However, I encounter a '[404] NOT_FOUND' error. I am using an OAuth connection in Make, which works when I use any other request, such as a simple 'Get a record': v0/{baseId}/{tableIdOrName}/{recordId}.

Looking for an API that can be. used for integration purpose to fetch all the data related t the subscripted plans 

Suddenly my api calls have stopped working and getting error code 422 INVALID REQUEST.  Didnt change anything its the same requests that have worked for months and now nothing works

I using airtable's api by connecting it to front end in flutter and a javascript backend using vercel function,these functions are working in dev environment but not in productionfunction call in front end in flutterFuture<void> createRecord(String firstName, String lastName, String address, String phoneNumber, String password, String personalMobileNumber, String salary, String role) async {final String url = 'crmvercelfun.vercel.app/api/addemployee';

Hey All,This forum has been of great use to me over the years, and wasn't able to find evidence of this solution in existing posts, so figured I would share!When designing a multi-button script in the Scripting extension, I found myself wanting to make buttons with labels of different character length of equal size.Turns out Braille Pattern Blank (U+2800) is a good enough solution.  // Create the initial buttons let action = await input.buttonsAsync('', [{label: '⠀⠀⠀⠀⠀⠀⠀⠀⠀New Business in Existing Storefront⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀', value: 'New Business in Existing Storefront', variant: 'primary'}, {label: '⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀Business Relocated⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀', value: 'Business Relocated', variant: 'primary'}, {label: '⠀⠀⠀⠀⠀⠀⠀Busines

Has anyone figured out how to move an AirTable table onto an SQL database. I use Air-table for everything, but I’m starting to run into issues with the 100 record limit that Airtable imposes. Unfortuntely, it is a proprietary plugin making the API requests and it generates an error when the user retrieves over 100 records at a time (leaving many records blank). Does anyone have codebase or ideas on how to ‘sync’ Airtable records into an SQL database, which can then be queried by a web app that displays dynamic content. I don’t want to move away from Airtable as a CMS because its so easy for other project collaborators to use for data entry.

Hi, I would like to import a CVS file into my base and write an automation to adapt the file to my base on airtable. For example: the title of the colums are different on each, some info need to be extracted but others not. Does someone have a script for that ?  Thank you so much !

Hi, I am trying to use REST API to retrieve data from a base that includes both the records from a primary table and the linked records from a related table in a single request.  Is there a way to obtain this data in just one API call? Know that in SQL, a single query can fetch data from multiple tables in one request, but Airtable has me stumped. Any guidance is much appreciated. Thanks in advance. 

Recently I have issue with my JIRA integration (JIRA cloud) table "Intenal sync error".So I have this sync table on Airtable for JIRA tickets that had been working fine:1. We have a master table of items2. We have a sync table from JIRA3. In the master table, there are a link to record field to the JIRA table: we can track tickets relating to the items.Yesterday, I did some revision of fields on master table as well as table permission, I did not modify the synced table. Later on, I noticed the synced table is not working anymore. I tried to revert the setting of permission on fields and tables. On 1 try it worked and then not working again eventhough nothing is changed. I have also tried to create a new sync table but it only works for the first time. It was actually quite bizzare.Hope you have some experience with this or able to lend me some he

I have a Search records Airtable module in Make, which, given the same data, sometimes searches for a record correctly and sometimes not. Have you encountered such a situation? What could this be caused by? The data is literally identical in both cases. 

Trying to deploy my custom app to a Base and keep getting this error: Running locally - successfully deployed Mac OS Safari Browser (cache cleared) { “error”: “FORBIDDEN”, “message”: “You can only run your development block in the original base where it was created.” } There are no answers to prior posts about resolving this. Anybody have a way to fix this?

Hi everyone! 👋I'm using n8n to automate some tasks with Airtable, and I want to make sure I don't create duplicate records in a specific table.Before adding a new record, I need to check if a similar record (based on a unique field, like email or name) already exists. If it does, I want to skip the creation step.Does anyone know the best way to check for duplicates in Airtable within an n8n workflow? Any tips or advice would be greatly appreciated!Thanks! 😊

I have a custom block running locally and wanted to share it with someone else on the team.  Based on the docs, it sounds like running `block release` would be the next step.  Doing so produces this output: Bundling... doneUploading... IncompleteError: ❌ The block could not be found. Make sure your API key is correct and that you have access to the block.Code: airtableApiBlockNotFoundI have some personal access tokens created with the `block:manage` scope, but it's not clear from the docs how or where the token would be used in a block extension.  The docs sort of hint at it being asked for during the init process, but `block init` doesn't seem to do that.  I also tried creating a new block from the Hello World example and then releasing it, and it had exactly the same error.I know there's an almost

Using the Airtable API, how do I change the order the fields of a table are displayed in?

Hello,I'm trying to run a script from BaseA to create a new record in BaseB. The new record in BaseB has a linked field, I followed this convention to reference it: Field_Name: [{id: record_id}]. I get INVALID_RECORD_ID error, though I've double-checked it and the record id is correct. What am I doing wrong? let createRecordInBaseB = await fetch( `https://api.airtable.com/v0/${targetBaseId}/${targetTableId}`, { method: "POST", headers: { Authorization: `Bearer ${baseARecord.pat}`, "Content-Type": "application/json", }, body: JSON.stringify({ fields: { "👀 Projects": [{id: projectRecordId}], }, }), } );   

Hello, I’m trying to understand the AT API when it comes to getting the values of a linked table. For example, in Table one I have the following fields: ID Entity Name List of Part IDs In Table 2 I have the following fields: ID Part Number Part Name So when I create the URL to pull the values in Table 1, how do I “lookup” and show the Part Number and Part Name from Table 2 for each Part ID in Table 1? I’m new to Airtable, and have spent hours and hours trying to figure this out, but so far have been unsuccessful. All help will be greatly appreciated. Thanks, George

I am struggling to connect Airtable to PowerBI and was wondering if anyone was able to accomplish this?Here are my steps following the write-up from here: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable SupportOpen Blank Report in PowerBISelect Get Data > Blank queryFrom Home Tab click on Manage Parameters > New Parameter.Add the NameType > Select TextSuggested Value > Any ValueCurrent Value > Enter Token ID      This is done for PERSONAL_ACCESS_TOKEN, BASE_ID and TABLE_IDPlease note, TABLE_ID was taken from the URL as marked in red below