Data Manager API

GET Get Column Types

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

Resource URL

https://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 https://www.mapquestapi.com/datamanager/v2/get-column-types?key=KEY

Example Response

JSON

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

XML

<response>
    <info>
        <statusCode>0</statusCode>
        <messages/>
        <copyright>
            <imageUrl>https://api.mqcdn.com/res/mqlogo.gif</imageUrl>
            <imageAltText>© 2023 MapQuest, Inc.</imageAltText>
            <text>© 2023 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>