Deleting Data

    Important Note:

    1. It is mandatory to use HTTPS in all API requests instead of HTTP request. HTTP is not supported.
    2. Always use https://<reports-hostname>:<port>/api/<reports-loginname>/<databasename>/<tablename> or<reportsname>
       as the API request URL.

    The data present in a table can be deleted using this API.


    A sample request that deletes the records of all the employees in finance department.


    Data Sent as POST parameters.


    • ZOHO_CRITERIA is encoded for the URL format. The values without encoding is given below:
      ZOHO_CRITERIA=("Department" = 'Finance')

    Specifying the action

    In the query string of the URL, the ZOHO_ACTION parameter should be "DELETE". For explanation about other mandatory query string parameters such as ZOHO_OUTPUT_FORMAT, refer this link.


    • Value of ZOHO_ACTION parameter should be in the same case(UPPER CASE) as given in this document.


    If the ZOHO_CRITERIA parameter is not sent, then all the rows are deleted. If criteria is sent then the rows matching the criteria alone are deleted. Please view this link for more details about the format for ZOHO_CRITERIA.

    Sample Success Response

    The following code snippets provides the response in XML and JSON formats for the sample refered above.


    <?xml version="1.0" encoding="UTF-8" ?>
    <response uri="/api/demouser/EmployeeDB/EmployeeDetails" action="DELETE">
    <criteria>&quot;Department&quot; = &apos;Finance&apos;</criteria>
    <message>Deleted rows</message>


    "uri": "/api/demouser/EmployeeDB/EmployeeDetails",
    "action": "DELETE",
    "criteria": "\"Department\" = \'Finance\'",
    "message": "Deleted rows",


    Copyright © 2016, ZOHO Corp. All Rights Reserved.