Development & APIs

Hi,I've registered an oAuth integration here and have given all permissions as seen in the below attached screenshot. I'm able to get the access token on the server side. The access token works for non metadata API calls. However when making metadata API calls like list bases or list tables, I'm getting the errorINVALID_PERMISSIONS_OR_MODEL_NOT_FOUND. I've tried with two different airtable accounts and through my application, terminal and postman as well. same result. Can you please help me resolve this problem? thank you! Error{"error": {"type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message": "Invalid permissions, or the requested model was not found. Check that your token has the required permissions and that the model names and/or ids are correct."}} oAuth integration config

I am looking to automate the assignment of people to call for my Airtable CRM - specifically I'd like an Automation to copy the first 20 records of my 'Hit Lister' Contact view and paste the contact names into the 'Touch Points' related table. Is there an automation or a script that could do this? I'm attaching a video below to better explain my use case:https://share.getcloudapp.com/DOukbKKKThank you!

Working on a project today with Airtable + Zapier (to send out some invitations), I had to make a few changes in the base as I was working. I gather that Zapier references most objects in Airtable by an object ID, so my impression is that, say, changing the name of a field or a view or a table will not break my Zap. Is that right?(Of course I understand that, if I want to point Zapier at a different table, different view, or different field, then I'd need to do that. I'm just asking about objects in the base that continue to serve same role, just with a modified name.)

Trying to push an update for my app, and when I hit block submit, I get this error from the Airtable server:Is something wrong with Airtable's extension servers?

Hello! I've created a script with the purpose of letting me know whether or not a customer exists based on an External id (could be: 123456789). When the ID is entered in the ID_field in Airtable the script should run and check in Billwerk if an ID matches. If so, give me a thumbs up in a Status field. Here is the Script:   let apiKey = "XXXXXX"; let secret = "XXXXXXX" let endpoint = "https://api.billwerk.com/v1/customers"; // Define the Airtable table let table = base.getTable("tblovGgaXXXXX"); // Define the function to check if a customer exists in Billwerk async function checkCustomerExists() { // Get the input data from Airtable let airtableData = await table.selectRecordsAsync(); let inputData = airtableData.records.map((record) => record.getCellValue("External Id")); // Fetch the customer data from Billwerk let requestOptions = { headers: { Authorization: `Bearer ${apiKey}`, }, }; try { let response = await fetch(endpoint, requestOptions); let customer

Hey Guys, Just wondering if anyone can help me integrate & sync my airtable base to WordPress? Basically I have a real estate business and I’d like to display my listings into a WordPress theme. I saw that airpress is obsolete and no longer working I was wondering if there is an alternative solution? Thank you in advance!!!

Hello - I'm developing a deal tracking system to help my team win more business and report quicker to management. One management requirement is to show trends over time on the size of the deal pipeline.I can easily create a report or dashboard to show current statistics but management want to see how these statistics have changed over time. To do this I've created a new table in my Base for "Daily Stats" and I want to run a daily automation to calculate a snapshot of statistcs from my "Deals" table. Each statistic will have it's own field in the Daily Stats table with each record being the date/time of the automation. The type of stats I want to calculate are:- Total number of deals in the table- Number of open deals (filter out those with won and lost closed status')- Value of all open deals  (each deal has a potential value, again need to be filtered)- Average cost of open deals (have a field already for costs)I can't figure a way to do this using formula/lookup/rollup fields wh

I understand why airtable chose to have attachment URLs expire, but I'd like to mirror some attachment data for users to be able to download things without a potentially brittle "sync".If the dynamic attachment URLs included e.g. a hash of the contents of the file (along with a random nonce), it would be trivial to detect when some content on the airtable side changed and make this problem trivial to solve.Is there already a mechanism to accomplish this that I missed? Or can this be added to a wish list?Thanks!

hey everybody! I'm struggling like crazy with a post request I'm trying to make from an airtable scripthere is what I am trying to do:From Airtable scripting, create an object that contains record data. DONESend that object through a post request to Google Apps Script. STRUGGLINGRead the data from google app scripts and use it to fill a template. NOT DONE YETThe reason why I am using this approach instead of pre-built Google Doc filling templates is because my data is complex and I need flexibility.Here is the final part of the Airtable code: let response = await remoteFetchAsync(url, { method: 'POST', body: JSON.stringify(getFacility(record)), headers: { 'Content-Type': 'application/json', 'Accept': 'application/json', }, }); By logging the response, I get 401 unauthorised. Although, I am not sure what do I need to authorise, nor how. I could not find much information about this use case online. Any ideas? Thank you so much!!

I have been trying to get the script "Create records for multiple templates" to work in an automation script. I am trying to get this to work because the button I have in the base the run the extension script does not work in Interface Designer. Any Help or insight to get this to work would be greatly appreciated, or if you know of a work around to get the button to work in the interface that would work as well. Below is the original script and the values from the base used to the script prompt. this is the code from the script:// Create settingslet settings = input.config({    title: 'Create records for multiple templates',    description: 'This script will create records in a child table that link back to a parent record and are based on the template records that&nbsp

We are using the prebuilt tableau web data connector and are running into issues with Tableau Server.  Our workbooks perform as expected in Tableau Desktop, allowing the pull and refresh of Airtable data.  When we migrate the workbook to the Tableau server, the connection to airtable fails.

