topic Re: Rest API Query feature server WHERE IN limit in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717653#M3470 <HTML><HEAD></HEAD><BODY><P>Thank you so much for your response.&nbsp; I appreciate your help!</P></BODY></HTML> Mon, 12 Feb 2018 17:46:02 GMT PawanVuppala 2018-02-12T17:46:02Z Rest API Query feature server WHERE IN limit https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717650#M3467 <HTML><HEAD></HEAD><BODY><P>Hello Gurus,</P><P>I am running into this issue where I'm not able to pass more than 136 zip codes using the standard USA zip codes layer.&nbsp; Check out the query string that fails when I hit all zipcodes needed, please advise.&nbsp; Any feedback would be greatly appreciated.</P><P><A class="jive-link-external-small" href="https://community.esri.com/external-link.jspa?url=https%3A%2F%2Fservices.arcgis.com%2FP3ePLMYs2RVChkJx%2FArcGIS%2Frest%2Fservices%2FUSA_ZIP_Codes_2015%2FFeatureServer%2F0%2Fquery%3Ff%3Djson%26where%3DUPPER%28ZIP_CODE" rel="nofollow" target="_blank">https://services.arcgis.com/P3ePLMYs2RVChkJx/ArcGIS/rest/services/USA_ZIP_Codes_2015/FeatureServer/0/query?f=json&amp;where=UPPER(ZIP_CODE</A><SPAN>) IN ('77002','77003','77004','77005','77006','77007','77008','77009','77010','77011','77012','77013','77014','77015','77016','77017','77018','77019','77020','77021','77022','77023','77024','77025','77026','77027','77028','77029','77030','77031','77032','77033','77034','77035','77036','77037','77038','77039','77040','77041','77042','77043','77044','77045','77046','77047','77048','77049','77050','77051','77053','77054','77055','77056','77057','77058','77059','77060','77061','77062','77063','77064','77065','77066','77067','77068','77069','77070','77071','77072','77073','77074','77075','77076','77077','77078','77079','77080','77081','77082','77083','77084','77085','77086','77087','77088','77089','77090','77091','77092','77093','77094','77095','77096','77098','77099','77335','77346','77359','77360','77364','77396','77401','77406','77407','77417','77423','77429','77433','77440','77441','77444','77447','77449','77450','77455','77456','77458','77459','77461','77468','77469','77471','77477','77478','77479','77483','77484','77485','77489','77493','77494','77498','77502','77503','77504','77505','77506','77507','77511','77514','77518','77519','77520','77521','77530','77532','77536','77538','77539','77545','77546','77547','77560','77562','77565','77571','77573','77578','77581','77583','77584','77586','77587','77598')&amp;returnGeometry=true&amp;spatialRel=esriSpatialRelIntersects&amp;outFields=ZIP_CODE&amp;outSR=102100</SPAN></P></BODY></HTML> Fri, 19 Jan 2018 14:56:42 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717650#M3467 PawanVuppala 2018-01-19T14:56:42Z Re: Rest API Query feature server WHERE IN limit https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717651#M3468 <HTML><HEAD></HEAD><BODY><P>You should use POST instead of GET. You exceeded 2000 symbols in GET request.</P><P></P><P>By the way, no need to use UPPER in this case.</P></BODY></HTML> Fri, 19 Jan 2018 15:32:36 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717651#M3468 RamunasKraujutis 2018-01-19T15:32:36Z Re: Rest API Query feature server WHERE IN limit https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717652#M3469 <HTML><HEAD></HEAD><BODY><P>I think if you cast the ZIPCODE in integer&nbsp;<A class="link-titled" href="https://support.esri.com/en/technical-article/000011922" title="https://support.esri.com/en/technical-article/000011922">How To: Cast a number to a string using SQL</A>&nbsp; and then you create the where like this one WHERE (ZIP_CODE &gt; 77041 AND&nbsp;<SPAN>ZIP_CODE &lt; 77080) OR . .. I think this can help you.</SPAN></P></BODY></HTML> Fri, 19 Jan 2018 19:57:12 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717652#M3469 Juan_ManuelAngel 2018-01-19T19:57:12Z Re: Rest API Query feature server WHERE IN limit https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717653#M3470 <HTML><HEAD></HEAD><BODY><P>Thank you so much for your response.&nbsp; I appreciate your help!</P></BODY></HTML> Mon, 12 Feb 2018 17:46:02 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/rest-api-query-feature-server-where-in-limit/m-p/717653#M3470 PawanVuppala 2018-02-12T17:46:02Z