Rest API Query feature server WHERE IN limit

2741
3
01-19-2018 06:56 AM
PawanVuppala
Occasional 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
New Contributor III

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
New Contributor III

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
Occasional Contributor

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

0 Kudos