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

How to filterByFormula a record with an email

Topic Labels: API
4412 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there,

I have a table that have records of users_email and i wanted to implement a get_by_email method from my server.

I must have missed something because I can’t get the filterByFormula to work…
I’m trying this in python:
payload = {“filterByFormula”: “({EMAIL} = "test@test.fr”)"}
r = requests.get(url, params=payload, headers=headers)

In returns i have this error :
{‘error’: {‘type’: ‘INVALID_FILTER_BY_FORMULA’, ‘message’: ‘The formula for filtering records is invalid: Invalid formula. Please check your formula text.’}}

Can someone help on this please ?
I’m a little lost
Thanks in advance :slightly_smiling_face:

3 Replies 3

Did you URL encode your request?

Yes requests does it by itself

Only thing I can think of is that you aren’t escaping your double quotes around "test@test.fr." The following works for me:


url = "https://api.airtable.com/v0/appID/tableID"

querystring = {"filterByFormula":"({EMAIL}=\"example@example.com\")"}

headers = {
    'Authorization': "Bearer airtableAPIkey",
    }

response = requests.get(url, headers=headers, params=querystring)

print(response.text)

Alternatively, you can use single quotes:
querystring = {"filterByFormula":"({EMAIL}='example@example.com')"}