Development & APIs

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

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 passe

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.

So, here’s another in my long line of small issued in the API. I have simple formula fields in my table that add other columns together. It’s literally field a = field x + field y + field z. When I return field a, the api doesn’t return “0” properly. Instead, I get the most recent non-zero value in the field. It should look like: It Looks Like: 0 0 0 0 5 5 0 5 1 1 4 4 0 4 0 4 0 4 I’m using the API to generate simple reporting in Google Sheets, so I have apps script turning the api json object into an array of strings. I’ve verified that there isn’t any weird behavior here with 0 values in my implementation of the apps script. The api only does th

Hi all. Does anyone have an example of how to call Airtable data into a VBA script to output in a Microsoft Excel spreadsheet?

Getting pretty poor performance for creating records. A POST request to create a record often lasts >30 seconds. Naturally the table I am creating records in references other tables, has a lot of fields, etc., but 30s is really frustrating. Any tips for improving perf on my end? Anything in the works on Airtable’s end?

Hi, I’m trying to use Insomnia to debug my API requests, but I’m not getting very far with Node.JS… If I go to the API docs and grab the Node.JS (with our key) and paste it into the body section of Insomnia as “JSON Raw Text” and send it using https://api.airtable.com/v0 as the base URL with GET, I get “invalid request body” in return. What do I need to turn the node.js code from the API docs into a usable JSON request body? Thanks! -Donald

Hi, Is there a way to generate a JSON data definition like the one below automatically from the API? It’s easy enough to write, but I wonder if the API can dish these up via a URL? I’m integrating Ultradox which has a drag and drop code generation inserting fields into templates when it has a definition. { input: [], output: [{ name: ‘business_name’, description: ‘The name of the business’, format : ‘STRING’ }, { name: ‘business_url’, description: ‘The website of the business’, format : ‘URL’ }, { name: ‘support_phone’, description: ‘Support phone number’, format : ‘STRING’ } ] }

I’ve been using the Airtable API in PHP for over a year now and I’m proud to announce I’ve released Airpress, a Wordpress plugin that makes working with the Airtable API in Wordpress a breeze. Head on over and continue the discussion at Airpress, the Wordpress plugin (formerly named Airfields) has launched!: