Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,665 Topics
  • 11,735 Replies
3665 Topics
I
Izaac_PostKnown Participant
posted in Development & APIs
API Templates and Examples

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!

206
I
C
Chester_McLaughInspiring
asked in Development & APIs
Formula using {Start Date} field always returns records with empty {Start Date}

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 with empty {Start Date} included in the results—even if I try to in

163
K
P
Petr_OgurcakNew Participant
posted in Development & APIs
Create new record with foreign key

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 ... "

41
A
T
TuurInspiring
posted in Development & APIs
Expose base dictionary

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.

51
T
K
Kasra_Kyanzade1Participating Frequently
posted in Development & APIs
API Update: filtering records, limiting fields, better sorting

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.

33
C
A
Andrew_EnrightKnown Participant
posted in Development & APIs
Slack Bot How-To?

Anyone able to give us a quick run-down of how to code a Slack Bot that can answer queries against an Airtable dataset? Specifically, we’re looking to build a bot that can define terms; a glossary using Airtable for look-ups. But that said, I’m sure the ability to ask a bot questions about any Airtable base could be huge; it’s like single-database-Siri (without all the talking). A.

40
A
J
J_RNew Participant
posted in Development & APIs
Recommended way to perform a find within a select using the Node library

Hi, I’m using the Node library to access the API. As I understand it, when the value in a field is a reference to another table, the only thing that’s returned is the ID of row in that table. So, if I have a Books table and an Authors table and use something like base('Books').select then it will return an ID for the author instead of the author information. That’s great! The issue I’m running into is: what’s the best way to subquery for that linked data, e.g. to also grab the Author information, in my select function I’m trying to build a pretty simple JSON object from Airtable data to pass on as a template context, using Express. Basically, I want to call to the Airtable API, perform a select, pull all the relevant data, and then pass that data on. For example, if I have a Books table and an Authors table, Books would obviously contain a column with that references Authors. I want to run a select function on Books and grab the authors as well. My Object would look something like this

10
J
C
Chris_MoyerNew Participant
posted in Development & APIs
View "now" filters don't update through the API

I’m using the Airtable API to pull down data from a View that is filtered by “now” filters. I have a calculated field which returns how many days it has been since that record was created (to return “everything that was created yesterday”) as well as a view that filters on “everything that was edited yesterday” which is also calculated based on a date field we have set. In both cases, I am hitting the API using those views to pull down the relevant records, but that data doesn’t change unless someone is physically viewing that view on the web portal. That is to say, if we don’t open that view those filters don’t get updated and we end up getting the same results each time we hit the API even if the results should have changed. Is there any known work-around other then having a browser open to both views before my script is run?

61
C
K
Kareem_SultanNew Participant
posted in Development & APIs
Is there a way to 'patch' a record?

If I PUT a record without including every field, those missing fields are emptied losing the data that they held. Is there a way to PATCH a record by only supplying the modified fields ensuring the rest are untouched?

22
K
M
Mike_EovinoKnown Participant
posted in Development & APIs
filterByFormula - link column

Is there a way to use the filterByFormula URL parameter to retrieve rows based on the value of a link column? I can look up text and numeric values, but it looks like link columns are an array. I’ve tried: AND(Column_Name=[recordID]) AND(Column_Name="[recordID]") AND(Column_Name=’[recordID]’) and nothing seems to work. Any help would be greatly appreciated.

183
C
C
Charles_HaugheyNew Participant
posted in Development & APIs
Build query to trim the data returned

It was referencing the Api for the ‘Favorite Movies’ demo database. To test and learn the api, I was trying to retrieve data from the table Movies and only bring back a description of the movie The Godfather. I tried various codes using the method ‘Query Parameter’ (airtable’s description with this name inside the api) see below: https://api.airtable.com/v0/appID/Movies?fields[The%20Godfather]=Description&api_key=MyKey I tried other possibilities but I was returned an error or the descriptions of all the movies in the table.

52
C
C
Chester_McLaughInspiring
posted in Development & APIs
filterByFormula with OR nested inside AND

I’m attempting to find a list of specific records that also meet other criteria, such as a date—however nothing is returned. AND( IS_BEFORE({Start Date},TODAY()), OR(RECORD_ID()=‘recyZ1f0RSR1rTr3Z’,RECORD_ID()=‘recIFWsWuTPjAkxhg’)) Is it possible to nest a OR inside an AND? Is there another way I’m not thinking of? AND( TRUE(), OR( TRUE(), FALSE(), FALSE() ))

81
C
T
Tim_DietrichKnown Participant
posted in Development & APIs
Requesting Data / Views

Just a heads up: When requesting data via the API, if you specify a view that doesn’t exist, then the current version of the API will return a NULL result (instead of throwing an error). I ran into this by accident. I was using a view name that had a space in it, and the name wasn’t URL-encoded. For example, “Main View” instead of “Main+View.” ~ Tim

22
A
T
Tim_DietrichKnown Participant
posted in Development & APIs
Idea: Link to a Base's API

When viewing a base in Airtable (via the browser interface), it would be really convenient to be able to click on a link and jump directly to that base’s API documentation. Maybe add it to the “Share” area? ~ Tim

82
T
E
Emmett_NicholasInspiring
posted in Development & APIs
About the API category

Discuss the Airtable API Airtable Airtable: Organize anything you can imagine Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

10
E

Badge winners

Show all badges
Terms & Conditions