Development & APIs

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?

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?

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.

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.

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() ))

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

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

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.