Quick question, I have read that we can only connect to SFTP from SuiteScript 2.0 (actually I have done this in the past) however is it a totally different story if the server is just FTP (no secure) ? What have you done to achieve this?

Use a middle-man java service

I see, so a middleware is necessary here. I wanted to double check what people say here: https://stackoverflow.com/questions/32459584/export-file-from-netsuites-filecabinet-to-ftp Thanks @CD

Unfortunately, all true. No version of SuiteScript has FTP support, so some external service needs to be used that can connect both to FTP and to NetSuite.

Perfect, thanks for confirming this @scottvonduhn

Take a look at Celigo. Should be able to do it with a free celigo.com account.

Thanks @rico!