Development & APIs

https://api.airtable.com/v0/meta/bases/myBaseIDhere/tables A particular base is very large. I only need table IDs and Names for this call. The JSON returned is HUGE and seems to an issue on my end. How do I get only this limited data with this call?Note: I am new to Airtable but there is so much data I don't need from a Table.  Thanks, ScottIDS

What is the exact way to delete multiple records on a table of Airtable with Make.com ?Thanks,

Hi everyone I am trying to create a hash of a record using md5. I am fairly new to script but I am willing to learn. does anyone have an idea of how to do that? Thank you

Hi, I’m getting an error when I try to use create a Javascript FormData object in preparation for posting to an API. I would have thought FormData would have been well supported. console.log(`Hello, ${base.name}!`); const endPoint = new URL('https://myserver.com/jsonAPI/'); const formData = new FormData(); formData.append("user", 'tom'); const response = await fetch(endPoint.toString(), { method: "POST", body: formData, }); console.log(response) Getting an error saying that FormData is not defined

Hi guys, I'm new to web development and i'm trying to use a serverless function to fetch data from airtable. The fetch function works fine before, but this morning when I check my application it shows `isAxiosError.js:10GET http://localhost:8888/api/products 500 (Internal Server Error).`I used API Key before for the authentication but I have already changed the API key to personal token. However, it still not working for my project. Can anyone help me to solve this problem? Thanks in advance.

Hi,I am having an issue to match the airtable-content-mac from the header with the one I computed following the instructions from the documentation .So we tried the following:const decodedMacSecret = atob('macSecretBase64'); //macSecretBase64 from create webhook const body = `{ "base": { "id": "appjRdIX59U4YEy4l" }, "webhook": { "id": "achXH94CxHYGdUcje" }, "timestamp": "2024-03-06T00:32:58.992Z" }` const hmac = createHmac('sha256', decodedMacSecret); console.log(body) hmac.update(body.toString(), 'ascii'); // I also tried JSON.stringify(body); console.log('received header: hmac-sha256=0fb79298bc57a45a34ca1d04f5237fd4a9a9223fd5c90cc04f35d3c3890180cc'); console.log('computed: hmac-sha256=' + hmac.digest('hex'));Thanks

Hi, I am having trouble connecting to the Airtable Library from Google App Script. Google App Script is asking me for a Script ID but I don't seem to be able to find one. I am also confused by the replacement of the Airtable API with PAT which I equally am unsure how to use. Any help would be very useful. I am a bit of a novice. Sorry.Ultimately, I simply want to copy some data from a Google Sheet into one of my tables.

If you navigate to: https://airtable.com/developers/extensions/api/models/Table, you can see a link for the Field model listed in the description for the fields member. However, if you click that link it bounces you back to an index page for the documentation not the documentation page for Field.The reason for this is because the link for Field is wrong.Documentation contains:https://airtable.com/developers/extensions/developers/extensions/api/models/FieldWhen it should be:https://airtable.com/developers/extensions/api/models/Field 

Hi,I've just started looking at creating an Extension, and one of the things I'd like to do is authenticate the user against Azure AD through either implicit or PCKE flows so I can then call internal APIs requiring an AD token. For a normal React app I would use the MSAL library to redirect to AD and then redirect back to the app on successful auth, this however doesn't appear to be possible within an extension due to the lack of callback URL.Is anyone able to help provide some guidance around whether this is possible within Extensions? Perhaps someone is doing something similar with Google/Facebook that may be able to help.Thanks!

Hey all,Been trying to implement Airtable webhooks for our company however i've ran into a slight problem with the signature of the webhook itself. No matter how I move things around, encode or decode, it refuses to match the signature provided by Airtable.The code below generates a HMAC but doesnt match the one provided by Airtable. I cant use the Crypto module since thats Node only which sucks. Is there any secret sauce that im missing from this code? All the docs say is to just decode the base64, shove it into Code below:const decodedMacSecret = atob(webhookConfig.macSecretBase64);const encoder = new TextEncoder();const data = encoder.encode(bodyText);const hmacKey = await crypto.subtle.importKey(  'raw',  encoder.encode(decodedMacSecret),  {    name: 'HMAC',    hash: { name: 'SHA-256' },  },  false,  ['sign']);const hmac = await crypto.subtle.sign(  'HMAC',  hmacKey,  data);const expectedContentHmac = 'hmac-sha25

