Airtable INVALID_FILTER_BY_FORMULA

Ask a question
1

I am getting this error when sending the following get request to airtable…

{
“error”: {
“message”: “The formula for filtering records is invalid: Invalid formula. Please check your formula text.”,
“type”: “INVALID_FILTER_BY_FORMULA”
}
}

https://api.airtable.com/v0/appc123456/SKUs/?filterByFormula=SKU=’{SKU}’

The actual request looks like this
{
“headers”: {
“Authorization”: “Bearer keyTuMadre”,
“Content-Type”: “application/json”
},
“method”: “GET”,
“url”: “https://api.airtable.com/v0/appc123456/SKUs/?filterByFormula=SKU=‘PA%20RC%20SB%20OK%20AF%20AFLOSB#’”
}

Any ideas why this formula is invalid?

2

Hey @David_Valentine,

Your API Endpoint URL has an extra forward slash after your SKUs table. Try removing that to see if you can update your table.

If that doesn’t work, you’ll need to wrap the SKU column in double quotes to ensure it’s passed as a string value. Your final endpoint might look like this:

GET https://api.airtable.com/v0/appc123456/SKUs?filterByFormula=SKU="{SKU}"

Let me know if that works!