How to Retrieve Contact Roles and Associated Customers via NetSuite Web Services?

To retrieve Contact Roles and their associated Customers using NetSuite Web Services, follow these steps:

1. Initiate a search on Contact records, which inherently includes the "ContactRole" field. This field will return all roles associated with a given customer.

2. To determine which specific Customer a role applies to, perform a join operation on the Customer record. This will link the contact role to its corresponding customer.

3. To ensure that only the role applicable to the Customer specified in the Contact body field is returned, refine the search. This involves joining on any Customer and subsequently filtering the search results to include only those where the Joining Customer equals the one defined in the Contact Body field.The following Java code snippets illustrate how to set search columns and filter results. Please note that due to updates in the NetSuite WSDL and client library generation since 2017, the precise method signatures and navigation paths for retrieving values may vary in current implementations.

crsrb.setContactRole(new SearchColumnSelectField[] { new SearchColumnSelectField() });crsrb.setCompany(new SearchColumnSelectField[] { new SearchColumnSelectField() });CustomerSearchRowBasic customerJoinColumn = new CustomerSearchRowBasic();customerJoinColumn.setInternalId(new SearchColumnSelectField[] { new SearchColumnSelectField() });

Later in the process, when retrieving the response value, a filtering condition can be applied:

if (!((ContactSearchRow) row).getBasic().getCompany(0).getSearchValue().getInternalId().equals(((ContactSearchRow)row).getCustomerJoin().getInternalId(0).getSearchValue().getInternalId())){    continue;}