Reading emails + saving in FTP

[bsartorelli]

Hello all!

I need some help and guidance with an automation I am trying to build.

Here is the request: read emails from mailbox x, get attachments, and save it in a FTP Folder.

I got a workflow that is doing part of it here in the community, I can run it and only with Binary Objects to Files I can save in a local folder. All good until we go to reality:

• on my real scenario, I can’t connect with ‘Email Connector’ using basic authentication (login/passw) bc is blocked by tenant of the company. They said I need to use modern oAuth to do it. Is it possible?
• second is FTP Connection, how can I use this connection into the Binary Objects to File? Is there any other option?
• third: some emails will have as attachment a zip file. In that case, I need to extract the file and then save it to the FTP Folder.

After a lot of research, I am wondering, is this even possible to do using KNIME?

Any tips or advice are welcome!

[k10shetty1]

Hi @bsartorelli,

I will try my best to answer your questions:

1. Instead of using your regular password, try creating and using an app password to connect to your Gmail account. You can find more details about this here.

2. Connect the top output port of the Binary Objects to Files node to the FTP Connector node, and then select the target folder within your FTP site where you want to save the files.

3. You can first save the ZIP file as-is, and then set up another flow to extract its contents. For this, connect to the FTP server using the Decompress Files and Delete Files/Folders nodes.
   

Hope this helps!
Example workflow for reference.

Best,
Keerthan