How to reference a solution/ global parameter (many static parameters) in a Calculator step & send an email notification

If you require to reference a solution/ global parameter in a Calculator step, follow the below instructions:

Illustrated below is an example of a flow where a file is being retrieved from an SFTP Server source step and then being sent to an Amazon S3 Bucket destination step. From there, the file name and bucket name is being returned in the a Calculator step and a notification message is being sent via Email.

In the Calculator step after the Amazon S3 Bucket destination step, input.processedFileName is used to return the file name that was sent to the destination step (S3 Bucket) from the SFTP Server as shown in the below image.

image

To reference the S3 Bucket name in the notification message that is going to be sent via email, create a Parameter, select Text as an option and input the bucket name as shown in the below page. Copy the parameter ID by clicking on the copy icon highlighted in yellow and circled in red at the top right corner of the page.

Paste the parameter ID in the Load Parameters field by clicking on Add Item in the Calculator step as per the below image. Create a new field (eg. message) and type out the desired message you want to send via email. To reference the parameter in the created field, use ${loadedParameters[text in the parameter]} and click on the Save button.

NB: Please ensure that the syntax for the $loaded parameters that used in the Javascript Code section is inside backticks (``).

To reference the Email Notifications parameter in the Email destination step, follow the below instructions:

The below image is an example of the email notifications parameter with the required email addresses in a text format.

image

Open the Email destination step and click on the highlighted link icon to add the parameter as shown in the below images. Select the required parameter from the list and then click on the Use Path button.

image

image

In the Body of the Email destination step, you can reference the notification message as illustrated below.

image