Choose where you’d like to start

Delete rows in Zoho Analytics

Overview

This task is used to delete rows in a table in Zoho Analytics. The rows are deleted based on the given criteria.

This integration task is based on the Zoho Analytics API - Delete Row.

Syntax

<variable> = zoho.reports.deleteRow(<database_name>, <table_name>, <criteria>, <connection>);
Params Data typeDescription

<variable> 

KEY-VALUE

is the variable that will hold the response returned by Zoho Analytics.

<database_name> 

TEXT

is the name of the database in which the table rows will be deleted. 

<table_name>TEXTis the name of the table in which rows will be deleted.

<criteria>

TEXT

Criteria based on which rows will be deleted.

The criteria must be in the format: "<column_name> <operator> '<value>'"

Following is the list of supported operators:

=!=<>
<=>=LIKENOT LIKE
INNOT IN

BETWEEN (to be used as: "BETWEEN '<value1>' AND '<value2>'")

<connection>

TEXT

specifies the name of the Zoho Analytics connection.

Note:

  • In view of stopping new authtoken generation, a Zoho OAuth connection with appropriate scopes is mandatory for new integration tasks (created after the deadline specified in the post) to work as expected. Existing integration tasks will continue to work with or without the connections parameter unless the authtoken is manually deleted from accounts.
  • Add relevant scopes mentioned in Zoho Analytics API document while creating the connection.
  • Refer to this post for the list of Zoho services that support the connections page.
  • Learn more about connections

Example: Delete rows in Zoho Analytics

The following sample snippet deletes rows that meet the specified criteria.

mapResponse = zoho.reports.deleteRow("Website", "Search Analytics", "name='John'", "analytics_connection" );

where,

ParamExplanation
mapResponsevariable that holds the returned response.
"Website"is the Database name in Zoho Analytics
"Search Analytics"is the table name in Zoho Analytics
"name"is a column name in Zoho Analytics
=refers to the operator.
'John'

is the required column value.

All "name" columns having John as the value will be deleted.

"analytics_connection"is the connection link name

Sample Response

The following is a sample success response:

{  
   "message":"Deleted Rows"
}​​

Related Links

Get Started Now

Execute