Deleting Data
The data present in a table can be deleted using this API.
Sample
A sample request that deletes the records of all the employees in finance department.
URLhttp://reports.zoho.com/api/demouser/EmployeeDB/EmployeeDetails?
ZOHO_ACTION=DELETE&ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=hewfdrbgs&ticket=gsssds&ZOHO_API_VERSION =1.0
Data Sent as POST parameters.
&ZOHO_CRITERIA=(%22Department%22%3D'Finance')
Note: 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.
Note: Value of ZOHO_ACTION parameter should be in the same case(UPPER CASE) as given in this document.
Criteria
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
<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/api/demouser/EmployeeDB/EmployeeDetails" action="DELETE">
<criteria>"Department" = 'Finance'</criteria>
<result>
<message>Deleted rows</message>
</result>
</response>
JSON
{
"response":
{
"uri": "/api/demouser/EmployeeDB/EmployeeDetails",
"action": "DELETE",
"criteria": "\"Department\" = \'Finance\'",
"result":
{
message: "Deleted rows"
}
}
}
