queryTableDataSource | Web Map Specification

Query table data source is a layer/table that is defined by a SQL query.

Referenced by: dataSource

Properties

Property	Details
geometryType	The geometry type. When querying a table that does not have a geometry column, do not include geometryType. Valid values: `esriGeometryMultipoint` `esriGeometryPoint` `esriGeometryPolygon` `esriGeometryPolyline`
oidFields	Comma separated list of identifier fields. There are only certain field types that can be used as a unique identifier. These field types include integer, string, GUID, and date. If a single integer field is specified, map server uses the values in that field directly to uniquely identify all features and rows returned from a queryTable. However, if a single string field or a group of fields is used as the unique identifier, map server maps those unique values to an integer.
query	The SQL query.
spatialReference	The spatial reference of the geometry column. When querying a table that does not have a geometry column, do not include spatialReference.
type	String value indicating the type for the dataSource. Valid value of this property `queryTable`
workspaceId	The unique string value used to identify the datasource’s workspace.

Example

{
  "type": "queryTable",
  "workspaceId": "SqlMAP",
  "oidFields": "taxlotid",
  "query": "SELECT * FROM TaxLots",
  "geometryType": "esriGeometryPolygon",
  "spatialReference": {
    "wkid": 4326
  }
}