I'm working with data being dumped into an SFTP server on a daily basis. It inserts each file on a daily basis as such:
TEST_TSMVR_NG_Contacts20211025.zip
And within some of the .zip files (though not all of them. Some days nothing will be in the .zip files) will be a .txt file that looks like such:
TEST_TSMVR_NG_Contacts20211025.txt
What I'm trying to do is figure out the most efficient way of getting these files from the SFTP and into a dataframe. What would be the most efficient way to accomplish such a request?