NetSuite and FTP: Daily Open Orders CSV Drop Template
A scheduled Spojit workflow that pulls open NetSuite sales orders each morning, writes them to a CSV, and drops the file into an FTP folder for downstream systems.
What It Builds
A Schedule trigger fires once a day and a NetSuite Connector node (Direct mode) queries every open sales order. The rows pass through a CSV utility node to build a clean file, then an FTP Connector node uploads it to a folder your warehouse, BI, or 3PL tools already watch. No manual export, every business day.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Every weekday at 6am, query all open sales orders in NetSuite, build a CSV with the order number, customer name, order date, status, and total, then upload the file to the /exports/open-orders folder on our FTP server named with today's date.Connectors Used
- Schedule trigger - runs the roll-up on a daily cron in your time zone.
- NetSuite - reads the open sales orders.
- CSV - assembles the rows into a downloadable file.
- FTP - uploads the finished CSV to the target folder.
Customize It
Edit the prompt to shift the run time, change the FTP path, or swap the column list. You can also narrow the query to a single subsidiary or order status, or rename the file pattern so downstream jobs pick it up cleanly.
Tips
- Keep the NetSuite node in Direct mode for a fixed query: it is deterministic and costs no AI usage.
- Make sure your FTP connection has write access to the destination folder before the first run.
- Date-stamp the filename so a failed run never overwrites yesterday's good export.