Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
HELP!! Find Customer by External ID?
Hello,
Can someone provide the correct syntax for getting a customer record which matches a specific external ID?
I'm trying the code below, trying to find all customer, partners and leads which match the passed strCustomerID. While the query doesn't fail it doesn't return any records. What exactly is the trick???
THANKS!
-----------------------------------------------------------
private bool SearchCustomersForID(string strCustomerID, bool bReLoginIfNeeded, out Record[] records)
{
Debug.Assert(m_bLoggedIn);
records = null;
//---------------------------------------------
RecordRef recordRef = new RecordRef();
recordRef.externalId = strCustomerID;
recordRef.type = RecordType.customer;
recordRef.typeSpecified = true;
RecordRef[] recordRefs = new RecordRef[1];
recordRefs[0] = recordRef;
SearchMultiSelectField extId = new SearchMultiSelectField();
extId.@operator = SearchMultiSelectFieldOperator.anyOf;
extId.operatorSpecified = true;