Development & APIs

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!

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

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!

Hello everyone, Hope you guys can help me out here.I am trying to fetch some information from Airtable through an Get request API block in Voiceflow. When the parameter field is empty I get a 200 success code but it retrieves all of the information. I want to fetch the information depending on a variable. To do that I type a filterByFolmula in the parameter field and I get 422 error. Does anyone knows how to solve this? I will really apreciate it{"error": {"type": "AUTHENTICATION_REQUIRED","message": "Authentication required"},"VF_STATUS_CODE": 401,"VF_HEADERS": {"access-control-allow-headers": "authorization,content-length,content-type,user-agent,x-airtable-application-id,x-airtable-user-agent,x-api-version,x-requested-with","access-control-allow-methods": "DELETE,GET,OPTIONS,PATCH,POST,PUT","access-control-allow-origin": "*","airtable-datacenter-regions": "us-east-1","connection": "clos

Hello The following code works when I pass in the field name as a string to the get function. It doesnt when I use the field id. I want to use field id. The code is taken from the API sample for javascript await table.select().eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function (record) { console.log('Retrieved', record.get('my-field-name') ); }); fetchNextPage(); }) How can I do it using field id instead of ‘my-field-name’?

Can anyone help me with how to use  useRecordActionDataIn the docs it is describing that it can be triggered when we open the extensionI want to perform oauth while opening the extensioncan anyone help me with this?

Hi there! We have the code below but it's not working. I'm not sure why.<template><div><iframe:src="link"style="height: calc(100vh - 1px); width: 100%; border: none"frameborder="0"></iframe></div></template><script>import Airtable from 'airtable'const base = new Airtable({ apiKey: process.env.airtableApiKey }).base(process.env.airtableBaseId)export default {name: 'IndexPage',data() {return {link: '',}},async mounted() {try {this.link = await this.getLink(this.$route.query.locationId)} catch (e) {console.log(e)}},methods: {async getLink(locationId) {try {const record = await base(process.env.airtableTableName).select({ filterByFormula: `{location_id} = "${locationId}"` }).firstPage()return record[0].fields.share_url

HiI am currently developing. a custom extension.I want to do external authentication on adding the extension.How can i do this?.Should i have to configure the the authentication url and token url somewhere for airtable to do external authentication or should i have to do it manually.please anyone help me with this...Thanks in advance 

Due to the deprecation of the API keys, you won't be able to connect your Airtable with your Typeform. Since personal access tokens don't work you are not able to advance. Typeform will repeatedly ask you for your API key which you can't create anymore.How can this be resolved? Hope someone can help, thanks. 

I've successfully created a webhook via the Airtable API using the following json: { "notificationUrl": "https://mycallback.app/", "specification": { "options": { "filters": { "dataTypes": [ "tableData" ], "recordChangeScope": "tbla....." } } } } It seems to work in the sense that my callback URL gets called.  Right now all I'm doing is logging the request body that is sent back to my endpoint and it seems to be missing all the important data about what has changed.  This is what I get back: { base: { id: 'app6......' }, webhook: { id: 'achnoA6.....' }, timestamp: '2024-02-22T23:46:02.849Z' } ANy idea what I did wrong or what I should be doing to get the details of what field changed.  I see the change in the UI and I've tried making the change in the UI as well as via code using an Airtable libr

I spent a couple of hours experimenting with Google Colab and the Airtable API to figure out how to create a new table that includes a singleSelect field.I'm sharing the example I needed but couldn't find.This example illustrates how to structure the JSON to define a new table with the following field types:a number field (with precision)a singleSelect field (with and without predefined options),a singleLineText fieldHere is the example I needed: # Define the data payload for creating the new table # This example demonstrates how to structure the JSON to create a new table in Airtable, # including different field types such as "number", "singleSelect", and "singleLineText". data = { "description": "Table description", "fields": [ { "type": "number", "options": { "precision": 0 }, "name": "Number Field Name" },

We have an integration with airtable that leverages oauth. In some cases we have been seeing intermittent failures when trying to get a refresh token for the same user, without auth edits. The refresh flow will work but then in some cases will return an `invalid_grant` error with the description `Invalid token`.What are the reasons this might be happening, and why would it work for the same user/auth and sporadically break?

Anyone have success syncing event details between Airtable and EventBrite?  Make.com only seems to tie to date and name of event, none of the detail fields appear to be mappable.