Development & APIs

Anyone else running into this? I have the following formula (encoded or not) that throws an INVALID_FILTER_BY_FORMULA error when submitted to the API via JavaScript: AND(IF(FIND(‘GIZELLE’S BUCKET LIST’, Available_Rights) > 0, TRUE(), FALSE())) The only records where this is a problem contain the apostrophe. All others work fine. I’ve explored the forum where people are having problems with commas and similar punctuation within the data and their fixes didn’t work. I’ve also tried looking it up via other available data and that was a bust, too, due to the structure of the tables. Has anyone encountered this? Is this an API problem? Any thoughts or fix ideas welcome. Thanks in advance! Mark

I’m trying to write a function that creates a record from form data but I’m not sure how to construct the request body. Especially since data that going into a multiple select field have to be converted to an array. Any ideas on how to solve this?

I have 20 fields in my table that are named ACH001, ACH002, ACH003, etc. (They’re achievements for a game.) I want to update a specific field when a user completes the achievement, but I don’t know which one they’re completing until I’m ready to make the update call to the database. So, I’m creating a variable called “fieldName” that contains the name of the field. This doesn’t seem to work, however. I get an UNKNOWN_FIELD_NAME error. Error 422. Anyone have any tips on how I should approach this one? var fieldName = getFieldName(achievementId); var airtable = await new Airtable({apiKey: process.env.airtable_key}).base(“appx5AkeU3qgwlYDn”); airtable(‘User’).update(UserRecord.RecordId, { fieldName: Date.now() }, function(err, record) { if (err) { console.error(err); return; } });

I’m at wit’s end…Any help or hints would be AMAZING. Airtable Python Wrapper is able to find a field using Airtable.Match when executed from the local machine, but It Airtable Python Wrapper is able to find a field using Airtable.MAtch when executed from the local machine, but It cannot make the match on Google Cloud. Declared: - - coding: UTF-8 - - search = d['TITLE'] + d['OFFICE'] try: #THIS WONT WORK?? WHAT? record = airtable.match('mysearch', search) airtable.update(record['id'], d, typecast=True) print (' UPDATED ') except: try: #NO PROBLEM INSERTING - TOO BAD ITS NOT CATCHING DUPLICATES airtable.insert(d,typecast=True) print (' INSERTED ') Expected to find the search var in {mysearch} field. Works great on my machine. Will NOT find the match in GCM. make the match on Google Cloud. I’ve tried adding: - - coding: UTF-8 - - here’s whats failing (airtable.match) search = d['TITLE'] + d['OFFICE'] try: **#THIS WONT WORK?? W

Hello, Over the past month or so, I have been experiencing a significant increase in errors when doing GET requests using the API. We are definitely not hitting the 5 request per second rate limit, and aren’t sure how to diagnose and fix this issue. We were hoping to be able to review a history of API queries, but AT support let us know that no such record exists. Has anyone else experienced a sudden increase in GET errors like this? Any tips for diagnosing or resolving it? Thank you!

I have a table of products with ~5000 records. I’d like to grab a subset of these records (about 1000 of them) using the API, and I already have the list of Record IDs that I want. I’ve figured out two ways to get this data using filterByFormula, but both methods take a long time to fetch 1000 records. First method: takes about 20 seconds OR( RECORD_ID = "a1b2c3", RECORD_ID = "a1b2c4", RECORD_ID = "a1b2c5", RECORD_ID = "a1b2c6" ) Second method: takes about 10 seconds SEARCH(RECORD_ID(), "a1b2c3,a1b2c4,a1b2c5,a1b2c6") != "" Are there any more efficient formulas I could be using here?

Hi, I am fairly new to C# and recently started experimenting with Airtable API nuget package. But don’t know from where to start. Can someone please point me in right direction where I can find some tutorials/Or a part of code that worked for you, etc? I just need an example to get started with. P.S. I know python and have already used airtable API on it. Thanks

