We have a saved search that we need to send as a CSV file to an SFTP server. Which is the better approach? 1. Use suitescript to convert the saved search to a CSV file, store it in the File Cabinet and then use the SFTP Connector SuiteApp to send the data finally to the SFTP server 2. Use suitescript for everything

#2 - Use SuiteScript for everything. Tried and tested method for me.

something that has tripped me up is the 100mb limit when using suitescript

Thanks. Our file won't even exceed 10MB but that's good to know.

#2 is the approach I have done

By the way, they're giving us a PGP key to encrypt the files that we will send to them. I can see that there is a new PGP module that could potentially handle this requirement? Is that correct?