This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi, looking for recommendations on how to securely retrieve a CSV from NetSuite externally? I'm thinking that it would be generated from a saved search and possibly be stored in the filecabinet. Thanks.

You can use <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_1540391670.html#SuiteTalk-REST-Web-Services-Overview-and-Setup|SuiteTalk> to retrieve from the filecabinet or to just run the search and pull the results. You could also create a <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4387799403.html#SuiteScript-2.x-RESTlet-Script-Type|RESTlet> that does it as well.

You could also have a scheduled script on Netsuite's side that sends it to an server using <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_4617004932.html#N%2Fsftp-Module|N/sftp>

searchTask + sFTP would be ny recommendation.