Development & APIs

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

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:

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

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

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.

I haven’t done any database programming in about 20 years. Things have come a long way since the dbase and Paradox days. I am struggling with the lack of reporting features in Airtable, but like everything else. I downloaded a copy of Jasperreports. It looks like the program can use the airtable api to access data so you can create custom reports. Has anyone tried this? Suggestions on where to start to make it work.

How do I got about sorting with querystring parameters? The API documentation seems to only give an example for the ruby client.

Hi, Is it possible (or on a future roadmap) to list all the records in a Table without Pagination? I.e. Not have the ‘pageSize’ maximum limit of 100? The reason behind the question is that I’m looking to see if there’s a way to pull all the data from a Table into Splunk, using its ‘REST API Modular Input’ (https://splunkbase.splunk.com/app/1546/). I can get this working up to a point, but I have no real idea on how to deal with (or if this feature of Splunk can deal with) the Pagination / offset. I’ll hold my hand up and say that I have very little knowledge of Python (which is what the tool appear to be written in), so writing a custom script / implementation is definitely beyond my ability. It just seems slightly strange that you can download the whole Table / View to CSV, but with the API you’d have to do a whole sequence of REST calls with the changing ‘offset’

Does anyone have examples they are willing to share about what they have made using AirTable’s API? I’m an amateur web designer / novice web developer. I’m self-taught and I really want to get inspired to learn more. I love AirTable, but I find it’s lack of reports capability rather limiting. I really enjoy looking at examples of what people have done to get inspiration. Also, if people have some templates of things they have done with the API, that would significantly jump start my learning. Thanks!

When using filterByFormula via the API, records on which the given formula produces an error are returned NO MATTER WHAT—even when a different record ID is supplied. For example, I have many records with a {Start Date} field containing a date and one record with an empty {Start Date} field. IF I use the API to ask for records with filterByFormula=“RECORD_ID()=‘rec5pBFqsn3Bva8mz’”, I will of course, only get that one record. As Expected. And if I use the API to ask for multiple records using filterByFormula=“OR(RECORD_ID()=‘rec5pBFqsn3Bva8mz’,RECORD_ID()=‘n3Bva8mzrec5pBFqs’”), I will get only the records I specified. As Expected. However, if my formula references the {Start Date} field, then any records on which that formula produces an error will be returned, even though its record ID was not among those specified. So using DATETIME_DIFF on the {Start Date} column in a filterByFormula means I’ll ALWAYS have the records wi

Hi, I’m having problem to create new record with a link to another record. An “422” error occurred when trying to create record on "appfIRESxNQnQ5D05:prodej" : Value “recl8c3CDNQECQCyR” contains duplicate value. Each record ID must appear only once I’m not sure what does it mean. This is an array of fields: array (6) id => 173 jmeno_prijmeni => "Petr Ogurčák" (14) email => "petr@ogurcak.cz" (15) datum => NULL zpusob_dopravy => "recl8c3CDNQECQCyR" (17) zpusob_platby => "reccQSEWSSsVCVtnb" (17) And the same data in json "{"fields":{"id":173,"jmeno_prijmeni":"Petr Ogur\u010d\u00e1k","email":"petr@ogurcak.cz","datum":null,"zpusob_dopravy":"recl8c3CDNQECQCyR","zpusob_plat ... "

Since Zapier already has the ability to show base table and view info I was wondering if there could be (is?) an option to query metadata from the api. It would enable me to automate some checks and create Zapier-like ease of use.

Hello! We just released updates to the API that allow filtering which records are returned using a formula, limiting which fields are returned, and sorting on multiple fields. You can read more on our blog or in the API documentation.