Development & APIs

Hi all, I’m having hard time with “sort” through API. Whatever I tried got me INVALID_REQUEST_UNKNOWN error (message: Invalid request: parameter validation failed. Check your request data.) Here is the browser JS code I render the final request url: var rUrl = ‘https://api.airtable.com/v0/…/Data?api_key=…’; rUrl += ‘&filterByFormula=’ + encodeURIComponent(“AND({Pub}=’’,NOT(LEFT({Name},3)=’###’))”); rUrl += ‘&sort=’ + encodeURIComponent("[{‘field’:‘PID’,‘direction’:‘asc’}]"); Here is the final bundled request I make; https://api.airtable.com/v0/…/Data?api_key=…&filterByFormula=AND(%7BPub%7D%3D%27%27%2CNOT(LEFT(%7BName%7D%2C3)%3D%27%23%23%23%27))&sort=%5B%7B%27field%27%3A%27PID%27%2C%27direction%27%3A%27asc%27%7D%5D Removing sort from url always works but I tried many different versions of the sort value as well as different urlencoding/non-encoded versions. What am I doing wrong?

We’re building an Airtable add-on. Is there an easy way to get OAuth credentials so that users of the add-on don’t need to copy/paste API tokens? Thanks!

The API documentation implies that all that’s needed is the official node.js client I have downloaded the files and the page says to “install airtable.js in a node project: npm install airtable”. Where is “a node project” and where do I type “npm install airtable”? Do I need other software? Also, I have looked at the API code. For example, here’s the node.js code for retrieving a record: var Airtable = require(‘airtable’); var base = new Airtable({apiKey: ‘YOUR_API_KEY’}).base(‘app1234567’); base(‘SampleTables’).find(‘rec1234567890NRXLGMAK’, function(err, record) { if (err) { console.error(err); return; } console.log(record); }); How do I get the record number? Where do I store the code so that I can reuse it with different records? How specifically do I submit the code request to the Airtable website? Thanks.

I have a table with several entries. One Column is an ID which could be used several times (not unique). Now I would like to retrieve a list of all records with just one unique entry in column ID. Somehow like an inverted duplication-checker. I wanted to solve this using a filerByFormula but have no idea how to do it (I miss the group by operator of SQL at this point). How could I manage this using the API?

Dear Community Your help would be very much appreciated if you knew how to fetch one record from my table in Visual Basic Script VB.net code, could you help? Jonathan P.S. Here is the equivalent of what I want to do using the curl utility: curl.exe https://api.airtable.com/v0/app6hDo2mwb2dVccO/letting-agent-details/recly4jCvMGGMYbyu -H “Authorization: Bearer YOUR_API_KEY” Here is the equivalent of what I want to do using node.js: var Airtable = require(‘airtable’); var base = new Airtable({apiKey: ‘YOUR_API_KEY’}).base(‘app6hDo2mwb2dVccO’); base(‘letting-agent-details’).find(‘recly4jCvMGGMYbyu’, function(err, record) { if (err) { console.error(err); return; } console.log(record); });

As far as I can tell I aways get nice JSON responses, but with this error the response comes in the form of a HTML page. My error handling didn’t like that. <!DOCTYPE html> <html> <head> etc <h1 class="my2">This page is taking too long to load.</h1> Is this intentional?

I would like to filterByFormula the records with arrays that contain a certain ID. The arrays look something like this: Arr [a, b, c, d] [c, d] [a] How does one filterByFormula to get all the records with arrays containing ‘a’?

It may be a feature but just wanted to point this out. I see the following behavior uploading a PNG image with transparency through the browser (Safari 9.1 on OS X), the file is uploaded as a PNG with transparency uploading the same file via the iOS app via the PHOTO icon at top results in the image being converted to JPG automatically, losing the transparency uploading the same file via the iOS app but using the general “upload files” file picker, the image is uploaded as a PNG file with the transparency intact. Is this an intended spec? here’s the file I used

Anyone know of a .Net wrapper DLL that exposes the Airtable API?

As the title, let me ask is how to sync data from my sql to airtable. Thank all !

