This repository contains the tutorial file for my guide on how to use Python to extract XML files from an SFTP server, back them up to Google Cloud Storage, and process them — all without spinning up a virtual machine.
For the full guide, please visit https://raresfin.medium.com/sftp-and-process-xml-files-in-google-cloud-platform-with-python-bdcf3a302764.
Related to answering similar threads on stack overflow:
- https://stackoverflow.com/questions/70911611/upload-file-to-google-bucket-directly-from-sftp-server-using-python
- https://stackoverflow.com/questions/48279061/gcs-read-a-text-file-from-google-cloud-storage-directly-into-python
- https://stackoverflow.com/questions/60193401/nested-xml-to-pandas-dataframe