title: NetSuite Data Export 100K+ rows daily
body: <p>I'm looking into the best solution of how to sync products (items), invoices, sales orders &amp; customers on a daily basis. I've had other portals that sync almost 1M records in a CSV every night and run flawlessly.</p>
  
  <p>Netsuite offers APIs but they all seem to be riddled with limits, and you're reliant on RESTful calls which I've found are great for a few rows, or updates, but not for when you're trying to get 100K - 1M rows.</p>
  
  <p>I'm leaning towards what has worked with large sets of data and that is: </p>
  
  <ul>
  <li>Database connector into NetSuite (eg OBDC)</li>
  <li>CSV Export (somehow... I heard you can do saved searches - eg create "all customers" search, and then automate this search every night to export to a CSV)</li>
  </ul>
  
  <p>Any help appreciated. All the NetSuite APIs look good, but I just don't see how they can handle daily sets of such large data reliably, and without hitting limits, timeouts or any of that.</p>
  
  <hr>
  
  <p>EDIT 1: I have read <a href="https://stackoverflow.com/questions/35584292/netsuite-data-extraction-to-database">here</a> that some people pay for the (expensive) <code>SuiteAnalytics Connect add-on module</code> and got ODBC connection access to their data. </p>
  
  <p>They also say you can probably do this through RESTlets and SuiteTalk but large data just won't be reliable I don't believe.</p>
  
  <p>EDIT 2: Schedule saved search which sends CSV as attachment <a href="https://stackoverflow.com/questions/51232560/netsuite-suitescript-2-0-exportcsv">here</a> and Place CSV in File Cabinet folder. From external server call webservices or RESTlet to grab new CSV files in the folder.</p>
  
  <p>EDIT 3: <a href="https://stackoverflow.com/questions/18617294/netsuite-migrations">NetSuite Migrations</a></p>
  
  <p>EDIT 4: <a href="https://stackoverflow.com/questions/51232560/netsuite-suitescript-2-0-exportcsv">netsuite suitescript 2.0 export(csv)</a></p>