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

{
    "clientId": "CLIENT_ID",
    "password": "REGISTRY_PASSWORD",
    "originTableName": "mqap.TABLENAME",
    "resultsTableName": "mqap.TABLENAME",
    "overwriteTable": false
}

<datamanager>
    <clientId>CLIENT_ID</clientId>
    <password>REGISTRY_PASSWORD</password>
    <originTableName>mqap.TABLENAME</originTableName>
    <resultsTableName>mqap.TABLENAME</resultsTableName>
    <overwriteTable>false</overwriteTable>
</datamanager>

Example Response

JSON
XML

{
    "resultsTableName": "mqap.TABLENAME",
    "originTableName": "mqap.TABLENAME",
    "options": {
        "overwriteTable": "..."
    }
}

<resultsTableName>mqap.TABLENAME</resultsTableName>
<originTableName>mqap.TABLENAME</originTableName>
<options>
    <overwriteTable>...</overwriteTable>
</options>