Improper formatting URL when using "filterByFormula" with Dexter bot

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

$ POST https://api.airtable.com/v0/<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 https://api.airtable.com/v0/<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?

your filterByFormula is not valid json. try:

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

Thank you!
This was the fixed version

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

1 Like

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.

${{records}}