Smartsheet Connector
Documentation
Version: 2
Documentation
Home » API Integration Hub » Smartsheet Connector » EndPoints » Search (cell data or other object types)

EndPoint Search (cell data or other object types)

Name

search

Description

Get a list of search result object. [API reference]

Parameters

Parameter Label Required Options Description
Query Search Query (use double quotes for exact search) YES
SheetId SheetId NO
Scope Scope NO
Option Value
cellData cellData
attachments attachments
comments comments
folderNames folderNames
reportNames reportNames
sheetNames sheetNames
sightNames sightNames
summaryFields summaryFields
templateNames templateNames
workspaceNames workspaceNames
ModifiedSince Modified Since NO
Option Value
2020-01-30T13:25:32 2020-01-30T13:25:32
2020-01-30 2020-01-30
now now
today today
yesterday yesterday
monthstart monthstart
monthend monthend
yearstart yearstart
yearend yearend
weekstart weekstart
weekend weekend
yearstart-1y yearstart-1y
yearend-1y yearend-1y
monthstart-1d monthstart-1d
monthend+1d monthend+1d
today-24h today-24h
now-24h now-24h
now-1d now-1d
today+7d today+7d
PageSize PageSize NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Smartsheet Connector in API Source component to read data or in API Destination component to read/write data:

Search (cell data or other object types) using API Source

Smartsheet
Search (cell data or other object types)
SSIS API Source - Read from table or endpoint

Search (cell data or other object types) using API Destination

Smartsheet
Search (cell data or other object types)
SSIS API Destination - Access table or endpoint