Development & APIs

I am creating a mapping from record_ids to view name. IIRC there is no better way to to do this than list all records in each view and then create this mapping. To reduce the traffic, I would like to return no fields, when I am traversing each view. However this doesn't seem to be possible as of right now. Would it be possible to add this option to API ?

Hello! When attempting to edit an app, I enter https://localhost:9000 into the Edit app dialog box, and I’m getting the following message: As well, I run into this screen when going directly to https://localhost:9000 in Chrome: This did not occur previously. I’m not sure what happened but I don’t know what I’m supposed to enable. There doesn’t appear to be an allow-insecure-localhost flag when I go chrome://flags/#allow-insecure-localhost. Any idea what might be causing this?

Add static Google Maps to attachments based on addresses in a table. Source Code /** * Copyright 2020 Bocoup * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to * deal in the Software without restriction, including without limitation the * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or * sell copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGE

I just got metadata api and I’m trying to connect it with my airtable and get data but it is not connecting and keeps throwing me errors. HelloWorld = () => { axios .get( "https://api.airtable.com/v0/mykey" + "/" + 'Table 1', { headers: { Authorization: "Bearer " + 'api-key-from-airtable' } }, ) .then(resp => console.log(resp)) .catch(error => console.log(error)) } This throws the error of Error: Request failed with status code 404 and 404 not found. I tried performing a GET request on postman as well but it still did not work.

When initiating an OAuth authentication, it is possible to provide additional parameters, meant for custom use of the client application.These parameters are correctly passed to your https://airtable.com/oauth2/v1/authorize page, as URL query parameters along the standard parameters (nonce, response_type, code_challenge_method, scope, code_challenge and client_id).However when the redirect_url is called after a successful authentication, the additional parameters are not included. That would be a standard behavior your authentication should support.

Hey All,I'm looking for a way to add files that are not hosted on a public site. The server hosting the files allows for basic auth so I should be able to pass credentials. I'm wondering if it's possible to use `fetch` in an extension to get the file and then add the file to an attachment field. Definitely open to better ideas. Cheers,Collin

I built some scripts a while back using the airtable python API wrapper.  I was able to create new records in a table with linked fields using only the string value of the linked record. This was very helpful since I could upload records to 'Orders,' for example, and Airtable would accept a string, for example a Product SKU, to designate which Product to link to.Since updating to the more recent pyairtable wrapper, I'm not able to do this anymore.  I need to know the record ID of any record I want to include in a linked field.  This means extra steps.  Is there a way to use strings instead of 'array of record ids' as the value for linked fields?

Good morning,Following research to develop an existing project, I decided to try to stay on Airtable for my backend and I must therefore take into account the new standards that you will apply by February 2024. Indeed, I 'uses the plugin on my gatsby site, "gatsby-plugin-airtable", with a version of Gatsby V4.25.7 and this will be a first for me to make use of Token or OAuth system. Unfortunately, I have "little" information regarding the integration of this possible data via this plugin. For now, my API keys are stored in an .env file and imported via the dotenv package into my gatsby-config.js.So I have 2 main questions:1 should I favor the Personal access tokens API or OAuth integration?2 If using the Personal access tokens API is preferable, or easier to set up, should I simply change my API key to the value of the Token key inside my .env file?Before:    const path = require("path") // Initialize dotenv require("dotenv").config({ path: `.env.${process.env.NOD

Can anyone suggest a form builder/no-code solution that integrates with Airtable and supports the following features: Dynamic, dependent dropdown lists based on Airtable linked records; Dynamic transactions in stripe or some other payment integration using user input form field values a well as values pulled from Airtable?; and lastly Pre-filling of a filter field (i.e. the control field needed for point 1.) The closest I’ve gotten so far is MiniExtensions.com - an excellent form builder that integrates directly with Airtable to allow points 1 and 2, but not 3. The second best option I’ve found (but still not quite there) is an ‘Airtable/On2Air/Jotform/Stripe’ integration which enables 1 and 3 but not 2 because Jotform forces you to set up all product data from within Jotform. Therefore, you cannot lookup a price from your Airtable records nor can you use product names and customer emails collected in the form to generate the payment transaction data needed by stripe and paypal. I re

My team and I received an email from airtable that a third party integration access to our Airtable account has been revoked due to security concerns around refresh token usage. We also happen to be the developers of the 3rd party integration.We currently refresh tokens every 30 minutes to ensure they do not expire.Can anyone provide insight into any security issues regarding how we are refreshing tokens? We can re-authorize it and have it work but it will only be a matter of time before it gets revoked again.

When visiting developer documentation on Extension components, I cannot see the preview of this component in action. A while ago, I remember that preview was working correctly.   Is Airtable support aware about that? Any info when it gets fixed? When developing custom extensions such previews really helps! Example docs page: https://airtable.com/developers/extensions/api/UI/components/RecordCardList

Hello there,I'm trying to fetch data from a product in one base, then send that information to an external API and then update that new info in other base. The code goes like this: //input of modified product let inputConfig = input.config(); //JSON creation let body = { "costo_ult": inputConfig.costo_ult[0], "disponible": inputConfig.disp[0], "dias_obs": inputConfig.dias_obs[0] } console.log(body); console.log(JSON.stringify(body)); //Send JSON to API try { let response = await fetch(`http://167..../${inputConfig.id[0]}`, { method: 'PATCH', body: JSON.stringify(body), headers: { 'Origin': '', 'Content-Type': 'application/json ; charset=utf-8', 'Authorization': 'eyJhb...', }, }); console.log(await response.json()); } catch (error) { console.log(error); }  The fields I want to update are related to costs, quantities and rotation days, and the response from the script isError {name: "Syntax

I'm trying to connect Power Automate with Airtable using this connector: https://learn.microsoft.com/en-us/connectors/airtable/. I am able to connect when using the API Key. However, when I try to use a personal access token, I get an error. I've tried the full PAT (82 characters) and the PAT key after the token ID. What am I doing wrong? 

Hi all,I have a simple script that is taking some items from the submission of a Gravity Form and updating an AirTable record. It all works great until I get to a section of the form that has checkbox values. INSIDE of one of those checkbox values is a string that contains a commaCheckbox choicesApplesOrangesPearsGrapes, limes and lemonsI can gather all of these out of Gravity Forms and put them in an array and then implode that array to get a comma delimited list, which is what AT wants to absorb that data for checkboxes.$c=Apples, Oranges, Grapes, limes and lemons"records": [{"id": "'.$id.'","fields":{"Committees": "'.$c.'"}}],"typecast":true}';This of course will cause AT to barf when that comes in and tries to split the Grapes out as its own committee and limes and lemons as another committee. I know that in order for AT to treat a Linked Table field items containing commas is to put quotes around it. When I try and quote the incoming data here the update bombs.$c="Apples", "Orange

I'm working on a no-code application with Bravo Studio, using Airtable as a backend. I'm trying to implement a 'multilike' system where each user can like multiple items in an identifiable way. I've considered a table of likes with a user-element relationship, but I'd like specific suggestions on how to implement it in Airtable and how to integrate it effectively with Bravo Studio. Any ideas or advice would be greatly appreciated.Thank you!

hello I use airtable as a database for an external application creation solution. I would like to create a Like option but I cannot find the solution because when a user likes it is all the other utilities that see their like so I would like to know if there is a solution via airtable so that the user identifier and like is only visible and operational for the user account in question

Hi there - I am trying to set-up scripting to work with Whatsapp & Twilio. Which is the best and easiest language of those below to interface with airtable scripting?

Hi I have an automation script, and run into a problem, it is not fetching the right recordId in the script, but it does in the previous step. Anybody with a larger brain that can se what I have done wrong here?All the BestJesper

Hi all,  We are a small nonprofit (team of 14 people), who have been using AirTable for the past year and a half. We love its many functionalities. One thing we're hoping to do is integrate some emails into AirTable. Specifically, we want to write a record to an AirTable base when an employee CC's a certain Google Group email. Has anyone done something like this in the past? Would love to see examples if you are willing to share. Thanks,Alex

Hello everyone!I have a database with multiple linked tables and I have a JSON response with which parts I need to update corresponding records in those tables. To achive that (as I'm thinking) I need to solve a simple problem of zipping two arrays into one. Say, I have [rec1, rec2, rec3] and [val1, val2, val3]. I need to get a zipped array [[rec1, val1],[rec2,val2],[rec3, val3]]. How could I make this transformation with Make? Any ideas?Andrey

Hi Community,I am developing an airtable base with interfaces that manages requests logged by a contractor to a consultants on a construction project and also allows the consultants to respond.I need help with it to add some features on it (Kind of out of my depth).Kindly reach me on meisternbim@gmail.comIt's very urgent.Thanks.

I can’t seem to get <RecordCard />s to play nicely as flexbox child or reliably fit 100% width of its container. The default width of a record card is set to 568px wide, which wouldn’t be much of an issue if this were taken care of in the class applied to record cards. Instead, the width (and height) are set with inline styling. Since the width default property won’t take “100%” or “auto” as valid inputs, I can’t use either of those. Setting width to {-1} kind of works by removing the inline styling and getting it to fill its container, but all the record’s fields disappear: I could apply a class with width set to “auto!important” to override the inline styling, but “!important” is not generally good practice. Anyone have some advice?

Hi,I'm getting this error when trying to append to a linked field. The code in question is: ModelRange.updateRecordAsync(record, {'Models List': [...record.getCellValue('Models List'),{id : BMRecord[0]}]}); I'm pretty sure that 'record' is indeed a record object, as it's obtained from  let query = await ModelRange.selectRecordsAsync(); let record = query.getRecord(another[0]); where another[0] is a record ID. Let me know if the rest of my code is needed to diagnose the error, although I can imagine that I'm missing something obvious.Thank you!

Hello, I have created a custom Airtable extension. But accidentally  I deleted the extension connection from the Airtable base. So how can I run this extension on an Airtable base? Here is only a single option to add a new extension. There is no option to run the previous extension.However, if I try to run by localhost:9000 it shows an error{ "error": "FORBIDDEN", "message": "blockId mismatch. Make sure you are entering development for the correct block." } 

Hello, I am trying to write some automation that should call some function in our server through a script and pass as input the image data that is stored in some field. How can I pass the image data ?The url I get there is private and  inaccessible through the server. I tried to convert it to base64 but FileReader is not available, also to pass the binary data using FormData but it is unavailable as well .Any help will be much appreciated.Yaniv