Best methods for pulling raw record data out of NetSuite via SuiteScript? Hey all, We are attempting to pull raw record data out of NetSuite via a SuiteScript so that it can be handled by our downstream processes. The record objects provided to us in SuiteScripts have some odd structures which need to be manually cleaned up on our end (null numbers come back as empty strings, sublists are not structured as arrays, etc). We are trying to find solutions which allow us to grab this record data "pre-cleaned" so that we don't have to create a process which addresses all of these oddities, of which there are many. We found that NetSuite's REST Web Services API allows us to query for a given record and returns a JSON representation of the record with all of the above "cleaning" already done. We are attempting to use this API within our SuiteScript to grab the "cleaned" record and send it off to our downstream services. During our testing, we found that only a subset of NetSuite record types are fully supported; the rest are in beta. A few of the record types in beta are needed for us to progress on this sync process (Return Authorizations, Item Receipts). Question 1: We are wondering if, by enrolling in the beta program, we will have access to these record types via the REST Web Services API within our production environment.(?) If not, we will have to pivot back to cleaning the record data ourselves, barring another solution which we have not yet uncovered. Question 2: Are there any other methods of accomplishing our needs? #C298P0BCK #C29HQS63G #C2K2RJNAC

SuiteAnalytics Connect (ODBC access)

yes, and be aware of the fact that most Oracle databases do not distinguish between empty string and null, they are the same value, so this may not be a cleaning issue