Is there a way to SFTP a file in a mapping function?

Question

Is it possible to send a file via SFTP in a mapping function?

Answer 1

In .44 we have added qie functions to handle this:

qie.countSFTPEndpoint('host', port, 'path', binary, passive, 'ftpParameters', 'userName', 'password');
qie.readSFTPFile('host', port, 'path', deleteFile, 'archivePath', binary, passive, 'ftpParameters', 'userName', 'password', timeout);
qie.writeSFTPFile('host', port, 'path', binary, passive, 'ftpParameters', 'userName', 'password', data);
qie.listSFTPEndpoint('host', port, 'path', binary, passive, 'ftpParameters', 'userName', 'password');

Answer 2

To SFTP a file in a mapping node, you can use the following code:

 

importPackage(com.jcraft.jsch);

 

var ssh = new com.jcraft.jsch.JSch();

var session = ssh.getSession("{user}", "{host}", 22);

session.setConfig("StrictHostKeyChecking", "no");

session.setPassword("{password}");

session.connect();

var channel = session.openChannel("sftp");

channel.connect();

channel.put("{source_file}", "{destination_file}");

// channel.rm("{remote_file}"); // removes the file

channel.exit();

session.disconnect();