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

Name	Description	Required?
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 table	Yes
name String	The name of the column	Yes
type String	The type of the column. See get-column-types function to see a list of supported column types	Yes
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

{
    "clientId": "CLIENT_ID",
    "password": "REGISTRY_PASSWORD",
    "tableName": "mqap.TABLENAME",
    "columns": [
        {
            "name": "NAME",
            "type": "TYPE",
            "isPublic": true
        },
        {
           ...
        }
    ]
}

<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
XML

{
    "tableName": "mqap.[TABLENAME]",
    "columns": [
        {
            "name": "...",
            "type": "...",
            "isPublic": "..."
        }
    ]
}

<tableName>mqap.TABLENAME</tableName>
<columns>
    <column>
        <name>...</name>
        <type>...</type>
        <isPublic>...</isPublic>
    </column>
</columns>