Forum | Appery.io

Hi

I am trying to retrieve data based on a text string filter. The problem is that appery is converting my ' character to %27.

In Test tab of the appery query service, the character ' is recognized perfectly (and not converted) Data based the filter is retrieved perfectly. So why does it not work when I create the js filter accordingly in the mapping. Why is appery converting my ' character instead of leaving it as is?

This is my code
return('email='+ "'" +value+ "'"+'');

Filtering on numbers works fine as the ' character is not used.

Hello Deon,

This is default safe-url methd to change quotes: http://stackoverflow.com/questions/69...

Please use JS below there if you need to send data with them:
prereturn "email=\'" + value + "\'";/pre

Great thank you. The following code as I had it works as well. I had to clear the cache again for it to work.

return('email='+ "'" +value+ "'"+'');

can close this ticket