Development & APIs

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!

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