Endpoint

Update Sheet Rows

Name

update_sheet_rows

Description

No description available

Related Tables

[Dynamic Table]

Parameters

Parameter

Label

Required

Options

Description

AllowPartialSuccess

Allow Partial Success (Default=False)

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)

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	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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`
RowNumber	`DT_I4`	`int`		`False`
BatchMessage	`DT_WSTR`	`nvarchar(4000)`	4000	`False`
BatchFailedItems	`DT_NTEXT`	`nvarchar(MAX)`		`False`
BatchResultCode	`DT_I4`	`int`		`False`
Version	`DT_I4`	`int`		`False`
HttpStatusCode	`DT_I4`	`int`		`False`
PrevRowId	`DT_I8`	`bigint`		`False`

If the column you are looking for is missing, consider customizing Smartsheet Connector.

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
[$parent.title$]	`DT_WSTR`	`nvarchar(2000)`	2000	`True`
==Checkbox Columns ===	`DT_BOOL`	`bit`		`True`
Id	`DT_I8`	`bigint`		`False`	Row ID

Required columns that you need to supply are bolded.

Examples

SSIS

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

Update rows in [Dynamic Table] table using API Destination

This Endpoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Smartsheet

[Dynamic Table]

Update

SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Update Sheet Rows

-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!

update_sheet_rows endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Update Sheet Rows

DECLARE @MyQuery NVARCHAR(MAX) = '-- We are out of SQL query examples for this Endpoint, sorry!
-- But will try to get some very very soon!';

EXEC (@MyQuery) AT [LS_TO_SMARTSHEET_IN_GATEWAY];

update_sheet_rows endpoint belongs to [Dynamic Table] table(s), and can therefore be used via those table(s).