Reading emails + saving in FTP

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!