Delete rows in Zoho Analytics

Note:

Each time the zoho.reports.deleteRow integration task is executed, it triggers an API request in the back-end. This call is deducted from the external calls limit available for the service from which the task is executed, based on your pricing plan.
Only actual executions that receive a response (whether success or failure) are counted, not the number of times the task appears in the script. For example, if zoho.reports.deleteRow integration task is placed inside a for each task that iterates five times, the number of external calls consumed will be five, even though the task appears only once in the script.

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.

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

Params

Data type

Description

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>

TEXT

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

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:

=	!=	<	>
<=	>=	LIKE	NOT LIKE
IN	NOT IN	BETWEEN (to be used as: "BETWEEN '<value1>' AND '<value2>'")

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

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

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

where,

Param	Explanation
mapResponse	variable 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

The following is a sample success response:

{
"message":"Deleted Rows"
}