Skip to content

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:CSVKMLZipped SHP files

Resource URL

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

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