topic LIKE query wildcards blocked by reverse proxy in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/like-query-wildcards-blocked-by-reverse-proxy/m-p/378653#M1807 <HTML><HEAD></HEAD><BODY><SPAN>We have moved our REST services behind a reverse proxy for additional security. However, any SQL where clause passed to our REST services that contain LIKE statements with percent (%) wildcards are getting blocked by the reverse proxy. Apparently this is a side-effect of the URL normalization that is performed in the reverse proxy to validate that malicious queries are not being passed. It is described under #5 here:</SPAN><BR /><BR /><A href="http://technet.microsoft.com/en-us/library/bb794802.aspx">http://technet.microsoft.com/en-us/library/bb794802.aspx</A><BR /><BR /><SPAN>I am using the queryTask in the JavaScript API to construct the queries, but this problem also appears if I try to directly query the REST service. Our system administrators are reluctant to remove the Verify normalization setting in the reverse proxy. Has anyone else encountered this problem and discovered a workaround?</SPAN></BODY></HTML> Thu, 22 Aug 2013 17:08:54 GMT MatthewLawton 2013-08-22T17:08:54Z LIKE query wildcards blocked by reverse proxy https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/like-query-wildcards-blocked-by-reverse-proxy/m-p/378653#M1807 <HTML><HEAD></HEAD><BODY><SPAN>We have moved our REST services behind a reverse proxy for additional security. However, any SQL where clause passed to our REST services that contain LIKE statements with percent (%) wildcards are getting blocked by the reverse proxy. Apparently this is a side-effect of the URL normalization that is performed in the reverse proxy to validate that malicious queries are not being passed. It is described under #5 here:</SPAN><BR /><BR /><A href="http://technet.microsoft.com/en-us/library/bb794802.aspx">http://technet.microsoft.com/en-us/library/bb794802.aspx</A><BR /><BR /><SPAN>I am using the queryTask in the JavaScript API to construct the queries, but this problem also appears if I try to directly query the REST service. Our system administrators are reluctant to remove the Verify normalization setting in the reverse proxy. Has anyone else encountered this problem and discovered a workaround?</SPAN></BODY></HTML> Thu, 22 Aug 2013 17:08:54 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/like-query-wildcards-blocked-by-reverse-proxy/m-p/378653#M1807 MatthewLawton 2013-08-22T17:08:54Z