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 are prefixed with mqap.CLIENT_ID_ Table names for new users are 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

JSON

{
    "clientId": "CLIENT_ID]",
    "password": "REGISTRY_PASSWORD",
    "tableName": "mqap.TABLENAME",
    "mqap_id": "MQAP_ID"
}

XML

<datamanager>
    <clientId>CLIENT_ID]</clientId>
    <password>REGISTRY_PASSWORD</password>
    <tableName>mqap.TABLENAME</tableName>
    <mqap_id>MQAP_ID</mqap_id>
</datamanager>

Example Response

JSON

{
    "tableName": "mqap.TABLENAME",
    "data": {
        "columns": [],
        "rows": []
    }
}

XML

<datamanager>
    <tableName>mqap.TABLENAME</tableName>
    <data>
        <columns>
            <column>...</column>
        </columns>
        <rows>
            <row>...</row>
        </rows>
    </data>
</datamanager>