Data Manager API

GET
Get Column Types

This request returns an array of column types that are supported by Data Manager.

Resource URL

http://www.mapquestapi.com/datamanager/v2/get-column-types

Resource Information

Response Formats JSON, XML
Authentication Yes (Requires Key)
Rate Limited Yes

Request Parameters

Request Parameter Description Required?
key
String
A unique key to authorize use of the API. Yes
outFormat
String
Specifies the format of the response. Must be one of the following, if supplied:
  • json
  • xml
Default = json
No

Description of Column Types

  • Geography - Geography type of the location; stores data in latitude/longitude coordinates
  • String - String type; limit of 500 characters
  • Numeric - Numbers including integers, decimals, floats, and other precise values
  • Integer - Positive whole numbers, negative whole numbers, or zero
  • Boolean - True/False values
  • Text - Text type; maximum character string that can be stored is 1 GB
  • FullAddress* - Full address of the location; This should be used when the location is in the form of a single-line address.
  • Street* - Street of the location
  • City* - City of the location
  • StateProvince* - State or Province of the location
  • PostalCode* - Zip/Postal Code of the location
  • County* - County of the location
  • Country* - Country of the location
  • Latitude* - Latitude of the location
  • Longitude* - Longitude of the location

Note: Address information is used to geocode the locations. However, if latitude and longitude column types are provided, no geocoding is done for the location.

* Restricted to only one instance of this column type per table.

Example Request

GET

http://www.mapquestapi.com/datamanager/v2/get-column-types?key=KEY

Example Response

{
  "types": [
    "Geography",
    "String",
    "Numeric",
    "Integer",
    "Boolean",
    "Text",
    "FullAddress",
    "Street",
    "City",
    "StateProvince",
    "PostalCode",
    "County",
    "Country",
    "Latitude",
    "Longitude"
  ],
  "info": {
    "statusCode": 0,
    "copyright": {
      "text": "© 2017 MapQuest, Inc.",
      "imageUrl": "http://api.mqcdn.com/res/mqlogo.gif",
      "imageAltText": "© 2017 MapQuest, Inc."
    },
    "messages": []
  }
}
<response>
    <info>
        <statusCode>0</statusCode>
        <messages/>
        <copyright>
            <imageUrl>http://api.mqcdn.com/res/mqlogo.gif</imageUrl>
            <imageAltText>© 2017 MapQuest, Inc.</imageAltText>
            <text>© 2017 MapQuest, Inc.</text>
        </copyright>
    </info>
    <types>
        <type>Geography</type>
        <type>String</type>
        <type>Numeric</type>
        <type>Integer</type>
        <type>Boolean</type>
        <type>Text</type>
        <type>FullAddress</type>
        <type>Street</type>
        <type>City</type>
        <type>StateProvince</type>
        <type>PostalCode</type>
        <type>County</type>
        <type>Country</type>
        <type>Latitude</type>
        <type>Longitude</type>
    </types>
</response>