Apostrophes/single quotes not handled about pyairtable

[gtalarico]

Interesting. Thanks for the suggestion.
Per the airtable documentation, I think single and double quotes need to be escaped with a backslash.
Maybe we can add a simple regex replacement that replaces unescaped quotes with /' and /"

[aracnid]

It's easy enough to escape the input field value before it is passed into the function.

val_escaped = val.replace("'", r"\'")

[peterkaminski]

An intermediate fix would be to add a note to the documentation regarding escaping quotes in field values.

Interestingly, I had this problem with table.match() and a single quote, but a subsequent table.insert() with the same field value worked without escaping the single quote.

Just in case someone is searching for an example of the error message caused by an unescaped single quote, this is what I got -- basically "Invalid formula."

requests.exceptions.HTTPError: 422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appqXJzYCDQgExxDC/Actors?filterByFormula={Name}='Ryan+O'Neal' (Decoded URL) [Error: {'type': 'INVALID_FILTER_BY_FORMULA', 'message': 'The formula for filtering records is invalid: Invalid formula. Please check your formula text.'}]

[gtalarico]

I think #120 fixes this - feel free to reopen otherwise