The file name on the remote SFTP server is not constant. There is a suffix of date time stamp on the file name. We have tried to fetch the file using getattachment method with the wildcard * in the file name. The SFTP server, path. and credentials are set up as a URL. This threw an error - unsupported characters for filename.
I see that FindFiles method does not work on the remote servers. So, I do not see a way to get the file name(s) before using them with the getattachement method.
I see others looking for similar feature for many years now, and it is surprising that this has not been delivered by the PeopleSoft development team. The answer I got from Oracle Support for a Service Request created was that this feature was not supported.
Has anyone found a native solution other than installing SFTP clients (ex: RoboFTP) and building external FTP scripts or writing shell/batch scripts?