SMB Connector + Send Email node

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?