Re: Airtable API to Excel VBA

693 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Reply 1

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.