SuiteScript 2.0 now with SFTP!
If you have been following the recent 2016.2 update you know that NetSuite introduced the new SFTP module in SuiteScript 2.0. This long sought after functionality is a great addition to NetSuite’s integration tool set. However, this feature does come with a few caveats. Please follow along while I explain what SFTP is (and isn’t), how to use it, and what it can do.I’m not going to go into a lesson on security in this post, but please note that using SFTP doesn’t mean your data is 100% secure. Although, it definitely is more secure than FTP. The security of your data must be evaluated specifically for your needs by a professional security expert.
What is SFTP?
SFTP is a method of transferring files online similar to FTP. The difference is that SFTP has built in security (via SSH) to keep your data from being snooped on while it’s being transferred. This makes it a better option for transferring sensitive information, like customer details, than FTP.
Another common point of confusion seems to be the difference between SFTP and FTPS. SFTP is not FTPS, and the two are not compatible. Similarly, SFTP is not compatible with FTP. You must have an SFTP server in order to use NetSuite’s new SFTP module.
How to use it
If you’ve read the documentation for the new SFTP module you may have noticed that some things aren’t completely clear. The basic steps are generate a password GUID, open the SFTP connection, and transfer files.
Let’s discuss the password GUID first as this is probably going to be the most confusing for those that aren’t familiar. NetSuite has built in functionality to store a password and reference that password in your scripts via a NetSuite generated GUID. This functionality is designed to keep your sensitive passwords out of your script files, script parameters, etc. In order to generate a password GUID you must create a SuiteLet with a form containing a credential field. You then post to this form with your SFTP password in the credential field and NetSuite generates the GUID.
You may have noticed that I didn’t include a way to list the files/folders on the SFTP server. That’s because it doesn’t support that functionality. In order to use this module you must know where your files are on the SFTP server and where they must be saved. You also cannot create new folders.
I hope you enjoyed this basic explanation of NetSuite’s SFTP module. Its functionality may be limited in this early version, but it’s a great improvement and NetSuite is committed to adding features in future releases to expand SuiteScript capabilities.
Learn more about the 2016.2 SuiteScript 2.0 features or contact us to see how they can be used to optimize your business processes.