You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If I run a basic field search using a string that contains quotes:
Airtable::where('Story', 'He said "no"')->get();
I receive an error:
{
"error": {
"type": "INVALID_FILTER_BY_FORMULA",
"message": "The formula for filtering records is invalid: Invalid formula. Please check your formula text."
}
}
I think this is because addFilter() in AirtableApiClient.php is passing the string value through to Airtable without escaping the quotes, confusing the filter:
If I run a basic field search using a string that contains quotes:
Airtable::where('Story', 'He said "no"')->get();
I receive an error:
I think this is because addFilter() in AirtableApiClient.php is passing the string value through to Airtable without escaping the quotes, confusing the filter:
$this->filters[] = "{{$column}}{$operation}\"{$value}\"";
If I escape the quotes in my text, it works.
Airtable::where('Story', 'He said \"no\"')->get();
(There may be a better way to handle this more broadly in constructing API queries than just escaping quotes, but that's as far as I got.)
The text was updated successfully, but these errors were encountered: