How to fetch files from remote server via SFTP using wildcards (*) for dynamic file names?

PeopleSoft Enterprise HCM 9.2, PeopleTools 8.59.12

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.