Help

How do I filter down by email field and stage field and record type field in API request for airtabl

666 2
cancel
Showing results for 
Search instead for 
Did you mean: 
originalgenetic
4 - Data Explorer
4 - Data Explorer
2 Replies 2

1. The Airtable API encoder tool will be able to help you craft this sort of an API call to Airtable.

2. Also, there are some great examples of API calls that Airtable has personally customized for you on your own personalized web API documentation page. Scroll down to choose your base from the list of bases.

3. Also, for people who are reading this in the future and are looking for a non-coding way of doing this that doesn’t require writing any custom programming code at all, you can make all of these same API requests using Make’s Airtable integrations. Make provides a user-friendly, no-code, point-and-click environment to do all of this.

Hmm, I copy pasted your link and it looks like this:

https://api.airtable.com/v0/appv33ENPkh3E1ocj/Opportunities?filterByFormula=https%3A%2F%2Fapi.airtable.com%2Fv0%2Fappv33ENPkh3E1ocj%2FOpportunities%3FfilterByFormula%3DAND(Email%3D%27%7B%7BemailInput%7D%7D%27%2C+OR(Stage%3D%27Needs+Underwriting%27%2C+Stage%3D%27Make+Listing+Price+Proposal%27%2C+Stage%3D%27Due+Diligence+Items%27%2C+Stage%3D%27Appointment+Set%27%2C+Stage%3D%27Final+Underwriting+Review%27%2C+Stage%3D%27Follow+Up%27%2C+Stage%3D%27Long+Term+Follow+Up%27%2C+Stage%3D%27Negotiation%27%2C+Stage%3D%27Retail%27%2C+Stage%3D%27Closed+Lost%27%2C+Stage%3D%27Closed+Won%27)%2C+Record+Type%3D%27Seller+Opportunity%27)

After your first filterByFormula, it looks like another URL, which doesn't seem right.  It also looks like you're using a variable called 'emailInput'?  Are you dynamically generating this link?

It also seems like you've got 5-6 things you're filtering by.  Could I confirm you managed to get something working without filtering by anything, as well as when filtering by just one thing?