How to Access CSV Files on SFTP Server with Xano

What is the best way to access CSV files in Xano that are stored on an SFTP server (sftptogo)? The CSV files get updated daily (overwritten daily, same filename/location).

We want to use Xano to grab the updated CSV files daily from the SFTP server.

We do not want a publicly accessible static https URL.

I ran across this API - https://ftp-api.com/, which is probably fine for our inventory product data, but we also have CSV’s with sensitive customer info.

2 replies