Skip to content

Data Manager API

POST Copy Table

This request copies the contents of one Data Manager table to another.

Resource URL

https://www.mapquestapi.com/datamanager/v2/copy-table

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
originTableName
String
This is the complete name of the table to copy FROM.

Table names for legacy users are prefixed with mqap.[CLIENT_ID]_

Table names for new users are prefixed with mqap.[APPLICATION_KEY]_
Yes
resultsTableName
String
This is the complete name of the table to copy TO. A new table will be created if this table does not yet exist in Data Manager.

Example: mqap.[CLIENT_ID]_[TABLENAME]
Yes
overwriteTable
Boolean
Set the overwriteTable parameter to true to overwrite an existing Data Manager table with contents from the origin table. The default value is false.No

Example Request

POST https://www.mapquestapi.com/datamanager/v2/copy-table?key=KEY&inFormat=json

Example Request Body

JSON
{
    "clientId": "CLIENT_ID",
    "password": "REGISTRY_PASSWORD",
    "originTableName": "mqap.TABLENAME",
    "resultsTableName": "mqap.TABLENAME",
    "overwriteTable": false
}
XML
<datamanager>
    <clientId>CLIENT_ID</clientId>
    <password>REGISTRY_PASSWORD</password>
    <originTableName>mqap.TABLENAME</originTableName>
    <resultsTableName>mqap.TABLENAME</resultsTableName>
    <overwriteTable>false</overwriteTable>
</datamanager>

Example Response

JSON
{
    "resultsTableName": "mqap.TABLENAME",
    "originTableName": "mqap.TABLENAME",
    "options": {
        "overwriteTable": "..."
    }
}
XML
<resultsTableName>mqap.TABLENAME</resultsTableName>
<originTableName>mqap.TABLENAME</originTableName>
<options>
    <overwriteTable>...</overwriteTable>
</options>