Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Filter by formula AND(IS_BEFORE(), [expression, ...])

Topic Labels: API
242 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all,
I need to retrieve a list of items from a formula filter like this filter
Screen Shot 2022-05-02 at 07.23.33

To do this I use “API URL encoder tool” here is my formula:

AND(RECORD_ID_CONTACT="recXXX1234", Statut="🤝 Mission conclue", IS_BEFORE("Fin de mission", TODAY()))

curl:

curl https://api.airtable.com/v0/appXXX1234/%F0%9F%96%B2%20Disponibilit%C3%A9s?filterByFormula=AND(RECORD_ID_CONTACT%3D%22recXXX1234%22%2C+Statut%3D%22%F0%9F%A4%9D+Mission+conclue%22%2C+IS_BEFORE(%22Fin+de+mission%22%2C+TODAY()))&sort%5B0%5D%5Bfield%5D=Fin+de+mission&sort%5B0%5D%5Bdirection%5D=desc&view=%F0%9F%94%BD+Chrono \
-H "Authorization: Bearer keyXXX"

response is :

{"records":[]}

If I remove IS_BEFORE from my request, I have results.

Maybe I’m writing my formula incorrectly?

Thank you for your time :slightly_smiling_face:

0 Replies 0