# Search sheet

Gets a list of the user's search results in a sheet, based on a query.

The list contains an abbreviated row object for each query-matching row in the sheet. 

> Important: If you have't 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: Newly created or recently updated data may not be immediately discoverable
via search.

Endpoint: GET /search/sheets/{sheetId}
Version: 2.0.0
Security: APIToken, OAuth2

## Path parameters:

  - `sheetId` (number, required)
    ID of the sheet being accessed.

## Header parameters:

  - `Authorization` (string)
    API Access Token used to authenticate requests to Smartsheet APIs.

  - `smartsheet-integration-source` (string)
    Uses the following metadata to distinguish between human-initiated API requests and third-party service-initiated calls by AI Connectors or ITSM:

- Integration source type
- Organization name
- Integration source name 

Format:


TYPE,OrgName,SourceName


Examples: 

AI,SampleOrg,My-AI-Connector-v2

SCRIPT,SampleOrg2,Accounting-updater-script

APPLICATION,SampleOrg3,SheetUpdater
    Example: "AI,SampleOrg,My-AI-Connector-v2"

## Query parameters:

  - `query` (string, required)
    Text with which to perform the search.

Tip: To match the exact text, wrap the query in double-quotes.

## Response 200 fields (application/json):

  - `results` (array)
    Array of matching items.

  - `totalCount` (number)
    Total number of search results in the results array.
    Example: 1

## Response default fields (application/json):

  - `refId` (string)
    The ID of the specific error occurrence. Please include this information when contacting Smartsheet support.

  - `errorCode` (number)
    Custom error code from Smartsheet. See the complete [Error Code List](/api/smartsheet/error-codes).

  - `message` (string)
    Descriptive error message.