Hello everyone,I am actually building a carousel using the Web API. I am going over the documentation and I cannot find a way to do what I want. I am trying to get the previous and next row with an id of one row in a filtered table.For exemple, I have the following data:ID |    Name    | Category1   |       D         | CategoryZ2  |       B         | CategoryZ3  |       C         | CategoryLIf I want to get the previous element and next element of B when the table is filtered by the Category column and Name column. In this case, the previous element is C and the next one is D, How do I do that using the Web API?The only thing I could maybe think of is a way playing with the "offset" parameter. Maybe I am missing something in the documentation.Thank you in advance

Am I missing something or Airtable does not have an input method to select a user (aka Collaborator)?What I want to do: create a script that first asks to select a user.I know I can create a workaround (below) but that is not my question... is there really no Collaborator input?(we are also missing a Date input since at least 3 years apparently - only solution is to parse text... for real?)Automatable workaround, for those interested:create a table, call it "Users" or somethingset two fields, Name (type: Formula) and Collaborator (type: User)set the formula in Name to just display the Collaboratorthen create one record per actual user of your base(optional) create an automation running at fixed time intervals that will look for all users (base.activeCollaborators) and add/remove records accordinglyNow in your scripts you can create a form asking for a user using the input.recordAsync method.I am baffled to seem to have to build this myself.

I can't find anything wrong. My access token has everything:When I try in postman i always get the error above. This is my post request:Yet I always get this error message: Help please? 🙂  

Hello,I use "Zoho Flow" app to integrate "Zoho creator" app to "Airtable"Through the process of mapping the fields, I am struggling to understand what is the "Record ID" that Airtable needs me to fill. Can you please advise? Knowing that I am creating a workflow that triggers on record edit.

I have created a personal token with data.records:read scope.I have created an action in OpenAI GPT with schema:openapi: 3.0.0 info: title: Airtable Direct Access API version: 1.0.0 servers: - url: https://api.airtable.com/v0/appM376pMJS0ddkXZ/tblbxbPFVM8FaZdos description: Airtable API server for the specified table paths: /records: get: operationId: getRecordsFromView summary: Fetches all records from a specific view in the table. parameters: - name: viewId in: query required: true schema: type: string default: viwPnVZGLgVvdOvsF description: The ID of the view in the Airtable table to filter the data by. responses: '200': description: Successfully retrieved records from the specified view content: application/json: schema: type: object properties: records:

I'm in the process of building my base for my business (I'm a literary agent) - I've recently discovered how useful views are and now have a much better sense of what I'm doing but I have a query and I'm wondering if there's a better way to set this up or if I really just have to duplicate these fields (I'm asking because i've seen a couple of posts that say you shouldn't ever have to duplicate fields...)So, my primary filed are the titles of each book under my agency. I then have views for the marketing info, the primary contract (in my case, UK) info etc.The two elements I'm struggling with are:1) Tracking international deals where there will be several countries which will each then need the same fields so that I can track for instance the contract info from the US, Germany, France etc - other than the language, the info I'll need to pull from each contract will have the same field headings. I could make this a separate table - but I'd really like the financial info to pull through

Hello dear community. I’m starting to learn to use iOS shortcuts and watched a couple of YouTube tutorials and I’m trying to run a basic post function but this error shows up: {“error”:{“type”:“INVALID_REQUEST_UNKNOWN”,“message”:“Invalid request: parameter validation failed. Check your request data.”}} I created a blank document and just wanted to input a new field data. I copied the URL from de Airtable API and also I copy the API key. This is how I typed the ‘code’: I’ll appreciate any help with this simple starter use of integration with iOS shortcuts.

