- URL:https://<network-layer-url>/queryLookupTable
- Version Introduced:10.7.1
Description
License:
The ArcGIS Location Referencing license is required to use this resource.
This operation retrieves a list of matching key/value pairs from the lookup table based on a prefix entered by the user and the values in the lookup table configured for use by the network.
Networks that utilize a multifield route ID may optionally specify a lookup table to be used as one of the route ID fields. The lookup table includes a set of key/value pairs. The user interface for defining a multifield route ID will typically present a list of values from the lookup table. When the user selects one of the values for use in the route ID field, the corresponding key will be retrieved and used in constructing the route ID.
For example, if you search the lookup table using the prefix abc and it contains the values abc, abcd, and abcde, the key and value pairs for all those values will be returned. Values such as ab and bc will not be returned.
Request parameters
| Parameter | Details |
|---|---|
| f | Optional parameter to specify the response format. The default response format is html. Values: html | json |
| fieldName | Required Description: The name of the field in the multifield route ID that will use the lookup table. The stored value in the multifield route ID field will be from the key column in the lookup table. |
| prefix | Description: Optional parameter to provide the first few characters used for potential matches based on the lookup table values. The search is case insensitive. Default: If prefix is not specified, all of the entries in the lookup table are returned. Syntax: "prefix" : "<value prefix>" Example: "prefix" : "abc" |
Example usage
The following examples demonstrate how to query the lookup table for key/value pairs:
Example 1
The URL for querying the lookup table for all key/value pairs for the RouteSystem multifield route ID column.
https://sampleserver/arcgis/rest/services/MyLRS/MapServer/exts/LRServer/networkLayers/0/queryLookupTable?f=json&fieldName="RouteSystem"
Example 2
The URL for querying the lookup table for key/value pairs for the County multifield route ID column where the values begin with "Wash."
https://sampleserver/arcgis/rest/services/MyLRS/MapServer/exts/LRServer/networkLayers/0/queryLookupTable?f=json&fieldName="County"&prefix="Wash"
JSON response syntax
The following syntax shows parallel arrays of keys and values:
{
"keys" : [ "key1","key2","key3","key4", ... ]
"values" : [ "value1","value2","value3","value4", ... ]
}
JSON response example
{
"keys" : [ "1","2","3","4", … ]
"values" : [ "I-25","I-225","I-70","I-76", ... ]
}