Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Using a post request to retrieve record id with a filter

584 1
cancel
Showing results for 
Search instead for 
Did you mean: 
veezyautomation
4 - Data Explorer
4 - Data Explorer

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.

veezyautomation_0-1738856311478.png

veezyautomation_1-1738856468844.png

 

1 Reply 1

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&filterByFormul...

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