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

Example Request Body

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

{
    "tableName": "mqap.TABLENAME",
    "append": "...",
    "rowCount": "...",
    "options": {
        ...
    }
}
<datamanager>
    <tableName>mqap.TABLENAME</tableName>
    <append>...</append>
    <rowCount>...</rowCount>
    <options>
        <option>
            <shapeFormat>...</shapeFormat>
            <ambiguities>...</ambiguities>
        </option>
    </options>
</datamanager>