- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 11, 2022 02:02 AM
hey everyone,
I’m not sure why but I’m getting an empty result when using filterbyformula with a date function. I’m trying to receive all records that hold a certain date in a certain field. The field also might be empty on some records just if that matters, but I double checked there are records for these fields.
Here’s my query…
GET https://api.airtable.com/v0/appXYZ/Bestellungen?fields%5B%5D=Datum%20Abb.&fields%5B%5D=SU%20Beleg&filterByFormula=IS_SAME(%22Datum%20Abb.%22,%222021-12-20%22)&view=Buchhaltung%20Online%20DE
So i’m doing filterByFormula with "IS_SAME(“Datum Abb.”, “2021-12-06”)
I tried IS_AFTER and IS_BEFORE also to double check and even have more records to show but all I get is an empty result. I tried using other formulas on others fields that worked fine but I can’t get this to work. Am I overlooking something? Is the space in the field name causing any issues here? I mean it is URL encoded correctly but i’m still not sure if it could be an issue. I can’t simply change the field name due to other constraints…
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 11, 2022 05:06 AM
That is not encoded properly.
Use Airtable’s API URL encoder tool to help you.
The link to a personally-customized version of this tool is available to you in the REST API documentation. Go into a base, then a table, then choose “List Records”.