How are single quotes escaped in filter query string values?

[jsd (Jeremiah Sturgill)]

Filter API calls for tickets, contacts, and so on (e.g. filter tickets) require string values to be enclosed in single quotes:

query?"some_string_field:'some value'"

How are string values that contain single quotes represented?

query?"some_string_field:'fred's car'"

Should the internal single quote be double URL-encoded? Escaped with a slash? Or are strings containing single quotes simply invalid for use in filters?

[Santhosh (Santhosh Balusamy)]

Hi @jsd
Welcome to the community!

@jsd

Should the internal single quote be double URL-encoded? Escaped with a slash? Or are strings containing single quotes simply invalid for use in filters?

AFAIK, you can do the escaped with a backslash.

Thanks

[jsd (Jeremiah Sturgill)]

Backslashes do not work to allow string values that contain single quotes. A request to api/v2/search/contacts?query="email='test+\'@gmail.com'" results in a validation failure. The same API request without the \' works as expected.

[Santhosh (Santhosh Balusamy)]

@jsd,
Let me check with the product team and get back at the earliest

Thanks

[Santhosh (Santhosh Balusamy)]

@jsd,
I had checked with the product team and it wont work on Filter ticket API and it’s been a known bug for quite sometime, As of now there is no workaround is what the team said.

Hope it helps

Thanks