This request deletes a record (or multiple records) from a table. If the mqap_id is supplied,a single record will be deleted from the table. If the mqap_ids parameter is supplied, all records on the provided list will be deleted.
https://www.mapquestapi.com/datamanager/v2/delete-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 |
mqap_id String |
This is the ID of the record to delete. Example: ffde43e8-77b4-40f8-a61a-cf99e1cb242f | Yes (if mqap_ids is not provided) |
mqap_ids String[] |
This is a list of IDs to delete. Example: ffde43e8-77b4-40f8-a61a-cf99e1cb242f | Yes (if mqap_id is not provided) |
POST
https://www.mapquestapi.com/datamanager/v2/delete-data?key=KEY&inFormat=json
{
"clientId": "CLIENT_ID]",
"password": "REGISTRY_PASSWORD",
"tableName": "mqap.TABLENAME",
"mqap_id": "MQAP_ID"
}
<datamanager>
<clientId>CLIENT_ID]</clientId>
<password>REGISTRY_PASSWORD</password>
<tableName>mqap.TABLENAME</tableName>
<mqap_id>MQAP_ID</mqap_id>
</datamanager>
{
"tableName": "mqap.TABLENAME",
"data": {
"columns": [],
"rows": []
}
}
<datamanager>
<tableName>mqap.TABLENAME</tableName>
<data>
<columns>
<column>...</column>
</columns>
<rows>
<row>...</row>
</rows>
</data>
</datamanager>