Help

Improper formatting URL when using "filterByFormula" with Dexter bot

Topic Labels: API
1505 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Feola
4 - Data Explorer
4 - Data Explorer

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?

3 Replies 3
openside
10 - Mercury
10 - Mercury

your filterByFormula is not valid json. try:

{"filterByFormula": "FIND('FormalName','My Name')"}
Michael_Feola
4 - Data Explorer
4 - Data Explorer

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

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