HelloI've been working on a script all day in the Script Extension thing, and it's been working fine until just now when I went through to comment out my console logs I was debugging with to tidy up the code. I went to run the script one last time and now all I get is the "An error has occurred" popup telling me to refresh the page (which doesn't help).Any ideas what causes this or how to fix it? Really need to have this working! 

The client secret is described as:An optional private key that authenticates your integration when requesting an OAuth token.You should only generate a client secret if you are requesting OAuth tokens from a server. Do not generate a client secret if you have a desktop, mobile, or web application directly issuing the OAuth token request.Can anyone clarify why there is a difference between requesting a token from a server and from an application? Isn't using a client_secret generally more secure?If I am creating an OAuth app that will be used by others to authenticate from different machines and possibly servers, should I add a client_secret or not?

I am building an integration for Airtable extension on Zoho's cliq. And I need to get the base collaborators for performing some core functionality.  But it seems to be a part of enterprise version. Is there any way that I could get the base collaborators without an enterprise version.   

I am really struggling to do something as simple as "clear" a records linked field value.I have tried... table.updateRecordAsync(r, { "Linked Field": [{id :''}]}); table.updateRecordAsync(r, { "Linked Field": [{id :null}]}); table.updateRecordAsync(r, { "Linked Field": []});If anyone can let me know how to clear a records linked field that would be amazing.Thanks

i have 7 ids, i want only that 7 ids records only, how to get this

Hi, i am using Aeropage to deal with recent update regarding the attachment url. I have a code as follows:   const table = base.getTable("Inventory") const recordsQuery = await table.selectRecordsAsync(); let updateArray = []; // iterate over all records recordsQuery.records.forEach(record => { const attField = record.getCellValue("image"); // iterate over object and save as url if(attField) { let urlArray = []; let aeropage = "https://media.aeropage.io/api/imgcache/token/24e60d5167326c730fd9922adb892288/"+record.id+"?attachment="; attField.forEach(item => urlArray.push(aeropage+item.id)) // attField.forEach(item => urlArray.push(item.url)) const urlString = urlArray.join(', ') updateArray.push({id: record.id, fields

Hi, I am trying to patch multiple records to airtable using Nest.js. I've checked:- url should be correct: https://api.airtable.com/v0/${baseId}/${tableId}- headers with authorized token:    const headers = {      Authorization: `Bearer ${token}`,      'Content-Type': 'application/json',      accept: 'application/json',    };- body is stringified with records array limited to 10:    const body = JSON.stringify({      records: records,      typecast: true,    });my records look like:records:[{ id: 'recyhk6cWWQcVrG9s', createdTime: '2023-01-09T07:07:16.000Z', fields: { 'Code Specs': 'window.datalayer.push({\n' + ' "event": "select_content",\n' + ' "shipping_method": "${shipping_method}",\n' + ' "payment_method": "${payment_method}"\n' + '})', 'Code Spec Match': 'false', Platform: [Array], 'GTM trigger method': 'Datalayer', 'Event Name': [Ar

Hello there,I have a scenario where I would like a file that's uploaded to an Airtable form to be uploaded to Box. There seems to be an integration between Box and Airtable but it's super confusing to set up. Zapier does not read the records properly and have us guess which records are the right ones to use. Is there an easy way to set up this automation? 1. Airtable form is filled with an attachment2. Attachment is uploaded to a specific Box folder Thanks!

I need to store api key, username of multiple users like twilio accounts and get the stored data 

Hi, I am using a WhatsApp bot as my source of data, and I receive inputs in various regional languages through webhook.For the fields declared as type NUMBER, I am not to store the incoming data from webhook of different language as it gives Field "Amt_Spent_New" cannot accept the provided value: Could not parse number. (Attached screenshot below)If I convert the NUMBER type field to TEXT, I am able to store the data but not perform operations on itHow can I tackle this use case?   Any advice or help is much appreciated!, Thank you

I’m trying to script some record creation right now and it involves populating a multi-select field, but for some reason I’m unable to make this updating work no matter how I try. I know that a multiple select field needs to be updated with array values only, so this is what I’ve attempted: var book_arr = []; book_arr.push(book_num); await new_table.updateRecordAsync(newRecord, {'Book Number':book_arr}); where book_num is a single value that I know is already a valid option for the multi-select. I also tried to pass it directly when creating the record as just 'Book Number':[book_num], but no dice there either. I don’t see anything in the API documentation about updating the value of a multi-select field, only updating the options, so not sure where to turn here.

Hey, I just discovered a costly bug, or at least a terrible design.I am using Zapier to trigger emails when a New or Updated field in airtable happens. Apparently when you change the permission of a column, it triggers a change (in my case emailed 100 people). The bug part is that the email was sent because the field "Last updated time" must have changed, however, the actual last modified time DID NOT change. If you understand me, then you're as confused as I am.  Try it.

Hello,I'm using this running total script which works great but I want to add another running total column based on another field to this. Any solutions on how to add another running total in the same script?The table and view are the sameThe fields would be different (Field Pillar & Domain is the same but instead of Q2 Demand it would be Q3 Demand)The sort would be the sameRunning total field would be Q3 Running Demand let table = base.getTable('Resource Capacity Planning'); let view = table.getView('Capacity Planning Include Only'); let result = await view.selectRecordsAsync({ fields: ['Pillar & Domain','Q2 Demand'], sorts: [ {field: 'Pillar & Domain'}, {field: "Stack Rank"}]}); let runningTotal = 0; let currentGrouping=''; for (let record of result.records) { if (currentGrouping !=record.getCellValueAsString('Pillar & Domain')) { currentGrouping=record.getCellValueAsString('Pillar & Domain'); runningTotal = 0 } runningTotal += record.getCel

Hey, I am wondering if it is possible to do these things using the Block SDK:1. Check if an automation exists in a base/table by name. 2. Create Automations on a table if they dont exist3. Automate updating an automation scriptUse Case: I have a Blocks SDK extension and an automation that both depend on each other(decoupled) if the extension exists I want to make sure the user has also set up an automation that goes along with the extension.I want to check if an automation exists under a certain string name using regex. Thanks