Hi , i wanted a saved search result to write in to a csv file and move to client server. I tried creating schedule script and sftp connection to fetch file from NS filecabinet and post the file in the client server . But the ip of netsuite is keep on changing , so that the client cannot whitelist the ips everytime . SO they need an alternate solution . Please provide a solution for this integration asap. My questions : 1. can we make a restlet and make it return the csv file (is that possible) ? 2. i_f we write the sftp conenction within the restlet , from which ip the csv gets posted to the sftp server_. _PLEASE PROVIDE YOUR INPUTS. Much Appreciated!. Thanks_🙏

Read this, regarding IP addresses: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_n251955.html Probably the most common documentation link on here

FWIW, we (Celigo) off a free tier that would support this use case: build a flow that runs on a schedule, invokes the saved search, generates a CSV, and sends it to your S/FTP location of choice. Here’s a demo video I did several years ago that demos this (the UI has improved a long way since then!)

You can see an updated version of this video at the 17:15 mark of this video: https://www.celigo.com/webinar/on-demand/?id=47215

Once you create a restlet you will still need a mechanism that will pull from the restlet (something that will do a API call) This also answers number 2 basically after you build the restlet whichever mechanism will do thr API call will be the IP address which will register on the authentication The modern solution is an ipass, celigo being one of them, or other ipass platforms that'll also do it if you're already on aws or if you have an RPA tool, I'm pretty confident that'll do it too