Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
nlapiSearchRecord slipping up on custom-field on CustomerRecord ??
Hi all,
This is the use case:
1. We are retrieving a list of Duns#s from the Hoovers API by making a web-service call. (This part works fine)
2. For the 100 or so Duns#s retrieved we'd like to see which of these customers already exist in our Netsuite database - by searching against the 'custentityr7dunsnumber' field in the customer record.
Here is the code that doesn't work:
allDunsNo = newArray();
allDunsNo[0]="122713931";
allDunsNo[1]="603803503";
//this array is supposed to be dynamically populated with Hoovers data - but even this doesn't work - (doesn't even work if we make the values integers)
arrSearchFilter = new nlobjSearchFilter('custentityr7dunsnumber',null, 'anyof',allDunsNo, null);
0