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.
File Types: | CSV | KML | Zipped SHP files |
---|
https://www.mapquestapi.com/datamanager/v2/upload-data
Response Formats | JSON, XML |
---|---|
Authentication | Yes (Requires Key) |
Rate Limited | Yes |
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
|
No |
outFormat String |
Specifies the format of the response. Must be one of the following, if supplied:
json
|
No |
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 The default value is |
No |
ambiguities String |
This parameter allows Data Manager to inform the user when it has encountered ambiguous geocoding results during the geocoding process. Example:
|
No |
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>
{
"tableName": "mqap.TABLENAME",
"append": "...",
"rowCount": "...",
"options": {
...
}
}
<datamanager>
<tableName>mqap.TABLENAME</tableName>
<append>...</append>
<rowCount>...</rowCount>
<options>
<option>
<shapeFormat>...</shapeFormat>
<ambiguities>...</ambiguities>
</option>
</options>
</datamanager>