Perry Auld
02/05/2025, 10:45 PMCeligo AI
02/05/2025, 10:45 PMAI generated answer (using internal Slack threads):Based on the conversations, it seems that connecting to an SFTP server from NetSuite using N/sftp when the SFTP server has a firewall that requires specific IP addresses can be challenging. This is because NetSuite's IP addresses (both inbound and outbound) are dynamic and can change. One approach to resolve this issue is to use DNS instead of IP. Any firewall should be able to cope with DNS. Here is a link for more information: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N251955.html#subsect_157062775551 If you prefer to use IP's, you can try these: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_162859452018.html Another approach is to use a reverse proxy with a static IP to connect to an SFTP server. If you are facing an error "FTP_CANNOT_ESTABLISH_CONNECTION" while connecting to the server using SSH authentication using the N/sftp module in the script, you can try connecting with the IP address instead of the domain name. For uploading a CSV file from NetSuite to an SFTP server, and the bank is asking to provide an IP address so that they can whitelist the IP, it is suggested to use client-side certificates for authentication instead of attempting to whitelist IP. You can upload your SSH private key in the NetSuite UI for this purpose. You can generate an SSH key using tools like Putty or
ssh-keygen
which is part of openSSH.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
02/05/2025, 10:45 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.848995388
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.845670104
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838026762
Celigo AI
02/05/2025, 10:45 PM