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 and write Smartsheet data effortlessly. Integrate, manage, and automate sheets, rows, and reports — almost no coding required.

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 sheet row

<p>Creates a new row in a sheet. You can specify values for various column types such as Text/Number, Checkbox, Contact List, Date, Picklist, and Symbol.</p>

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 create sheet rows using SQL Server data

<p>Bulk creates rows in a sheet by reading data from an external SQL Server database using the <code>SOURCE</code> clause. Column names must match the target sheet's column names.</p>

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 sheet row

<p>Creates a new row in a sheet. You can specify values for various column types such as Text/Number, Checkbox, Contact List, Date, Picklist, and Symbol.</p>

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 create sheet rows using SQL Server data

<p>Bulk creates rows in a sheet by reading data from an external SQL Server database using the <code>SOURCE</code> clause. Column names must match the target sheet's column names.</p>

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];