I have read that the sFTP implementationi cannot list files on the remote server. Is that correct? Looking at using it to pull XML order files but these would have unique names that would not be known in advance.

Based on the documentation, that is correct