Search API

Hosted Data Object

The following table describes the parameters needed to make a Hosted Data request. Refer to the Data Sets section below to see what types of MapQuest-hosted data sets are available for searching. Also, with a MapQuest account, you upload your custom data sets to the MapQuest Data Manager and search them by using a Hosted Data request.

Name Description
tableName
String
The name of the Data Manager table to search.
extraCriteria
String
The SQL WHERE clause to query the data; used to narrow down the results.
parameters
String[]
The second portion of the WHERE clause; used to narrow down the results.
columnNames
String[]
The list of fields to return with each result. All fields will be returned if this parameter is not passed into the request.

Example

The following are examples of a Hosted Data Request which only return POI results within the city of Denver. It is also customized to only return the name, address, city, and state fields.

Note: When querying your own hosted Data Manager tables, it is recommended that field names are entered in lowercase. Otherwise, you may encounter errors related to the field names.

Type Example
Key/Value Pairs
?hostedData=mqap.ntpois|city ILIKE ?|denver|name,address,city,state
JSON
"hostedDataList": [
   {
    "tableName": "mqap.ntpois",
    "extraCriteria": "City ILIKE ?",
    "parameters": [
        "denver"
    ],
    "columnNames": [
        "name",
        "address",
        "city",
        "state"
    ]
}
]
XML
<hostedDataList>
    <hostedData>
        <tableName>mqap.ntpois</tableName>
        <extraCriteria>City ILIKE ?</extraCriteria>
        <parameters>
            <parameter>denver</parameter>
        </parameters>
        <columnNames>
            <columnName>name</columnName>
            <columnName>address</columnName>
            <columnName>city</columnName>
            <columnName>state</columnName>
        </columnNames>
    </hostedData>
</hostedDataList>

Data Sets

Name Description Enterprise
mqap.ntpois Default data set of approximately 13.5 million Points of Interest for the U.S. and Canada. Free
mqap.internationalpois Data set of Points of Interest outside of the U.S. and Canada. Free
mqap.uspostalcodes Zip codes of the United States. Free
mqap.geonttowns Data set containing locations of city centers. Free
mqap.usstateboundaries Data set containing US state boundaries information. Free