Select to view content in your preferred language

Rest API Query feature server WHERE IN limit

3393
3
01-19-2018 06:56 AM
PawanVuppala
Frequent Contributor

Hello Gurus,

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.  Check out the query string that fails when I hit all zipcodes needed, please advise.  Any feedback would be greatly appreciated.

https://services.arcgis.com/P3ePLMYs2RVChkJx/ArcGIS/rest/services/USA_ZIP_Codes_2015/FeatureServer/0...) 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')&returnGeometry=true&spatialRel=esriSpatialRelIntersects&outFields=ZIP_CODE&outSR=102100

Tags (1)
0 Kudos
3 Replies
RamunasKraujutis
Occasional Contributor

You should use POST instead of GET. You exceeded 2000 symbols in GET request.

By the way, no need to use UPPER in this case.

Juan_ManuelAngel
Esri Contributor

I think if you cast the ZIPCODE in integer How To: Cast a number to a string using SQL  and then you create the where like this one WHERE (ZIP_CODE > 77041 AND ZIP_CODE < 77080) OR . .. I think this can help you.

0 Kudos
PawanVuppala
Frequent Contributor

Thank you so much for your response.  I appreciate your help!

0 Kudos