Advanced Contact Search with Customer or Vendor details using Java

After retrieving a Contact record using the Get Operation you can get the Company internal id, which refers to the entity that the Contact record is attached to.

However, Contact records are not attached to Customers only, they can be attached to Vendor records as well.

Given the above scenario, the RecordRef from the Contact's Company field only has the internal id, but not the Record Type.

To determine if the Contact record is attached to a Customer record or a Vendor record one can use the Advanced Contact Search and add Customer and Vendor join columns.

The following is a sample SOAP request for an Advanced Contact Search that will have results under the Customer join if the Contact is attached to a Customer, will have results under the Vendor join if the Contact is attached to a Vendor and both if it is attached to a Customer record that is also a Vendor:

<soapenv:Body> <search xmlns="urn:messages_2011_1.platform.webservices.netsuite.com"> <searchRecord xsi:type="ns6:ContactSearchAdvanced" xmlns:ns6="urn:relationships_2011_1.lists.webservices.netsuite.com"> <ns6:criteria xsi:type="ns6:ContactSearch"> <ns6:basic xsi:type="ns7:ContactSearchBasic" xmlns:ns7="urn:common_2011_1.platform.webservices.netsuite.com"> <ns7:internalId xsi:type="ns8:SearchMultiSelectField" operator="anyOf" xmlns:ns8="urn:core_2011_1.platform.webservices.netsuite.com"> <ns8:searchValue xsi:type="ns8:RecordRef" internalId="14"/> </ns7:internalId> </ns6:basic> </ns6:criteria> <ns6:columns xsi:type="ns6:ContactSearchRow"> <ns6:basic xsi:type="ns9:ContactSearchRowBasic" xmlns:ns9="urn:common_2011_1.platform.webservices.netsuite.com"> <ns9:address xsi:type="ns10:SearchColumnStringField" xmlns:ns10="urn:core_2011_1.platform.webservices.netsuite.com"/> <ns9:company xsi:type="ns11:SearchColumnSelectField" xmlns:ns11="urn:core_2011_1.platform.webservices.netsuite.com"/> <ns9:email xsi:type="ns12:SearchColumnStringField" xmlns:ns12="urn:core_2011_1.platform.webservices.netsuite.com"/> <ns9:entityId xsi:type="ns13:SearchColumnStringField" xmlns:ns13="urn:core_2011_1.platform.webservices.netsuite.com"/> </ns6:basic> <ns6:customerJoin xsi:type="ns14:CustomerSearchRowBasic" xmlns:ns14="urn:common_2011_1.platform.webservices.netsuite.com"> <ns14:entityId xsi:type="ns15:SearchColumnStringField" xmlns:ns15="urn:core_2011_1.platform.webservices.netsuite.com"/> <ns14:internalId xsi:type="ns16:SearchColumnSelectField" xmlns:ns16="urn:core_2011_1.platform.webservices.netsuite.com"/> </ns6:customerJoin> <ns6:vendorJoin xsi:type="ns17:VendorSearchRowBasic" xmlns:ns17="urn:common_2011_1.platform.webservices.netsuite.com"> <ns17:entityId xsi:type="ns18:SearchColumnStringField" xmlns:ns18="urn:core_2011_1.platform.webservices.netsuite.com"/> <ns17:internalId xsi:type="ns19:SearchColumnSelectField" xmlns:ns19="urn:core_2011_1.platform.webservices.netsuite.com"/> </ns6:vendorJoin> </ns6:columns> </searchRecord> </search> </soapenv:Body>

The following is a Java code snippet to produce the above SOAP request:

  ContactSearchAdvanced contactSearchAdvanced = new ContactSearchAdvanced();

  ContactSearchRow columns = new ContactSearchRow();
  CustomerSearchRowBasic customerJoin = new CustomerSearchRowBasic();
  VendorSearchRowBasic vendorJoin = new VendorSearchRowBasic();
  ContactSearchRowBasic basic = new ContactSearchRowBasic();

  basic.setAddress(newSearchColumnStringFieldArray());
  basic.setCompany(newSearchColumnSelectFieldArray());
  basic.setEmail(newSearchColumnStringFieldArray());
  basic.setEntityId(newSearchColumnStringFieldArray());

  customerJoin.setEntityId(newSearchColumnStringFieldArray());
  customerJoin.setInternalId(newSearchColumnSelectFieldArray());

  vendorJoin.setEntityId(newSearchColumnStringFieldArray());
  vendorJoin.setInternalId(newSearchColumnSelectFieldArray());

  columns.setCustomerJoin(customerJoin);
  columns.setVendorJoin(vendorJoin);
  columns.setBasic(basic);

  ContactSearch criteria = new ContactSearch();

  ContactSearchBasic searchBasic = new ContactSearchBasic();
  SearchMultiSelectField internalId = new SearchMultiSelectField();
  internalId.setOperator(SearchMultiSelectFieldOperator.anyOf);
  RecordRef[] searchValues = new RecordRef[1];
  searchValues[0] = new RecordRef();
  searchValues[0].setInternalId("14"); // Set a Contact internal id
  internalId.setSearchValue(searchValues);
  searchBasic.setInternalId(internalId);

  criteria.setBasic(searchBasic);

  contactSearchAdvanced.setColumns(columns);
  contactSearchAdvanced.setCriteria(criteria);

  System.out.println("Searching...");
  SearchResult result = port.search(contactSearchAdvanced);

The above code will also use the following methods:

 public static SearchColumnStringField[] newSearchColumnStringFieldArray() {
  SearchColumnStringField[] searchColumnStringField = new SearchColumnStringField[1];
  searchColumnStringField[0] = new SearchColumnStringField();
  return searchColumnStringField;
 }

 public static SearchColumnSelectField[] newSearchColumnSelectFieldArray() {
  SearchColumnSelectField[] searchColumnSelectField = new SearchColumnSelectField[1];
  searchColumnSelectField[0] = new SearchColumnSelectField();
  return searchColumnSelectField;
 }