Skip to content

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.

NameDescription
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.

TypeExample
Key/Value Pairs`?hostedData=mqap.ntpois
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

NameDescriptionEnterprise
mqap.ntpoisDefault data set of approximately 13.5 million Points of Interest for the U.S. and Canada.Free
mqap.internationalpoisData set of Points of Interest outside of the U.S. and Canada.Free
mqap.uspostalcodesZip codes of the United States.Free
mqap.geonttownsData set containing locations of city centers.Free
mqap.usstateboundariesData set containing US state boundaries information.Free