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 must be prefixed with `mqap.[CLIENT_ID]_` Table names for new users must be 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

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

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

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

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