The API, which is very well documented, is far from marvelous. For example, there is no way to use a transaction to update two (or more) tables at the same time. It is also rate limited to a tiny 5 requests per second, even under paid plans. The API also does not allow you to request relational data in one request. You make a request to get the parent id, then all the children, by parent id, in a separate request.
I'll also say that the company feels a bit dead. You look at the changelog and they add a couple features here and there, while other features, such as barcode scanning (probably a weekend hackathon feature) languish by the wayside. They respond quickly to support requests with answers like 'we will add that to the long list of things we want to do'... riiigght...
https://www.crunchbase.com/organization/airtable#section-fun...