HI
I have a suitelet that leverages a saved search within Netstuite to return transaction data for an external website,
Yet at the end of it, it continually returns the following.
we have other code that is running quite well using this same scripting style, yet for some unknown reason, this is always returning the Netsuite HTML code which breaks our JSON handlers.
any info greatly appreciated
<!-- 11,189 s: 92% #23 co: 0% #6-->
<!-- [ a.j19.sv ] [ 2013.2.0.117 ]-->
<!-- [ 1299661 ] [ support@domainname.com.au ] [ /app/site/hosting/scriptlet.nl ] [ Fri Dec 13 22:06:14 PST 2013 ] -->
<!-- Not logging slowest SQL -->
my suitelet is below.
function transactionSearch(request,response) { var custId = '2737'; var type = 'salesorder'; var lastId = '0'; var isBack = ''; var retObj = []; var filter = []; filter.push(new nlobjSearchFilter('entity', null, 'anyOf', custId)); //filter.push(new nlobjSearchFilter('type', null, 'anyOf', type)); //filter.push(new nlobjSearchFilter('internalidnumber', null, 'greaterthan', lastId)); var columns = [ new nlobjSearchColumn('internalid').setSort(true) ]; if (isBack) { columns[0] .setSort(false); filter.push(new nlobjSearchFilter('internalidnumber', null, 'lessthan', lastId)); } var rs = nlapiSearchRecord('transaction','customsearch_pm_transaction_record_loade',filter); // add in a saved search for transactions here. var maxLen = rs.length &gt; 5 ? 5 : rs.length; for (x = 0; x &lt; 3 ; x++) //rs.length { var flds = rs[x].getAllColumns(); var rowObj = [] ; for (i = 0; i &lt; flds.length; i++) { var dataObj = {}; // rowObj.name = flds[i].getName(); dataObj.name = flds[i].getName(); dataObj.label = flds[i].getLabel(); dataObj.val = rs[x].getValue(flds[i].getName(), flds[i].getJoin(), flds[i].getSummary()); dataObj.txtval = rs[x].getText(flds[i].getName(), flds[i].getJoin(), flds[i].getSummary()) rowObj.push(dataObj); } retObj.push(rowObj); } response.write(JSON.stringify(rs)); } // end function..