How to export data into a text file and move it onto FTP server

App Building
1

Hi everyone
I have two challenges which I am facing, and I wasn't able so far to find any reliable solution for it.

  1. I do have a dataset with like 2'000 records and I need to export them into a CSV (or plain text file). The records should be separated with a tab.
    How can I do this? I tried utils.downloadFile as well as utils.exportData, but both appear to be unusable since I want the records being separated by a tab.

  2. How can I export the file directly onto an FTP server.

Thank you for any help.

2

Hey @Reboon!

I don’t think the separate tab export functionality is possible.

For exporting directly into an FTP, I think you’d need to be able to run a query that passes data to an endpoint. Do you have a current query in Retool that you’re starting off with?

3

Hi @victoria! Has there been any update on this? Looking to accomplish the same task -- I'm able to generate everything I need within a Workflow, and am stuck at the step of writing to a file and sending to an SFTP server. Do you know how this could be done? Thank you.

4

Hey @Dean_Hathout! There isn't a native SFTP resource for you to utilize, nothing has changed on that front. But since you are using a workflow, we now allow use of custom Python libraries! I've made sure it's enabled for your org so you can test it out. Using a library like pysftp might be the best way to go.

1 Like