Re: API Filter - How to search for a Company Name that has a single quote in it?

Method_Paul — Mon, 06 Feb 2023 20:00:19 GMT

Jamie -

Escaping with a redundant quote will do the trick in escaping the url parameter: (i.e. Magnolia''s not Magnolia's)

https://rest.method.me/api/v1/tables/Entity?filter=Name eq 'Magnolia''s%20Best%20Storage'

Paul

API Filter - How to search for a Company Name that has a single quote in it?

jamieroyce — Sat, 04 Feb 2023 07:25:07 GMT

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?

REQUEST:

https://rest.method.me/api/v1/tables/Entity?filter=Name eq 'Magnolia's%20Best%20Storage'

RESPONSE:

{

"type": "https://tools.ietf.org/html/rfc7231#section-6.5.1",

"title": "Bad Request",

"status": 400,

"detail": "Invalid or unsupported query parameter. Error Detail: Syntax error at position 19 in 'Name eq 'Magnolia's Best Storage''.",

"traceId": "00-143685aec96f5b45968e0c54e79a5f01-3697423975408040-00"

}

Method:API Q&A

Re: API Filter - How to search for a Company Name that has a single quote in it?

API Filter - How to search for a Company Name that has a single quote in it?