SearchSheet
Searches a specific sheet for rows matching the specified text.
Stored Procedure-Specific Information
To execute this procedure, enter:EXEC SearchSheet SheetId='632130486200196', Query='search text'
Input
| Name | Type | Required | Description |
| SheetId | String | True | The unique identifier of the sheet to search within. |
| Query | String | True | The text to search for within the sheet. Newly created or recently updated data may not be immediately discoverable via search. |
Result Set Columns
| Name | Type | Description |
| Text | String | The text snippet matching the search query. |
| ObjectType | String | The type of the matching object. Possible values are 'row', 'discussion', 'attachment', and 'summaryField'. |
| ObjectId | String | The unique identifier of the matching object. |
| ParentObjectType | String | The type of the parent object of the matching object. |
| ParentObjectId | String | The unique identifier of the parent object of the matching object. |
| ContextData | String | Additional context about the match. |