Smartsheet Connector
Documentation
Version: 1
Documentation

EndPoint Add Sheet Rows


Name

add_sheet_rows

Description

Add rows to a Sheet.

Parameters

Parameter Label Required Options Description
RowLocation Add Row at Specific Location (Default=toBottom) NO
Option Value
"toBottom": true "toBottom": true
"toTop": true "toTop": true
"parentId": 1231234567 "parentId": 1231234567
"siblingId": 1231234567 "siblingId": 1231234567
AllowPartialSuccess Allow Partial Success (Default=False) NO
Option Value
false false
true true
When specified with a value of true, enables partial success for this bulk operation. See Partial Success for more information.
OverrideValidation Override Validation (Default=False) NO
Option Value
false false
true true
You may use the query string parameter overrideValidation with a value of true to allow a cell value outside of the validation limits. You must specify strict with a value of false to bypass value type checking.

Output Columns

Label DataType Length Raw Description
Id DT_I8 0 False
CreatedAt DT_DBTIMESTAMP 0 False
ModifiedAt DT_DBTIMESTAMP 0 False
CreatedAtLocalTime DT_DBTIMESTAMP 0 False
ModifiedAtLocalTime DT_DBTIMESTAMP 0 False
RowNumber DT_I4 0 False
BatchMessage DT_WSTR 4000 False
BatchFailedItems DT_NTEXT 0 False
BatchResultCode DT_I4 0 False
Version DT_I4 0 False
HttpStatusCode DT_I4 0 False
PrevRowId DT_I8 0 False

Input Columns

Label DataType Length Raw Description
[$parent.title$] DT_WSTR 2000 True
==Checkbox Columns === DT_BOOL 0 True