Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: API
1024 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Edouard_CLAUDE
4 - Data Explorer
4 - Data Explorer

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