via SuiteScript can I get files of type Excel (fro...
# ask-stanley-ai
m
via SuiteScript can I get files of type Excel (from an SFTP) and save them to the file cabinet?
c
AI generated answer (using internal Slack threads):
****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** Yes, you can use SuiteScript to get Excel files from an SFTP server and save them to the NetSuite File Cabinet. You can use the SFTP module in SuiteScript to establish a connection with the SFTP server and retrieve the files. Once you have the files, you can use the File module in SuiteScript to save these files to the File Cabinet. Here is a general outline of the steps you would need to follow: 1. Use the SFTP module to establish a connection with the SFTP server. 2. Use the SFTP module's methods to navigate to the directory containing the Excel files and retrieve them. 3. For each retrieved file, create a new file in NetSuite using the File module and write the contents of the retrieved file to the new file. 4. Save the new file to the File Cabinet. Please note that this is a general outline and the exact implementation may vary depending on your specific requirements and the configuration of your SFTP server and NetSuite account.
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.867193341
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.858583212
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.856810331
Please provide your feedback on this answer.