Skip to content

Data Manager API

POST Add Columns

This request adds columns to the specified Data Manager table.

Resource URL

https://www.mapquestapi.com/datamanager/v2/add-columns

Resource Information

Response FormatsJSON, XML
AuthenticationYes (Requires Key)
Rate LimitedYes

Request Parameters

Request ParameterDescriptionRequired
key
String
A unique key to authorize use of the API.Yes
inFormat
String
Specifies the format of the json/xml parameter. Must be one of the following, if supplied:
  • json
  • xml
Default = json
No
outFormat
String
Specifies the format of the response. Must be one of the following, if supplied:
  • json
  • xml
Default = json
No

Body Parameters

NameDescriptionRequired
clientId
String
This is the ClientID associated with the API Key.Yes
password
String
This is the registry password associated with the API Key.Yes
tableName
String
The name of the tableYes
name
String
The name of the columnYes
type
String
The type of the column. See get-column-types function to see a list of supported column typesYes
isPublic
Boolean
This parameter will return names and column information for tables that have been made public.
The default value is false.
No

Example Request

POST https://www.mapquestapi.com/datamanager/v2/add-columns?key=KEY&inFormat=json&outFormat=json

Example Request Body

JSON
{
    "clientId": "CLIENT_ID",
    "password": "REGISTRY_PASSWORD",
    "tableName": "mqap.TABLENAME",
    "columns": [
        {
            "name": "NAME",
            "type": "TYPE",
            "isPublic": true
        },
        {
           ...
        }
    ]
}
XML
<datamanager>
    <clientId>CLIENT_ID</clientId>
    <password>REGISTRY_PASSWORD</password>
    <tableName>TABLENAME</tableName>
    <columns>
        <column>
            <name>NAME</name>
            <type>TYPE</type>
            <isPublic>true</isPublic>
        </column>
        ...
    </columns>
</datamanager>

Example Response

JSON
{
    "tableName": "mqap.[TABLENAME]",
    "columns": [
        {
            "name": "...",
            "type": "...",
            "isPublic": "..."
        }
    ]
}
XML
<tableName>mqap.TABLENAME</tableName>
<columns>
    <column>
        <name>...</name>
        <type>...</type>
        <isPublic>...</isPublic>
    </column>
</columns>