Airtable API to Excel VBA

Hi! I have an excel VBA tool and I’m inclined to use Airtable as the tool’s back-end database (db). Based on the user’s input text (string), I’m looking for Airtable API that will loop through all fields and return if text is present in the db, else return NULL.
Now, I’ve looked at the Airtable GET API documentation but the request parameter is based on recordID, so that doesn’t suit my requirement.
However, it looks like can work with filterbyformula.

Not sure how to do this with VB scripting, but this would be a piece of cake with Integromat, which is a low-code automation tool. It has full support for Excel, Airtable, and hundreds of other apps.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.