Email Body Parameters

Parameters	Description	Supported Destination	Supported Fields
{{bolt_link}}	A link of the created Bolt	Email, SMTP, Gmail, & Slack	Body
{{Columns}}	The column names of the table	Email, SMTP, Gmail & Slack	Body
{{creator.email}}	An email_id of the creator who create a Bolt will be sent to the recipients	Email, SMTP, Gmail, & Slack	To, Add CC& BCC Subject & Body
{{pipeline_meta.batch_size}}	The batch size of the pipeline	Email, SMTP, Gmail, & Slack	Subject & Body
{{pipeline_meta.batches_processed}}	Numbers of batches processed	Email, SMTP, Gmail, & Slack	Subject & Body
{{pipeline_meta.columns}}	The meta information of the columns	Email, SMTP, Gmail, & Slack	Subject & Body
{{pipeline_meta.rows_processed}}	Numbers of rows processed	Email, SMTP, Gmail, & Slack	Subject & Body
{{pipeline_name}}	The name of the pipeline	Email, SMTP, Gmail, & Slack	Subject & Body
{{pipeline_tag}}	The tags that you add while saving the Bolt	Email, SMTP, Gmail, & Slack	Subject & Body
{{query_parameters}}	Pass the parameters in the form of key and value pair	Email, SMTP, Gmail, & Slack	Subject & Body
{{result}}	The actual Bolt result will be sent to a recipient	Email, SMTP, Gmail, & Slack	Subject & Body
{{result_count}}	The actual result count will be sent to a recipient	Email, SMTP, Gmail, & Slack	Subject & Body
{{result_link}}	Download result link that can be further accessible in CSV and JSON format	Email, SMTP, Gmail, & Slack	Subject & Body
{{row}}	A specific row will be sent to a recipient	Emai, SMTP, Gmail	To,Add CC& BCC, Subject & Body

Note

Type {{result[0].NameofColumn}} to pass a particular column of data in the email fields. For REST API as source and REST Sink it is {{result.0.NameofColumn}}
To pass without space column name with row parameter use {{row.ColumnName}}
To pass without space column name with result parameter use {{result[0].ColumnName}}
To pass with space column name with row parameter use {{row['Column Name']}}
To pass with space column name with result parameter use {{result[0]['Column Name']}} }

We are always an email away to help you resolve your queries. If you need any help, write to us at - 📧 support@boltic.io