Hi all,


I need to retrieve a list of items from a formula filter like this filter

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":c]}

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

Maybe I’m writing my formula incorrectly?

Thank you for your time