Development & APIs

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!

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": "close","content-length": "80","content-type": "application/json; charset=utf-8","date": "Sun, 29 Oct 20

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} catch (error) {console.log(error)}},},}</script>

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 library.  And again, I see the change when viewing in the UI and the l

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" }, { "type": "singleSelect", "options": {

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.  

Is there a canonical URL that will allow me to display a record in a given table?

I'm developing an automation with Make that should extract specific values (Email, Città and CAP) from an email body.  The values should be saved into airtable fields.Make returns the following error message when tries to save the extracted CAP value into the airtable field "Indirizzo_Immobile_CAP". The field "Indirizzo_Immobile_CAP" is linked to another table.I've contacted Make support and they told me what follow: "Upon inspecting the log, it looks like the field called "Indirizzo_Immobile_CAP" is the one causing this issue showing the record ID is incorrect. Unfortunately, I'm not sure why Airtable's API is rejecting the value for this field."How can I solve this problem?Thank you for helping me

How to edit cells within AIRTABLE as I have seen it detects values inside a cell like Listbox but not possible to edit like Excel cell F2.

Hello, I have a whole column of data with html links and I need these to be clickable links with the respective titles: DATA: <a href=https://www.coronavirus.tas.gov.au/media-releases/important-coronavirus-test-information>Tasmanian Government: Important coronavirus test information</a> Needs to be Tasmanian Government: Important coronavirus test informationHow can I achieve this via airtable? There are so many, relinking them all by hand is going to be tedious. ThanksI will ultimately be exporting this to excel.

i am new to airtable i want to connect database of airtabe with my project of laravel. i need to operation on that like we do in laravel with models with local databse. Is this feasible and or tell me the other easy way to connect it and do operations on it

Hi,I currently have an Airtable base connected to Softr that has 198,322 / 250,000 records. When one of my stakeholders are currently endorsing in Softr, they receive this message (see screenshot).I would like to know the root cause and a possible solution to this please.Thanks

Is it possible to have live market data from multiple crypto exchanges imported into my Airtable via API? (Binance, KuCoin, Coinbase, etc..)I am trying to create an app that utilizes this data. Unfortunately, I failed to get this done myself.The data I need to have live data for are "Symbol," "Ask Price," "Bid Price," and "Trade Volume."I would appreciate if anyone could provide any guidance. 

Hi all -I am working to update an Airtable table using responses to a Qualtrics survey via Zapier. I have many multiple choice questions, some up to 17 options, and the column these feed to in Airtable is itself a multiselect field column (so I want each item to show up separately). At first, I had the issue that when I listed all multiple choice fields from qualtrics one next to the other, it put it in as one giant option, as shown in the right of the attached Airtable screenshot (early stage growth stage as one item). I resolved this partially by putting commas between the fields, as shown in the zapier screenshot. That turned into the left example in airtable - now they are separate items, but if an item is not selected, it still includes a blank entry. Is there a trick to resolve this? Open to all ideas - thank you!

I'm not certain if the OAuth flow is working as expected...When initiating an OAuth flow for an existing, and currently logged-in user, the OAuth pattern works as expected. After the OAuth consent screen is displayed, flow correctly redirects the user to the redirect_uri.However, if a user is NOT logged in, the flow works to the point of providing an Airtable login screen for the user and then drops them into their admin page WITHOUT a OAuth consent screen. I would have presumed that for users who have not logged in, Airtable would allow them to login and then proceed to the OAuth consent process. As it stands now, users are dropped into Airtable without ever redirecting back to the calling site leaving users stranded. And assistance on this would be appreciated.

When trying to read or write data to and from a long text field via the API, I am loosing the newlines.This is an example of what I have in the field:When reading the content through the API, I am getting this:Also, when writing \n to the field via the API it get's stored literally, i.e., is not translated into linebreaks:I cannot find any hint how to encode newlines in the API docs or the forum.Any help would be highly appreciated.  

If anyone could shed light on this I would be appreciative. In my example, I have two columns, one with a ResourceName, the other a URL. A third column would hyperlink the ResourceName with the URL. Easy peasy? Not so. Still. A: ResourceName    Brown CowB: URL                        https://browncow.comC: Resource              Brown CowI tried this script from another thread but, line 2, let query = await table.selectRecordsAsync (); function is deprecated. It does work... for 15 rows but, stops there, and no matter what I try, 15 is all I can get.   let tb = base.getTable("My Resources"); let query = await tb.selectRecordsAsync(); for (let record of query.records) { let url = record.getCellValue("URL"); let text = record.getCellValue("ResourceName"); if(url) { tb.updateRecordAsync(record, {"Resource": `[${text}](${url})`}) } } 

Hi All,In terms of security and protection of clients data, which is better Airtable or Jira? how they are different from each other when it comes to security ? Many thanks 

https://github.com/sleiman/airtable-phpI have been using this tool flawlessly and working my new Personal Token where my API key existed.use \TANIOS\Airtable\Airtable; $airtable = new Airtable(array( 'api_key' => 'API_KEY', 'base' => 'BASE_ID' ));When I swap out the API_KEY with my new Personal Token it doesn't work, which I suspected. What do I need to change api_key to? Is it that simple I hope! Thanks in advance!- Jon