Skip to main content

Improper formatting URL when using "filterByFormula" with Dexter bot

  • September 23, 2018
  • 3 replies
  • 0 views
M

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

O
  • openside
  • Inspiring
  • 351 replies
  • September 23, 2018

your filterByFormula is not valid json. try:

{"filterByFormula": "FIND('FormalName','My Name')"}
M
1 person likes this
  • M
    Michael_Feola
M
  • Michael_Feola
  • Author
  • New Participant
  • 1 reply
  • September 23, 2018

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

O
1 person likes this
  • O
    openside
A
Michael_Feola wrote:

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

Reply


Most helpful members this week

Terms & Conditions