EndPoint Send Sheet via Email (EXCEL, PDF, or PDF_GANTT format)
Name
send_sheet_email
Description
Sends the sheet as a Excel / PDF attachment via email to the designated recipients. [API reference]
Parameters
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Version |
DT_I4
|
int
|
False |
||
| ResultCode |
DT_I4
|
int
|
False |
||
| Message |
DT_WSTR
|
nvarchar(1000)
|
1000 | False |
|
| failedItems |
DT_WSTR
|
nvarchar(4000)
|
4000 | False |
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Examples
SSIS
Use Smartsheet Connector in API Source component to read data or in API Destination component to read/write data:
Send Sheet via Email (EXCEL, PDF, or PDF_GANTT format) using API Source
Smartsheet
Send Sheet via Email (EXCEL, PDF, or PDF_GANTT format)
Send Sheet via Email (EXCEL, PDF, or PDF_GANTT format) using API Destination
Smartsheet
Send Sheet via Email (EXCEL, PDF, or PDF_GANTT format)
ODBC application
Use these SQL queries in your ODBC application data source:
Send Sheet via Email to Users or Groups (as PDF, Excel)
This example shows how to send Sheet via Email (PDF or Excel format) to list of emails or groups.
SELECT * FROM send_sheet_email
WITH(
SheetId='1592926391979908'
, Subject='Test report'
, Message='This email contains report attachment'
, CcMe='true'
, PaperSize='LETTER'
, SendToEmails='bob@mycompany.com~sam@mycompany.com'
--OR (Emails or Group only - one allowed)
--, SendToGroups='10022222001~10333330002'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Send Sheet via Email to Users or Groups (as PDF, Excel)
This example shows how to send Sheet via Email (PDF or Excel format) to list of emails or groups.
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM send_sheet_email
WITH(
SheetId=''1592926391979908''
, Subject=''Test report''
, Message=''This email contains report attachment''
, CcMe=''true''
, PaperSize=''LETTER''
, SendToEmails=''bob@mycompany.com~sam@mycompany.com''
--OR (Emails or Group only - one allowed)
--, SendToGroups=''10022222001~10333330002''
)';
EXEC (@MyQuery) AT [LS_TO_SMARTSHEET_IN_GATEWAY];