E1 Orchestrator SFTP Enhancement - Directory Listing, and Groovy Workaround

Hi all,

FYI I have created an Enhancement Request 32880612 for the E1 Orchestrator SFTP connector: It has Get and Put requests but no way to list a directory to get the filenames. A typical design would look in a SFTP folder for any files and then get and process them. If you don't know the filename, you cannot get them with the current SFTP Connector.

That request is being considered by Oracle.

In the meantime, it should be possible to write a custom Groovy or Java connector, using an SFTP class such as Apache Commons SFTP client, to get a directory listing. Has anyone tried this yet? I would try, but it requires installing the SFTP client jar on the AIS server and don't currently have the access our resource to do this...

Cheers
JohnO

You can use the internal Business Functions to retrieve a directory listing, by adding the BSFN as a step in your Orchestration. That depends on where your SFTP server is located.