Analytics-Plus Help

Updating 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> as the API request URL.

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


A sample request that updates the salary to 10000 and perks to 6000 and deduction to Empty (no value) for all employees of the finance department.

&ZOHO_API_KEY=hewfdrbgs&ticket=gsssds&ZOHO_API_VERSION =1.0

Data Sent as POST parameters.


Note :

  • ZOHO_CRITERIA is encoded in URL encoding format. Value 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 "UPDATE". 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.

Specifying the data to be updated

Pass the columns whose values you would like to update in a <columnname>=<value> format. (The parameters should be in application/x-www-form-urlencoded format).

<columnname> - Refers to the name of the column in the table whose value is to be updated
<value> - Refers to the corresponding value to be updated in the column

For specifying empty (null) values, the parameter should be sent with empty values. In the example above, the Deduction value is taken to be empty.


If the ZOHO_CRITERIA parameter is not sent, then all the rows are updated. If criteria is sent the rows matching the criteria alone are updated.

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="UPDATE">
<criteria>&quot;Department&quot; = &apos;Finance&apos;</criteria>



"uri": "/api/demouser/EmployeeDB/EmployeeDetails",
"action": "UPDATE",
"criteria": "\"Department\" = 'Finance'",

Share this post : FacebookTwitter