I’m using the Airtable API in Wix to create an entry in one of my bases. I can get the entry to create no problem, the issue is I would like to return the entry id after the creation and it returns ‘undefined’. See me code below, I can get the id number to print out at the point shown, but I can’t send it out to my other functions. I’m pretty new to this, I’m sure it’s just a simple oversight, thank you in advance. export function getCustomer (){ var nCustomer; base('Customers').create({ "Name": "John Smith", "Orders": [ ] }, function (err, record) { if (err) { console.error(err); return; } nCustomer = record.getId(); //console.log here I get the record id }); //console.log here, returns 'undefined' return nCustomer; }

Hello! I have two tables linked by a foreign key. How can I get the second table entries that reference the first table entry? The fact is that the record ID is stored in an array. I tried to use the ARRAYJOIN function, but it returns a string from the display names, not an ID Thank you in advance!

I looked at this as well, but not sure if it’s the same problem I haven’t changed my API in a long time, but for some reason when I do the following get: returned_dictionary = at.get(unit_history, view='Default', filter_by_formula = search_term) Where search_term is equal to: '{Unit I.D.} = "510040000751373238393835"' And here is the data in the TABLE and the CORRECT COLUMN. (Click the image to see the record.) but returned_dictionary just returns OrderedDict([('records', [])])

I am trying to update a column that is linked to another record. None of the other fields in the base are linked to another record, and all of those will update. I get an error only when I add the field that is linked to another record. I am using Shortcuts on iOS. This is the error I get: {“error”:{“type”:“INVALID_VALUE_FOR_COLUMN”,“message”:“Value is not an array of record IDs.”}} I have zero experience with APIs, but truly appreciate any help!

In the Airtable UI, you can manually rearrange the order of rows in grid views by dragging them up and down. This row order is view-specific. Is it possible to reorder the rows in a grid view like this via the API?

I want to do a filterbyformula search through the api in a date field. My field is an ISO date field in YYYY-MM-DD format. Basically, I want to do a “select” call to the DB, with a filterbyformula, but only looking for a record that equals “today”, just with today’s date, but not time! (Too specific, and would fail!) So I would need to match 2019-06-12, for example, but not the full ISO string. How would I write that filterbyformula code in nodejs? It’s a headscratcher?

I am using webhooks to call data from AirTable using the AirTable API. I am trying to query a number through the webhook, but I can find no way in the API service to do this. Is there a way to call a number through a webhook? Is there a different way to code the webhook that will indicate whether it is looking for numbers or text? When I try to call the number data right now there is an error on that query.

I am subscribed to a Pro plan and am using Airtable to migrate our existing CMS which is just a MySQL table. I need help adding 40000+ records from that mysql table. I am aware of the upper 100 limit for the api. So I wrote a custom node script that inserts 100 records at a time while reading them from my table. I managed to import 200 records in a single shot successfully just an hour ago. But now when I try to add more (say 1000 at once) I start getting these errors: { error: 'SERVICE_UNAVAILABLE', message: 'The service is temporarily unavailable. Please retry shortly.', statusCode: 503 } { Error: connect EADDRNOTAVAIL [35.153.165.44:443](http://35.153.165.44:443/) - Local ([0.0.0.0:0](http://0.0.0.0:0/)) at internalConnect (net.js:884:16) at defaultTriggerAsyncIdScope (internal/async_hooks.js:294:19) at GetAddrInfoReqWrap.emitLookup [as callback] (net.js:1031:9) at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:62:10) errno: 'EADDRNOTAVAIL', code: 'EADDRNOTAVAIL', syscall: 'c

Hi Is there any valid circumstance when the AirTable API can return a “null” status code? I see a record created successfully, but instead of “200” (success), I get “null”. This is making it difficult for my workflow logic to progress without a solid success code. Can I assume “null” also means success, or does this look like an anomaly? Kind thanks in advance.

Hello everone! I’m trying to make POST requests and am stuck with IronPython but I am having some problems creating records. I’m able to create them using the requests module in Python3, but I’m not able to replicate this with WebRequest in IronPython. Here is the code: def post_request(params): '''post data to Airtable''' HEADERS = 'Authorization: Bearer XXXXX' URI = 'https://api.airtable.com/v0/XXXXXXXXXX/Table%20XX' request = WebRequest.Create(URI) request.ContentType = 'application/json' request.Headers.Add(HEADERS) request.Method = 'POST' bytes = Encoding.ASCII.GetBytes(json.dumps(params)) request.ContentLength = bytes.Length with request.GetRequestStream() as reqStream: reqStream.Write(bytes, 0, bytes.Length) response = request.GetResponse() result = StreamReader(response.GetResponseStream()).ReadToEnd() return result The params are formatted as follows: params = { 'fields': { 'Room Type': 'T

Hi folks, I’m trying to find a simple way of updating records with data retrieved from JSON data feed. Ideally, GET requests would be sent daily (or 2x a day) to the feed and records updated accordingly using the AirTable API. Tried using Zapier Webhooks but I can’t get it working :frowning: Any ideas?

Hi, I am trying to link Airtable and PowerBi. For the most part, it works perfectly. But, things are breaking down with the columns that link to another table. In such cases, I am getting recordID instead of Name. Is there a way to show record name instead of record ID? I have attached the Images from both AT and PBI for reference. (I have gone through the solution that suggests creating a new column and using a formula to refer the linked column. For my case, it is not practical as there are around 20 linked columns) Thanks

Hi! Thanks in advance to the community for your help with this! I’m considering using Airtable to create an API for 3rd party app developers to pull information and was wondering the community’s thought on whether this is a good idea or not. I’m not an expert on the Airtable API (or APIs in general) so was hoping to get some perspectives from those of you who are wiser than me. I’m also interested in hiring someone on a consultative basis to help me with this project if they are particularly knowledgable. I’ve read about examples where Airtable is used as an “internal” API, where the front end developers working pulling from the Airtable API work for the same organization as the people maintaining the Airtable database, in which case presumably data security is less of an issue. I’m aware that there is a 5 request / second limitation on the API (although it’s unclear whether this is per API key + IP address combination or per API key + Base ID + IP address combination). I’m also awa

Hi there! I’m getting a bunch of records using the API and I would like to paginate the results - in the end, I’d like to display to the user 10 records on a page, then when they hit ‘Next Page’ I can show them the next 10, and so on, requesting the next 10 from the server each time (as opposed to grabbing all the records myself and paginating them in the client). I see that there is eachPage() and fetchNextPage(), but I may be confused about how they work. I use eachPage to get the records and massage the data I get by looping through the records. However, the done() function doesn’t seem to get called unless I call fetchNextPage() and I want to call fetchNextPage() after a user chooses to get to the next page of results. Any help/advice would be awesome!

I am having an issue updating a record using the API where the update method is treating a variable as a literal value, rather than the value it contains. My code is: var express = require('express'); var bodyParser = require('body-parser'); var app = express(); var Airtable = require('airtable'); var base = new Airtable({apiKey: 'censored'}).base('appYYigSAYG6wvbIL'); app.use(bodyParser.urlencoded({ extended: false })); app.use(bodyParser.json()); app.post('/update',function(req,res){ var exam=req.body.exam; var status=req.body.status; console.log(status); console.log(exam); res.end("yes"); base('Staff').update("recL2tsSb73D8NdVj", { exam : status }, function(err, record) { if (err) { console.error(err); return; } console.log(record.get('Name')); }); }); app.get('/', function (req, res) { res.send('atapi is up'); }) var server = app.listen(8081, function () { var host = server.address().address var port = server.address().port console.

Is it possible to have an API key that only allows writing to a base but not the ability to see the other responses?

When I’m uploading a regenerated PDF (different data) with the exact same file name Airtable is showing me the original file instead. 1 - upload PDF 2 - delete / clear PDF with browser GUI 3 - upload PDF (same filename, other data) 4 - GUI shows original version I suspect AT thinks the cached version (on server) is okay to use. Mailed support.

Hello, im having a table of locations that which record has location name( which is a single text type) and other parameters. im having a columnn in another table which is a Look Up for the location’s name. The records in this column are arrays,even if records contain only single location name. How can i change the type of the lookup column to be only single text and not returning the location name as a list/array?