Hi, I don't have much experience with API requests. I am trying to understand how it all works. I am currently using Node-RED (visual Node.js) to process the requests. I was able to complete a GET request and i'm now trying to do a PATCH request to update data in Airtable.I get the following error message when trying:type: "INVALID_REQUEST_MISSING_FIELDS"message: "Could not find field "fields" in the request body" Here is the schema in question:I am unsure where the API is expecting the request body.Here is my test JSON:{    "fields": {        "CCISF": 5,        "CORAMH": 5,        "RJCCQ": 5    },    "typecast": true} Do I have to include all fields present in the table or only those i wish to update with the PATCH request? Thank you.

https://api.airtable.com/v0/appv33ENPkh3E1ocj/Opportunities?filterByFormula=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fappv33ENPkh3E1ocj%2FOpportunities%3FfilterByFormula%3DAND(Email%3D'%7B%7BemailInput%7D%7D'%2C+OR(Stage%3D'Needs+Underwriting'%2C+Stage%3D'Make+Listing+Price+Proposal'%2C+Stage%3D'Due+Diligence+Items'%2C+Stage%3D'Appointment+Set'%2C+Stage%3D'Final+Underwriting+Review'%2C+Stage%3D'Follow+Up'%2C+Stage%3D'Long+Term+Follow+Up'%2C+Stage%3D'Negotiation'%2C+Stage%3D'Retail'%2C+Stage%3D'Closed+Lost'%2C+Stage%3D'Closed+Won')%2C+Record+Type%3D'Seller+Opportunity') Trying to use this request. Any advice to my logic? 

Does anyone have a solution for a script to run AND a URL to open when a button is pressed? I need actions within the base to be performed, but I also would like to redirect the user to a confirmation page once the button is pressed. I also have a near-identical use-case where I need to guide users to open a URL via a button to edit details on a record in another base, but I’d like to be able to know that they clicked it. Is there any clever way to additionally trigger an automation when the button is pressed (along with having the url open)? Thank you!

Hi All, I use the API to pull our data into Excel for automated reporting, and it does the job quite nicely :slightly_smiling_face: However, I’ve added a new column to collect a bit more information, but that column doesn’t seem to be available to select when choosing columns within the query. It’s a number field (although I have tried changing it to a text field, and a formula field in case it was the field type that was the issue). Any thoughts?

I'm trying to execute a simple API call to Fireberry:   const options = { method: 'POST', headers: { accept: 'application/json', 'content-type': 'application/json', tokenid: '...' }, body: JSON.stringify({accountname: 'Test'}) }; fetch('https://api.powerlink.co.il/api/record/account', options) .then(response => response.json()) .then(response => console.log(response)) .catch(err => console.error(err));   This exact call works in Make, but in Airtable it throws a 405 - 'Method not allowed'. It seems impossible to complete thi task without another tool like Make. Is there a fix / workaround?

Everybody, some years back I built with "PHPRUNNER" an application with airtable+rest-api.  That worked great, but as of February 2024 airtable has changed. An API key is no longer sufficient, but a token must be used (0auth 2.0 - User ) in PHPRUNNER.I have already created a token in airtable, but unfortunately I can no longer connect to airtbale and the application. Could you tell me if the parameters in the new connection are filled in correctly? Thanks in advance. See screenshot's. What am I doing wrong ?        

HI, this is my code for my payload posting to a table using Google Apps Script: var payload = JSON.stringify({"records": [{"fields": {"OnlineSubmissionLink": [{ "id": linkedRecordID }], // Set the linked record field// "SaleDate": formattedSaleDate,// "SalePrice": donationAmount },"typecast": true}]}); My log says: Constructed Payload: {"records":[{"fields":{"OnlineSubmissionLink":[{"id":"recXE6yQpMi1NyWRx"}]},"typecast":true}]} for my payload, but I'm getting this error: {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}} when I attempt to POST the Record ID into the linked record field.  Sorry, I'm no expert so am struggling a bit. Any advice would be ssoooo welcome! 🙏

I'm trying to delete an entry from my airtable through the API (on voiceflow to be specific). I have experience with the API as the rest of the application uses many GET and POST commands that work just fine. The problem comes when trying to delete, where I keep getting error 401 (authentication required) despite including my bearer API key as a header. I'm using an exact copy of the DELETE example in my airtable API documentation.Anyone have any ideas if this problem could come from somewhere else? Or if it's just a bug to do with my application? Thanks!