Hi guys, I’m getting {"error":{"type":"MODEL_ID_NOT_FOUND","message":"Base not found"}} when a base is missing (or simply wrong). I’m seeing {"error":{"type":"MODEL_ID_NOT_FOUND"}} when a record in a valid table is not found. I thought that’s quite odd since I’m getting a nice {"error":{"type":"TABLE_NOT_FOUND" ... when there’s something wrong with the table pointer. In other words, could you differentiate the message further? The ‘recXXXX’ part of the pointer after the table name should make the difference I guess. Thanks in advance!

Trying to use a curl GET from excel VBA 2011 Mac to grab some records. Took me a while to figure out how to get authentication to work, did that, but have hit another bump. I am copying the GET syntax directly from Paw which returns the correct results. In excel the same syntax does not return the same results. It seems I can only manage to pass a single filter to Airtable. This code will return ALL records in the Stunning view of BestTableEver. “curl -X GET --header ‘Authorization: Bearer keyYour_Bearer_Key’ https://api.airtable.com/v0/appYour_Fabs_App/BestTableEver?view=Stunning&maxRecords=1” This code will return a single record from BestTableEver that is actually filtered out of the Stunning view, but is the first record you get from Paw without naming the view. “curl -X GET --header ‘Authorization: Bearer keyYour_Bearer_Key’ https://api.airtable.com/v0/appYour_Fabs_App/BestTableEver?maxRecords=1&view=Stunning” Any ideas? Edit… I should note I am using the execShell() funct

Hi team, About every 60 minutes I’m getting a couple of connection errors. Error resolving 'api.airtable.com' This has been going on for a week or so. Are you doing something like rotating servers or should I have a word with my server guy? Thanks in advance!

Hi, When I create a new entry I want to update the same entry using the recordId. However, I am unsure on how to do this.

During some API calls, the table rows aren’t updated and there’s need to refresh the browser to get the accurate data.

I think there could be a small improvement in the JSON that comes back when trying to add an illegal collaborator (for example: someone has not yet accepted an invitation to a base). This is the response I’m seeing: {"error":{"type":"INVALID_VALUE_FOR_COLUMN","message":"Cannot parse value \\"[object Object]\\" for field Rep"}} I suspect the ‘object’ part should be something else. :winking_face:

My Requriement To get all available bases and the corresponding table that are available in my account using Java API Current Issue Unable to find generic API to find all the available bases. API’s are specific to the bases currently available in my account. Can you please help to provide the API (Resource path) to get all the available bases.

Hi! Is it possible to give airtable a username and password it should use to download an attachment? I tried the http://username:passwd@url.com and that didn’t work. Thanks!

Hi everyone! I’m having a problem where matching a record using filterByFormula (through curl) is behaving in a case-sensitive way. I need it to ignore the case. The request is constructed like this (Angular): return $http({ medthod: 'GET', url: api.BASE_URL + '/Members' + "?filterByFormula=(Email='" + email + "')", headers: { 'Content-type': 'application/json', 'Authorization': api.KEY } }) api.BASE_URL and api.KEY are fetched from a config file and email is passed into the function. The resulting request URL is this: <REMOVED BASE URL>/Members?filterByFormula=(Email=%27passed@email.com%27) The problem is that this appears to ONLY find a record with that exact string, where I would like it ignore the case. A possible workaround would be to force the email input field (the string being passed into the request) to be lowercase, but I would rather if this was fixed by ignoring the case. I have looked through the API documentation, this forum and searched Google fo

If I’m creating a new record in a table and need to grab the internal airtable assigned value immediately after the create call to the API, how to I get that? Thanks in advance! Cindy

Hi there. I am not a programmer but i have managed to build a php webpage (I used Sample Web App as a reference) that displays some information from my Airtable via api. I really want to have a push button or a checkbox and submit button that “checks” a checkbox in airtable field. Can someone help me with this ?

Using PHP and Curl (mainly because I don’t know any better…) I have a page that lists all the “Names” in one table and am attempting to do a nested list of “Orders#” under the “Name” however if I echo the “Orders” field it just outputs the word Array… I’m assuming I need to make a GET call to the Linked Table I’m just not sure how to do that within the same foreach loop I’m using. Any help is greatly appreciated! J Fuller

I’m trying to create a front end webapp for collecting sign up information and storing it in AirTable but can’t get AirTable to accept my post request. Originally, I had all of the field value pairs directly in the payload. Oops! I have since then created the fields object with field value pairs inside of it but keep getting INVALID_REQUEST_UNKNOWN. The message reads that the parameter validation fails. I’ve even gone so far as to copy and pasting the example object code from the API doc’s to make sure I’m using the exact names and data types of fields but receive the same error! I’m not trying to add data to any formula, rollup, or lookup fields that can’t be edited. (I tried to use AirTable.js by pasting the source code but GAS didn’t like that and kept throwing me random debug errors) Any ideas??

I’m using this code: item_call = at.get(‘Master reference’, input_item) Assembly_name = item_call[‘fields’][‘Assembly name’] Assembly_bom = at.get(‘BOM’, filter_by_formula="{Part of assembly} = %s" % Assembly_name) print json.dumps(Assembly_bom, indent=4, sort_keys=True) I’m getting a 422 error, but can’t really figure out whats going on. Also, the same code seemed to work a few hours ago. the 422 error url is: https://api.airtable.com/v0/xxx/BOM?filterByFormula={Part of assembly} = ASB00004_Assembly It’s important to say that {Part of assembly} is a linked field. Thanks for any helpers! Guy

Hello, I started using airtable this week and I’m already using the API with PHP. Works like charm. Before starting to build more solutions I’d like to know some more details about the 5 api requests / second limit. Is this limit per table, per base, per user or mayby per session? Do paid plans have a higher rate? Thanks.