How to copy a specific format file from sftp to local using Python

Question

import paramiko
import os

paramiko.util.log_to_file('logfile.log')

host = "100.10.89.23"
port = 22
transport = paramiko.Transport((host, port))
password = "pass"
username = "user"
transport.connect(username = username, password = password)

sftp = paramiko.SFTPClient.from_transport(transport)

filepath = '/import/TMP'
localpath = 'F:\\Projects\\Test'
sftp.get(filepath, localpath)

sftp.close()
transport.close()

ftp_priv_key is not required to connect to sftp. Suppose I have 10 files in the given sftp path, out of which 6 files are in csv format and other or in different format. My requirement is to copy only the csv format files.

Answer 1

You will need to do something like:

sftp = paramiko.SFTPClient.from_transport(transport)
for filename in sftp.listdir(filepath):
    if filename.endswith('.csv'):
        sftp.get(filename, localpath)