Creating integration flows between cloud applications like NetSuite and an FTP server is one of the most common iPaaS use cases. Many B2B applications and integrations rely on getting files from FTP sites.
This video goes through how to create integration flows between NetSuite and a FTP server using integrator.io. The video walks through the following integration flows:
- Exporting NetSuite data to a FTP host
A NetSuite Saved Search is used to write a file on a FTP server. Matt shows how integrator.io provides tools — such as drop-down menus showing your NetSuite records and Saved Searches — to make this process simple and intuitive. The data can be imported using any of these file types: CSV, XLSX, JSON, XML, EDI, and Fixed Width. After mapping the data, Matt selects the schedule for the integration flow.
- Updating Records in NetSuite based on a FTP file
Matt creates an integration flow that will take an Excel file with customer records from a FTP server and either update existing records with new information, such as phone number, or create new customer records in NetSuite. Similar to the prior use case, he shows tools that make it easy to create integration flows, including the handy NetSuite Assistant. The NetSuite Assistant loads the actual NetSuite form that can be used to quickly map the Excel file fields with the correct NetSuite fields.