> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Search Sheets

Searches all sheets that the user can access, for the specified text. If you have not used the public API in a while, we will need to provision your data. This could take up to 24 hours so please check back later!

<Note>
  External Documentation

  To learn more, visit the [Smartsheet documentation](https://smartsheet.redoc.ly/tag/search#operation/list-search).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter      | Description                                                                                                                                                                                                                             |
  | -------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Modified Since | When specified with a date and time value, response only includes the objects that are modified on or after the date and time specified. If you need to keep track of frequent changes, it may be more useful to use Get Sheet Version. |
  | Query          | Text with which to perform the search. Enclose in double-quotes for an exact search.                                                                                                                                                    |
</div>

## Advanced Parameters

<div className="integrations-table">
  | Parameter | Description                                                                                                                                                                                                                                                                                                                                              |
  | --------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Include   | When specified with a value of **favoriteFlag**, response indicates which returned items are favorites.  favorite -- dashboards, folders, reports, sheets, templates, and workspaces will have the property favorite: true parentObjectFavorite -- attachments, discussions, summary fields, and rows will have the property parentObjectFavorite: true. |
  | Location  | When specified with a value of **personalWorkspace**, limits the response to only those items in the user's workspaces.                                                                                                                                                                                                                                  |
  | Scopes    | If search fails, try using an array for each type of this comma-separated list of search filters.                                                                                                                                                                                                                                                        |
</div>

## Example Output

```json theme={"dark"}
{
	"results": [
		{
			"text": "<string>",
			"objectType": "<string>",
			"objectId": 2839089213461133,
			"contextData": [
				"<string>"
			]
		}
	],
	"totalCount": 1
}
```

## Workflow Library Example

[Search Sheets with Smartsheet and Send Results Via Email](https://library.blinkops.com/workflows/search-sheets-with-smartsheet-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/search-sheets-with-smartsheet-and-send-results-via-email/canvas" />
</div>
