Automate Table CSV Export To SFTP Location

  • 0
  • 1
  • Question
  • Updated 9 months ago
I am looking for a solution where I can export a table in a CSV format in some type of frequency (e.g. every 24 hours, or after x action takes place). What I'm trying to achieve is basically the same as Quickbase Sync, but exporting a file to a specified location rather than importing a file from a location. 

I can write an API to download the file locally, but it would be preferred if there's an option of doing the above without any manual intervention.
Photo of Quincy Adam

Quincy Adam

  • 268 Points 250 badge 2x thumb

Posted 9 months ago

  • 0
  • 1
Photo of Gil Spigelman

Gil Spigelman

  • 870 Points 500 badge 2x thumb
The only way I used to do this was using Business Objects / Crystal Reports along with Qunect. Then schedule the report to post anywhere I wanted.
Photo of Quincy Adam

Quincy Adam

  • 268 Points 250 badge 2x thumb
Thanks Gil. I was hoping QB would have something out of the box that I didn't yet explore (wishful thinking). I was researching Qunect as a potential solution, but I'm not familiar with Business Objects / Crystal Reports. I'll have to research them further. 
(Edited)