Choose where you’d like to start

Delete rows in Zoho Analytics

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"
}