Skip to main content

How to filterByFormula a record with an email

  • November 21, 2018
  • 3 replies
  • 110 views
N

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

A
Forum|alt.badge.img+3
  • Andrew_Johnson1
  • Participating Frequently
  • November 21, 2018

Did you URL encode your request?

N
  • Nicolas_Monnier
  • Author
  • New Participant
  • November 21, 2018

Did you URL encode your request?


Yes requests does it by itself

G
Forum|alt.badge.img+4

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')"}

H
N
F
Terms & ConditionsAccessibility statement