Data Manager API

POST Upload Data

This request uses the upload-data command to append one or more records to a table. Data is passed in through the rows[] array.

Uploads are limited to 10MB for developers on non-Enterprise plans and 100MB for developers who have an Enterprise Edition license.

Files must contain a header and fields must match those specified when the table was created.

Supported file types for upload

File Types:

CSV

KML

Zipped SHP files

Resource URL

https://www.mapquestapi.com/datamanager/v2/upload-data

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 are prefixed with mqap.CLIENT_ID_ Table names for new users are prefixed with mqap.APPLICATION_KEY_	Yes
append Boolean	Append must be set to true to add rows to the table. Otherwise, table data will be overwritten if append is set to false.	Yes
rows String[]	An array of rows to add to the table.	Yes
returnResults Boolean	Returns a list of failures along with a description of why they failed in the event a failure occurs during an upload; either true or false. The default value is false.	No
ambiguities String	This parameter allows Data Manager to inform the user when it has encountered ambiguous geocoding results during the geocoding process. Example: ambiguities = check, The default value is check. ambiguities = ignore, Data Manager will ignore geocoding ambiguities.	No

Example Request

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

Example Request Body

JSON

{
    "clientId": "CLIENT_ID",
    "password": "REGISTRY_PASSWORD",
    "tableName": "mqap.TABLENAME",
    "append": true,
    "rows": [
        [
            {
                "name": "NAME",
                "value": "VALUE"
            },
            ...
        ],
        ...
    ]
}

XML

<datamanager>
    <clientId>CLIENT_ID</clientId>
    <password>REGISTRY_PASSWORD</password>
    <tableName>TABLENAME</tableName>
    <append>APPEND</append>
    <rows>
        <row>
            <field>
                <name>NAME</name>
                <value>VALUE</value>
            </field>
            ...
        </row>
    </rows>
</datamanager>

Example Response

JSON

{
    "tableName": "mqap.TABLENAME",
    "append": "...",
    "rowCount": "...",
    "options": {
        ...
    }
}

XML

<datamanager>
    <tableName>mqap.TABLENAME</tableName>
    <append>...</append>
    <rowCount>...</rowCount>
    <options>
        <option>
            <shapeFormat>...</shapeFormat>
            <ambiguities>...</ambiguities>
        </option>
    </options>
</datamanager>