I am using the API to search for customer records. Any that have single quotes in their names are erroring in teh API. I have tried encordURI, as well as replacing the single quotes with %27 and keep getting the same error. Any advice on how to search for a name with a single quote?
https://rest.method.me/api/v1/tables/Entity?filter=Name eq 'Magnolia's%20Best%20Storage'
"title": "Bad Request",
"detail": "Invalid or unsupported query parameter. Error Detail: Syntax error at position 19 in 'Name eq 'Magnolia's Best Storage''.",