Data Manager API

POST
Delete Data

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.

Resource URL

https://www.mapquestapi.com/datamanager/v2/delete-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
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)

Example Request

POST

https://www.mapquestapi.com/datamanager/v2/delete-data?key=KEY&inFormat=json

Example Request Body

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

Example Response

{
    "tableName": "mqap.TABLENAME",
    "data": {
        "columns": [],
        "rows": []
    }
}
<datamanager>
    <tableName>mqap.TABLENAME</tableName>
    <data>
        <columns>
            <column>...</column>
        </columns>
        <rows>
            <row>...</row>
        </rows>
    </data>
</datamanager>