Data Manager API

POST
Edit Column Names

This request allows the user to edit the column names of their Data Manager table.

Resource URL

https://www.mapquestapi.com/datamanager/v2/edit-column-names

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		 This is the complete name of the table.
Table names for legacy users must be prefixed with mqap.[CLIENT_ID]_
Table names for new users must be prefixed with mqap.[APPLICATION_KEY]_ 		Yes
columnNames
String[]		 An array of columns whose names you wish to update. Yes

Example Request

POST

https://www.mapquestapi.com/datamanager/v2/edit-column-names?key=KEY&inFormat=json

Example Request Body

{
    "clientId": "CLIENT_ID",
    "password": "REGISTRY_PASSWORD",
    "tableName": "mqap.TABLENAME",
    "columnNames": [
        {
            "name": "NAME",
            "newName": "NAME"
        },
        ...
    ]
}
<datamanager>
    <clientId>CLIENT_ID</clientId>
    <password>REGISTRY_PASSWORD</password>
    <tableName>TABLENAME</tableName>
    <columnNames>
        <columnName>
            <name>NAME</name>
            <newName>NAME</newName>
        </columnName>
        ...
    </columnNames>
</datamanager>

Example Response

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