Getting None when trying to use pysftp to get file

Question

I need to get files from server and next write them to database. I use:

with pysftp.Connection(host, username=username, password=password, cnopts=cnopts) as sftp:
    sftp.chdir('path')
    all_files = [file_name for file_name in sftp.listdir() if 'access' in file_name]
    today_log = all_files[0]
    all_files = all_files[1:]
    df = df.append(sftp.get(str(today_log)))

But it returns None. How can I get content from file and write it to dataframe?

@martineau content of file is empty and it returns None, but it doesn't empty. I need to read that and add to dataframe — Petr Petrov
– Petr Petrov, Commented Jun 1, 2017 at 14:19
@errata It's list. I filter list in directory and next I add it's name to sftp.get() — Petr Petrov
– Petr Petrov, Commented Jun 1, 2017 at 14:21
@PetrPetrov I know it is a list, I was asking for a value of it? :) — errata
– errata, Commented Jun 1, 2017 at 14:24

Martin Prikryl · Accepted Answer · 2018-01-30 07:00:45Z

1

If I understand your question correctly, you want to read the file from SFTP server into a variable/memory.

For that, you need to use .getfo, like:

flo = BytesIO()
sftp.getfo(remotepath, flo)

Alternatively, use Paramiko library directly (without the pysftp wrapper).
See Read a file from server with ssh using python.

edited Jan 30, 2018 at 7:00

answered Jun 2, 2017 at 5:34

Martin Prikryl

205k64 gold badges560 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting None when trying to use pysftp to get file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related