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

Improper formatting URL when using "filterByFormula" with Dexter bot

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

I am currently trying to pass in an option for the airtable API which is going through Dexter. The following POST method works:

$ POST<bot airtable_base>/Profile/ {"headers": {"Authorization": "Bearer <bot airtable_api_key>", "Content-Type": "application/json"},"body": {"fields": {"FormalName": "<get name>","Address": "<get address>"}}}

but I can’t seem to get this GET command to work

$ GET<bot airtable_base>/Profile/ {"headers": {"Authorization": "Bearer <bot airtable_api_key>", "Content-Type": "application/json"},"body": {"filterByFormula": {(FIND("FormalName","My Name"))}}

Anyone get this to work?

3 Replies 3

your filterByFormula is not valid json. try:

{"filterByFormula": "FIND('FormalName','My Name')"}

Thank you!
This was the fixed version

$ GET<bot airtable_base>/Profile/ {"headers": {"Authorization": "Bearer <bot airtable_api_key>"},"body": {"filterByFormula": "({FormalName} = 'My Name')"}}

Hey Michael! Did you figure out how to call on the API’s response here inside Dexter? If so, how did you do it? The below isn’t returning anything for me.