Endpoint Add Sheet Rows

Name

add_sheet_rows

Description

Add rows to a Sheet.

Related Tables

[Dynamic Table]

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Smartsheet Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Destination

This Endpoint belongs to the [Dynamic Table] table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to add sheet rows:

API Destination - Smartsheet

Read / write SmartSheet data inside your app, perform many SmartSheet operations such as Read, Insert, Update, Delete, List, Search, Export on objects like Sheets, Rows, Users etc without coding with easy to use high performance API Connector

Smartsheet

[Dynamic Table]

Insert

Optional Parameters
Add Row at Specific Location (Default=toBottom)	"toBottom": true
Allow Partial Success (Default=False)
Override Validation (Default=False)

ODBC application

Use these SQL queries in your ODBC application data source:

Create a new sheet row

This example shows how to create a new Sheet Row by calling INSERT statement. Optionally specify location where you like to insert new row (default is at bottom).

INSERT INTO [My Sheet]
  ( [Some Text Number Column], [Some Checkbox Column], [Some Contact List Column], [Some Date Column], [Some PickList Column], [Some Multi PickList Column], [Some Symbol Column] )
VALUES 
  ('Updated at <<FUN_NOW>>', true, 'something@abc.com', '2024-12-31','Not Started','Value2,Value4','Green,Yellow')
/*
WITH(
RowLocation='"toTop": true'  --insert at the top
--OR--
--RowLocation='"siblingId": 1231234567'  --insert after some sibling row id
)			
*/

Bulk INSERT to SmartSheet from External System (e.g. ODBC Source / Microsoft SQL Server / OLEDB)

This example shows how to bulk insert into SmartSheet from any system such as Microsoft SQL Server or ODBC Source or OLEDB Source. Column names must match with Target Sheet column names in SQL Column alias.

INSERT INTO [My Sheet]
SOURCE(   'MSSQL'--OR 'ODBC'--OR 'OLEDB'
        , 'Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true'
		--OR for ODBC
		--,'DSN=MyOdbcDsn'
		--OR (DSN less connection)
		--,'Driver={Some ODBC Driver};uid=xxx;pwd=xxx;prop1=xxx;prop2=xxx....'
        , 'SELECT ''2012-12-31'' [Some Date Column],''true'' [Some CheckBox Column],''Good example'' [Some Text Column]
           UNION 
		   SELECT ''2012-13-31'' [Some Date Column],''false'' [Some CheckBox Column],''Bad date example'' [Some Text Column]
           UNION 
		   SELECT ''2012-10-01'' [Some Date Column],''true'' [Some CheckBox Column],''Good example'' [Some Text Column]
        ')
--WITH(AllowPartialSuccess='true',output=1)

SQL Server

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

Create a new sheet row

This example shows how to create a new Sheet Row by calling INSERT statement. Optionally specify location where you like to insert new row (default is at bottom).

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO [My Sheet]
  ( [Some Text Number Column], [Some Checkbox Column], [Some Contact List Column], [Some Date Column], [Some PickList Column], [Some Multi PickList Column], [Some Symbol Column] )
VALUES 
  (''Updated at <<FUN_NOW>>'', true, ''something@abc.com'', ''2024-12-31'',''Not Started'',''Value2,Value4'',''Green,Yellow'')
/*
WITH(
RowLocation=''"toTop": true''  --insert at the top
--OR--
--RowLocation=''"siblingId": 1231234567''  --insert after some sibling row id
)			
*/';

EXEC (@MyQuery) AT [LS_TO_SMARTSHEET_IN_GATEWAY];

Bulk INSERT to SmartSheet from External System (e.g. ODBC Source / Microsoft SQL Server / OLEDB)

This example shows how to bulk insert into SmartSheet from any system such as Microsoft SQL Server or ODBC Source or OLEDB Source. Column names must match with Target Sheet column names in SQL Column alias.

DECLARE @MyQuery NVARCHAR(MAX) = 'INSERT INTO [My Sheet]
SOURCE(   ''MSSQL''--OR ''ODBC''--OR ''OLEDB''
        , ''Data Source=localhost;Initial Catalog=tempdb;Integrated Security=true''
		--OR for ODBC
		--,''DSN=MyOdbcDsn''
		--OR (DSN less connection)
		--,''Driver={Some ODBC Driver};uid=xxx;pwd=xxx;prop1=xxx;prop2=xxx....''
        , ''SELECT ''''2012-12-31'''' [Some Date Column],''''true'''' [Some CheckBox Column],''''Good example'''' [Some Text Column]
           UNION 
		   SELECT ''''2012-13-31'''' [Some Date Column],''''false'''' [Some CheckBox Column],''''Bad date example'''' [Some Text Column]
           UNION 
		   SELECT ''''2012-10-01'''' [Some Date Column],''''true'''' [Some CheckBox Column],''''Good example'''' [Some Text Column]
        '')
--WITH(AllowPartialSuccess=''true'',output=1)';

EXEC (@MyQuery) AT [LS_TO_SMARTSHEET_IN_GATEWAY];