SQL examples for SQL Server

The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with Smartsheet.

• Bulk create sheet rows using SQL Server data
• Bulk update sheet rows using SQL Server data
• Create a sheet row
• Delete sheet rows
• Export report
• Export sheet
• Read contacts
• Read groups
• Read reports
• Read sheet rows
• Read sheet rows by ID
• Read sheet rows by row number
• Read sheets
• Send report via email
• Send sheet via email
• Update a sheet row