SMB Connector + Send Email node

KNIME Analytics Platform
1

Hi All!

Need some guidance in this scenario I am trying to build.

I have this pretty simple workflow that is reading some table from snowflake, saving it into a share folder and sending and email with this file attached.

However, I need to schedule that in the hub.

In order to do that, I had to use the SMB connector to establish the connection with the share folder before saving the file.

The issue I am facing right now is, how to point SMB connector output into the ‘Send Email’ node?

If I just add the path there, it errors out bc server does not recognize the path. So I am trying to find a way to add the path created by SMB connector into the attachments path.

I am exposing path from CSV writer as variable, but it’s not showing up to me into the AttachmentURL variable port.

How can I solve this issue? Is it even possible?

image
image856×325 33 KB

2

Hi,

You can store the csv file in the local data area of the workflow. Then you do not need to connect a smb drive

Andreas

3

Hi Andreas,

But in that case how can I point that “area of workflow’ path into the attachments in Send Email node?

4

Yeah that’s a bit tricky.

  • With the “create File/Folder variables” I created the path variable to store the file in the “data-area” of the workflow

  • this variable should be then used in the send email node. But this nodes expects a “string array type” variable. That’s why I needed to do some extra steps

image
image1758×486 96.9 KB

Here’s the workflow in my Hub instance: