Improper formatting URL when using "filterByFormula" with Dexter bot

[Michael_Feola]

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?

[openside]

your filterByFormula is not valid json. try:

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

[Michael_Feola]

openside:

{“filterByFormula”: “FIND(‘FormalName’,‘My Name’)”}

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

[Adam_Bergeman]

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}}