Smartsheet Connector
Documentation
Version: 1
Documentation

EndPoint List Sheets


Name

get_sheets

Description

Get a list of Sheets. [API reference]

Parameters

Parameter Label Required Options Description
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
Include Include NO
Option Value
sheetVersion sheetVersion
source source
PageSize PageSize NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
Id DT_I8 bigint False
CreatedAt DT_DBTIMESTAMP datetime False
ModifiedAt DT_DBTIMESTAMP datetime False
CreatedAtLocalTime DT_DBTIMESTAMP datetime False
ModifiedAtLocalTime DT_DBTIMESTAMP datetime False
Name DT_WSTR nvarchar(255) 255 False
AccessLevel DT_WSTR nvarchar(50) 50 False
Permalink DT_WSTR nvarchar(2048) 2048 False

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.