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 datasets are available for searching. Also, with a MapQuest account, you upload your custom datasets 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 Lancaster. 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 ?|lancaster|n,address1,city,state
JSON hostedData: [
   {
      tableName:mqap.ntpois,
      extraCriteria:City ILIKE ?,
      parameters:[
         lancaster
      ],
      columnNames:[
         name,
         address,
         city,
         state
      ]
   }
]
XML <hostedDataList>
   <hostedData>
      <tableName>mqap.ntpois</tableName>
      <extraCriteria>City ILIKE ?</extraCriteria>
      <parameters>
         <parameter>lancaster</parameter>
      </parameters>
      <columnNames>
         <columnName>name</columnName>
         <columnName>address</columnName>
         <columnName>city</columnName>
         <columnName>state</columnName>
      </columnNames>
   </hostedData>
</hostedDataList>

Data Sets

Name Description Community Accounts Enterprise Accounts
mqap.ntpois Default dataset of around 2 million Points of Interests for the U.S. and Canada. Free. Free.
mqap.internationalpois Dataset of Points of Interests outside the U.S. and Canada. Free. Free.
mqap.pblna Premium Localeze Business Listings of North America. Free if moving to an Enterprise account.
Contact Support		 Pay.
mqap.uspostalcodes Zip codes of the United States. Free. Free.

  © MapQuest, Inc. All rights reserved.    Privacy Policy | Terms of Use