Downloading the most recent file

using System;
using System.Linq;
using WinSCP;
 
class Program
{
    static int Main(string[] args)
    {
        try
        {
            // Setup session options
            SessionOptions sessionOptions = new SessionOptions
            {
                Protocol = Protocol.Sftp,
                HostName = "example.com",
                UserName = "user",
                Password = "mypassword",
                SshHostKeyFingerprint = "ssh-rsa 2048 xxxxxxxxxxx...",
            };
 
            using (Session session = new Session())
            {
                // Connect
                session.Open(sessionOptions);
 
                const string remotePath = "/home/user";
                const string localPath = @"C:\downloaded";
 
                // Get list of files in the directory
                RemoteDirectoryInfo directoryInfo = session.ListDirectory(remotePath);
 
                // Select the most recent file
                RemoteFileInfo latest =
                    directoryInfo.Files
                        .Where(file => !file.IsDirectory)
                        .OrderByDescending(file => file.LastWriteTime)
                        .FirstOrDefault();
 
                // Any file at all?
                if (latest == null)
                {
                    throw new Exception("No file found");
                }
 
                // Download the selected file
                session.GetFileToDirectory(latest.FullName, localPath);
            }
 
            return 0;
        }
        catch (Exception e)
        {
            Console.WriteLine("Error: {0}", e);
            return 1;
        }
    }
}

The following snippet selects the most recent file from a directory listing. Most of the remaining code should be trivial to translate from the above C# example.

Dim latest As RemoteFileInfo =
    directoryInfo.Files _
        .Where(Function(file) Not file.IsDirectory) _
        .OrderByDescending(Function(file) file.LastWriteTime) _
        .FirstOrDefault()

Use the -latest switch of the get command:

get -latest /home/user/* c:\downloaded\

Some of following alternatives can be easier to implement or actually even more appropriate for your specific task:

• Synchronizing a remote directory to a local directory (using synchronize local in scripting; or Session.SynchronizeDirectories with mode parameter set to SynchronizationMode.Local in .NET assembly);
• Downloading all files created in the last 24 hours (using file mask *>=1D; e.g. get -filemask="*>=1D" /home/user/*, or an equivalent in .NET assembly).
• Downloading all files created today (using the today keyword in the file mask; e.g. get -filemask="*>=today" /home/user/*, or an equivalent in .NET assembly).
• If you need to download all files that were not downloaded yet, but you do not keep local copies of the files to synchronize the remote directory against, see Remember already downloaded files so they are not downloaded again.

• Guide to scripting/automation;
• WinSCP .NET assembly;
• Using WinSCP .NET assembly from PowerShell.