How to get multiple files from the SFTP server

Manjunath_Mali1 · February 5, 2015, 5:00pm

Hi,

One of my Flow logics required to extract multiple files from the SFTP server. But we have only SFTP get built in service. Kindly help me how to mget the files from the SFTP server.

Thanks in advance, Manjunath

Mahesh_K_Sreenivas · February 5, 2015, 5:52pm

Unfortunately you do not have built in service for mput and mget in sftp. But you have the same in ftp.

For your requirement you can do something below;

1> get the list of the file names from the sftp directory (output will be stringList)
2> Use a loop and call the pub.client.sftp:get

Or if you are java expert you may write a java code using JSCH API (eg: jsch-0.1.37)

I hope SAG adds the mget and mput services for SFTP just like FTP in the next release.

Mahesh_K_Sreenivas · February 6, 2015, 9:02am

Or Try using OpenSSH package available in code samples on SAG tech community.

Manjunath_Mali1 · February 16, 2015, 2:53pm

Hi Mahesh,

Thanks for your reply !!.

We can use the existing pub.client.sftp:get service for both get as well as mget function .

Mahesh_K_Sreenivas · February 16, 2015, 3:09pm

How did you achieve it? Can you share the pseudo code?

Manjunath_Mali1 · February 16, 2015, 3:25pm

Input Parameters::

sessionKey : Session Key of the SFTP server.
remoteFile : * ( All files of the current directory )
localFile : Archive location

Mahesh_K_Sreenivas · February 16, 2015, 5:18pm

Yep! your input parameters make sense Thanks for your update.