Feb 28, 2024 06:24 AM
Trying to use this request. Any advice to my logic?
Feb 28, 2024 06:32 AM
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.
Feb 28, 2024 05:48 PM
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?