Development & APIs

Hello there,https://api.airtable.com/v0/appycQyQBCRaFT2aD/Tebi-Category-Test?maxRecords=110&view=Grid%20viewI'm using this API to get the my table's data and after that I will process this into my CMS and then to fetch next records there is offset which I'm using to get another records. Since the records are more than 100 server might get out so I tried to get less records like 10 but offset is not there in the response.so can someone help me to get less records and also the offset in it ?Thank you.

Hi! I found a workaround that’s helpful for me, so I thought I’d share. If someone has an easier way to do this, please let me know! Apologies if this has already been posted, I didn’t find it after a bit of searching. The problem I was trying to solve was that when updating a record, a field can be named using its friendly name (e.g. “First Name”), but then if I change it later, even a little bit, my API integration will break. Each field also has a unique ID, prefaced by fld, but I wasn’t aware of any way to actually find that name. Well, it turns out that you can for most fields, with a little trickery: Edit: See drassi’s post below for an easier way to do this. In the GUI, create a new field, and make it a formula. In the formula, refer to the field that you want to know the ID of. (For instance, if you w

Hello, as of this morning, any PDFs that I attach via the Make integration will no longer open in a preview window, but instead tries to download a file without an extension.  This Make scenario has been running for months without issue, with hundreds of PDFs attached in the manner per day - all being able to open up in Airtable without an issue.  But as of this morning, nothing added today will open properly.  Any attachments added yesterday still open fine.  Any ideas what is happening here?Edit - apparently this is only happening on this specific Base.  If I run a Make scenario to add an attachment to a different Base - it attaches fine and opens normally.  But then if I change it to attach to my primary Base, the same download issue occurs.  I need to get it back to working normally on this primary Base.  This is what I have determined so far:1.  Only is affecting my primary b

Is there something wrong with Airtable today? Three of my customers reached out saying their Airtable automations stopped working. All issues needed to set another new personal access token. Aren't these supposed to not expire? If they expire, this is hugely problematic. This code needs to work reliably or Airtable can't reasonably be used for these integrations. I have to reach out to dozens of accounts now to see if their integrations are still working.

New to Airtable and had the webinar getting started with Airtable. However, my work will be to read and write data from a 3rd party app. Generally data will be pushed and pulled from the 3rd party app/website.The method to push and pull the data will be similar to the CURL examples in the docs. Seems straight forward.OverallMy general question: any suggestions or insight for best practice, etc. DetailTo get specific, I have created a couple Bases in my account as well as a Personal Key. Looking at the API call to List Records I need the BaseID. Looking in my account I don't see this info attached to the Base. My assumption then, I'll need to use List Bases to be able to List Records on a specific Base. Will I need to use this process every time? Storing this info into a local table on the 3rd party app is an option. So is it possible the IDs might change during the life of the base/table/record? 

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 .

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 hma

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

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)

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 pro

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 financi

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:

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'Follo

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!