Pipelines CSV Handler Using SFTP for Data Source

Question

I need to monitor a folder in an SFTP folder, and import the file into a (non-connected) Quickbase table once it arrives. Then need to move the file to another folder indicating it was processed.

The documentation of the Pipelines CSV Handler mentions an action step using an HTTP request to obtain CSV data. Is it possible to retrieve the CSV data from an SFTP server instead (which requires authentication of course)?

------------------------------
Joe Acunzo
Quickbase Solution Provider
SoftTechExperts
joe.acunzo@SoftTechExperts.com
203-481-1222 ext. 316
------------------------------

sherriedrummond · Answer

I have this question as well. Would really be handy.------------------------------Sherrie Drummond------------------------------

joeacunzo · Answer

Hi Sherrie,I ended up writing a Windows app I call QuickbaseImporter that is driven from command-line parameters (no user interface).&nbsp; It can import from any folder accessible to Windows (including local drive, network drive, Dropbox, Drive, etc. if exposed as a Windows folder).&nbsp; You can specify the table and fields to import into on the command line.&nbsp; It can easily be scheduled to run with the Windows Task Scheduler.If you are interested in more details, contact me at the email/phone below.------------------------------Joe Acunzo (SoftTechExperts)Quickbase Solution Providerjoe.acunzo@SoftTechExperts.com------------------------------

sherriedrummond · Answer

Thanks Joe! I ended up using a sync'd table directly from SFTP. It seems to be working for now. Thanks again, s.------------------------------Sherrie Drummond------------------------------

Forum Discussion

Pipelines CSV Handler Using SFTP for Data Source

Related Content

Three Words of Advice on Pipelines

Issue with Accessing Nested Array(JSON handler) in Quickbase Pipeline

Pipeline Not Triggering

Three Words of Advice on Building Pipelines - Brittany Scheid

AI Smart Builder for Creating Apps and Streamlining Pipelines