I am building a pipeline that reads from an sftp directory and has a new file posted daily. I can access a file if I hard-code the name, but what is the syntax to get it to pick up the newest file posted each day? Each new file has a unique code number and date appended to the end of the file name. I’ve tried adding a * and * . * but neither seems to pick up the newest file.
Thanks in advance!