I have a saved search which I have scheduled to email me the results as a CSV file. However in the CSV file it emails, it looks like it reaches 10000 rows and stops there. I have over 200000 rows in the saved search. Are there limitations on number of rows in the CSV file from NetSuite? How can I get around this?

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, there are indeed limitations on the number of rows in the CSV file from NetSuite. The limit is 10,000 rows or 5MB, whichever is reached first. This is why your CSV file stops at 10,000 rows. To get around this, you could consider running a scheduled script to produce the CSV and email the result. The

email.send()

function in NetSuite has a 10MB limit. If your file is larger than this, you will need to save the output somewhere else. Another option is to switch to CSV format if you haven't done so already. This might help reduce the size of the file and allow more rows to be included. Please note that these are workarounds and may not be suitable for all situations. Always consider the specific requirements and constraints of your project when deciding on a solution.