Skip to main content

Using a post request to retrieve record id with a filter

  • February 6, 2025
  • 1 reply
  • 2 views
V

Hello, I'm having an issue with getting anything back when sending a post request.
Using Voiceflow to integrate into airtable.com

The objective is for a patient/customer to be able to change their email and have the bot do it for them if the bot recognized that their email was different but first name, last name, number, etc were the same.


There is no error, I'm getting a 200 back but the response is [] or empty
The fields are filled out and I checked capitalization
Screenshots are below, any help would be appreciated.
I checked the base ID and table for the API call and its correct
I've tried just using a filterbyformula in a get request and it does the same thing and returns a ok 200 and empty response.

 

    1 reply

    TheTimeSavingCo
    Forum|alt.badge.img+18

    We need to use a GET for that I'm afraid.  Here's the docs: https://airtable.com/developers/web/api/list-records

    And here's an example query that looks for the text 'Hello' in a field titled 'Email', and returns the fields 'Email' and 'Email ID':

    https://api.airtable.com/v0/BASE_ID/TABLE_ID?fields%5B%5D=Email&fields%5B%5D=Email+ID&filterByFormula=SEARCH('Hello'%2C%7BEmail%7D)

    There's also a helpful tool to help you create these URLs here: https://codepen.io/airtable/full/MeXqOg

    Adam, Consultant @ The Time Saving Co

    Reply


    Most helpful members this week

    Terms & Conditions