Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Improper formatting URL when using "filterByFormula" with Dexter bot

Topic Labels: API
2054 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}}