How to call a map service passing parameters in the where field

Question

Good morning,

I am looking for a way to call a  layer in an ArcGIS Server map service passing parameters in the where  clause

https://[ArcgIS Server]/arcgis/rest/services/[My Map Service/FeatureServer/1

I would like call this service passing a parameter such as ProjectID = 1 or ProjectID = 2

How can I do that?

SanchezNuñez · Answer

Hi @jcarlson

I am looking for a way to send to Geonexus only records inserted or updated in GIS. I was thinking about adding a where clause  and then passing the service to Geonexus.

Geonexus integration with EAMS - Esri Community

jcarlson · Answer

The REST API docs have all the details. @EricAnderson_DHS 's answer is great, I would only add that you want to encode your parameters to get a URL string.

…/FeatureServer/1/query?where=(ProjectID%3D1)+or+(ProjectID%3D2)

Where are you calling this layer from, by the way?

EricAnderson_DHS · Answer

What I find helpful is adding the service to a map viewer in AGOL/Portal, create a filter using the query parameters you want, and then use the browser's Developer Tools to see exactly how the query/WHERE clause was structured. https:////rest/services/Hosted//FeatureServer/0/query?f=json&where=(projectid = 1) OR (projectid = 2)