Development & APIs

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.

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 this on calculated fields. My only idea so far is that

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!:

Hello, Not sure if this is the right category to post to, but i’ll give it a shot. I am trying to pass an array (precisely - list of linked records) from iOS Workflow app and it is not working. the array i am trying to pass is formatted [“recID”, “recID”, “recID”], which is not accepted. I am happy to reformat it, just can’t figure out how. I do realize this is most probably the problem is not on AirTable side, but on the way from Workflow to AirTable, but thought there might be people who had similar issue and resolved it and could share the results :slightly_smiling_face: And just for the reference, below are links to two workflows. One which woks and one which doesn’t. The both write to test account. Doesn’t work: https://workflow.is/workflows/c05b8bac5984446d96be14351eb7ce94 Works: https://workflow.is/workflows/0814039069bc4e6ba238305cdb3c2884 In a nutshell: there are two tables (Table1 and Table2). Table two contains 3 records: Tea with RecordID recde0ftKsBz1eyao; Coffee with Re

So, I’m using multiple api calls to generate a complete list of records for basic reporting in Google Sheets. Here’s the basic set up of arguments: Call 1 ?view=someView&fields=x&fields=y&fields=z Call 2 ?view=someView&fields=x&fields=y&fields=z&offset=offsetValue In the view I’m experimenting with, I only have 180 records, so two calls gets it done. My problem is that the first call returns fields in order x, y, z; however, the second call returns fields in order y, x, z. Does anyone know why this might be happening?

So, I’m not overly familiar with APIs in general. Nor am I ver familiar with handling JSON objects in appscript, so this could be a problem with the way I am calling the API or the way I handling the JSON Object. I’m trying to return my various views so I can design some basic reporting. Since the API record limit is 100, I’m going to need to use the offset. This is where I’m having trouble. If the original call returns an offset on any data set that would return over 100 records, how do I use that offset in my next call?

The API Docs are messed up at http://airtable.com/api for all my bases. I would love to imagine that it’s because you’re releasing the meta API?!?! Regardless, thought you should know.

base('Test Space Request 2016').select({ view: "Main View", filterByFormula: "({Requester Name} = 'Mo Biegel')" }).eachPage(function page(records, fetchNextPage) { }, function done(error) { }); For some reason this isn’t bringing up any data, any ideas why? via CURL: https://api.airtable.com/v0/appO7dvt1H3N3gLmB/Test%20Space%20Request%202016?filterByFormula=({Requester%20Name}="Mo%20Biegel") Thanks!

Nathan Esquenazi, founder of CodePath, created a really nice Ruby client for the Airtable API: GitHub Airtable/airtable-ruby Access Airtable data sheets with ease using ruby. Contribute to Airtable/airtable-ruby development by creating an account on GitHub. gem install airtable Please try it out and let us know what you think. Thanks Nathan!

When sending PUTs to the API with a complete record you’ll get an error if you include computed fields. Since you get computed fields back like any other, the only way to find out which fields are computed is by either a) from the error messages when trying to update, excluding them one-by-one on the next requests, b) manually configuring them in the client. For me, this is not a big deal, I get around it with the PATCH verb, by maintaining a list of columns that have been updated. However, to lower the barrier of entry for API clients (PUT is easier to support than PATCH), you may want to consider just ignoring computed fields when updated through the API. Alternatively, the imminent Metadata API changes may help with this as well…

I’m seeing a problem with using Zapier to add files to attachment fields in AirTable. The file itself comes through when added via a Zap, but the issue seems to be that the file name and extension is replaced with the name “file”. This is a screenshot of a file that was originally uploaded via Cognito Forms, then added to AirTable via Zapier. As you can see at the top of the screen, the original file name (PartnerSlide_SARA_16.pdf) has now been replaced with the string “file”. This has caused some serious issues for us. I’ve tracked down the issue to something related to AirTable as modifying the Zap to send the same file from Cognito Forms to Google Drive results in the file being written to Google Drive with the filename in-tact.