Find in Zoho Sheet
Table of Contents
Description
The zoho.sheet.find task is used to find the specified text in a row, column, worksheet, or workbook of Zoho Sheet file. This task is based on the Zoho Sheet API - Find.
Syntax
<response> = zoho.sheet.find(<resource_id>, <scope>, <search_text>, <worksheet_name>, <row_index/column_index>, <connection>);
Params | Data type | Description |
<response> | KEY-VALUE | The status of the executed task, the number of rows matched, and their data. |
<resource_id> | TEXT | The ID of the Zoho Sheet file in which the search will be performed. Note: The resource_id can be obtained from the URL of the Zoho sheet file. The URL is in the following format: https://sheet.zoho.com/sheet/open/<resource_id>/sheets/<worksheet_name> |
<scope> | TEXT | The scope in which the search will be performed. Allowed values:
|
<search_text> | TEXT | The text that will be searched for. Note: The search performed by this task is not case-sensitive, i.e., this task finds the occurrences of the specified text regardless of its casing (uppercase/lowercase). |
<worksheet_name> | TEXT | The name of the worksheet in which the search will be performed. Note:
|
<row_index/column_index> | NUMBER | The index number of the row or the column in which the search will be performed.
|
<connection> | TEXT | The link name of the connection. Note:
|
URL format: https://sheet.zoho.com/sheet/open/<resource_id>/sheets/<worksheet_name>
/ranges/<cell_range>
Example 1: Find a piece of text in a workbook of Zoho Sheet file
The following script searches for the text - Shawn in the workbook of ID - eev4nXXXXXXXXXXXXXXXXXXXXXXXXXXXcff41:
response = zoho.sheet.find("eev4nXXXXXXXXXXXXXXXXXXXXXXXXXXXcff41", "workbook", "Shawn", "", 0, "sheet_connection");
where:
response
"eev4nXXXXXXXXXXXXXXXXXXXXXXXXXXXcff41"
"workbook"
"Shawn"
""
0
"sheet_connection
Example 2: Find a piece of text in the specified column of a workbook of Zoho Sheet file
The following script searches for the text - High in the column - E (index number: 5) of the Zoho Sheet file with ID - eev4nXXXXXXXXXXXXXXXXXXXXXXXXXXXcff41:
response = zoho.sheet.find("eev4nXXXXXXXXXXXXXXXXXXXXXXXXXXXcff41", "column", "High", "Sheet1", 5, "sheet_connection");
where:
"column"
"High"
"Sheet1"
5
"sheet_connection
Response Format
Success Response
The success response will be returned in the following format:
{
"cells": [
{
"row_index": 2,
"worksheet_id": "0#",
"column_index": 1,
"content": "Shawn",
"worksheet_name": "Sheet1"
},
{
"row_index": 2,
"worksheet_id": "0#",
"column_index": 2,
"content": "shawn@zylker.com",
"url": "mailto:shawn@zylker.com",
"worksheet_name": "Sheet1"
}
],
"method": "find",
"matches_found": 2,
"status": "success"
}
Failure Response
The failure response for invalid resource ID will be returned in the following format:
{
"error_message": "The workbook does not exists",
"error_code": 2862
}The failure response for incorrect or non-existent worksheet name will be returned in the following format:
{
"error_message": "The sheet does not exists",
"method": "find",
"error_code": 2863,
"status": "failure"
}The failure response for missing column index will be returned in the following format:
{
"error_message": "The parameter [column] required for processing this request is missing.",
"method": "find",
"error_code": 2831,
"status": "failure"
}The failure response for missing row index will be returned in the following format:
{
"error_message": "The parameter [row] required for processing this request is missing.",
"method": "find",
"error_code": 2831,
"status": "failure"
}The failure response for missing worksheet_name or worksheet_id will be returned in the following format:
{
"error_message": "The parameter [worksheet_name or worksheet_id] required for processing this request is missing.",
"method": "find",
"error_code": 2831,
"status": "failure"
}The failure response for null value in the search_text parameter will be returned in the following format:
{
"error_message": "The parameter [search] required for processing this request is missing.",
"method": "find",
"error_code": 2831,
"status": "failure"
}The failure response for null value in the search_text parameter will be returned in the following format:
{
"error_message": "The parameter [search] required for processing this request is missing.",
"method": "find",
"error_code": 2831,
"status": "failure"
}