topic Re: ArcGIS Server API Identify null value in ArcGIS Enterprise Questions

ArcGIS Server API Identify null value

SchoppMatthieu — Wed, 07 May 2014 12:17:30 GMT

I noticed something inconsistent with "null" value handling in ArcGIS Server.

While doing "Queries", null values are retrieved as null (see attachment). While doing Identifies, null values are retrieves as string : "Null" (see attachment)

These are examples of "Query" and "Identify" for the same data so you can notice the difference also illustrated in the attachment :

Identify :

http://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/MapServer/identify?geometry=%7B%22xmin%22%3A-9814291.012764301%2C%22ymin%22%3A5127179.36590259%2C%22xmax%22%3A-9812674.40536442%2C%22ymax%22%3A5128639.868823595%7D&geometryType=esriGeometryEnvelope&sr=&layers=&layerDefs=&time=&layerTimeOptions=&tolerance=0&mapExtent=%7B%22xmin%22%3A-9814291.012764301%2C%22ymin%22%3A5127179.36590259%2C%22xmax%22%3A-9812674.40536442%2C%22ymax%22%3A5128639.868823595%7D&imageDisplay=255&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&dynamicLayers=&returnZ=false&returnM=false&gdbVersion=&f=pjson

Query :

http://sampleserver6.arcgisonline.com/arcgis/rest/services/ServiceRequest/MapServer/0/query?where=OBJECTID+%3D+101156&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=*&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&returnDistinctValues=false&f=pjson

[ATTACH=CONFIG]33643[/ATTACH]

I couldn't find anything about this on the forum and documentation.
Please, can anyone provide explanations ? Thanks

Also "Identify" return field aliases instead of field names, which is not handy at all.

Re: ArcGIS Server API Identify null value

TanuHoque — Thu, 08 May 2014 14:54:35 GMT

Schopp,
that is expected behavior.

Query operation returns the value in the original data type.

Whereas Find and Identify operations return formatted string e.g. depending on the format assigned to the field, the return string may look like $123,345.90 or 9.054% etc.

Hope this helps.