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 Screen Shot 2022-05-02 at 07.23.33](/t5/image/serverpage/image-id/3706iE780617A1ECB5E82/image-size/large?v=v2&px=999)
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: