How to Perform Joined Searches in NetSuite SOAP Web Services?

Joined searches are supported in NetSuite web services, allowing users to retrieve information from associated records. For instance, a contact search can yield data about its linked customer or phone calls. When utilizing a basic search for joined data, joins are restricted to the search criteria. However, advanced searches offer the flexibility to perform joins in both the criteria and the search results.It is important to note that NetSuite is deprecating SOAP web services, with the 2025.2 SOAP endpoint being the last regularly scheduled release, supported until 2028.2. REST web services are the recommended modern integration channel for new development.To perform a joined search using SOAP, an example of the request structure is provided below, demonstrating how to include passport details with updated namespaces:

xml<soapenv:Envelope xmlns:soapenv"http://schemas.xmlsoap.org/soap/envelope/">   <soapenv:Header>      <platformMsgs:passport xmlns:platformCore"urn:core_2025_1.platform.webservices.netsuite.com" xmlns:platformMsgs"urn:messages_2025_1.platform.webservices.netsuite.com" xmlns:soapenc"http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd"http://www.w3.org/2001/XMLSchema" xmlns:xsi"http://www.w3.org/2001/XMLSchema-instance">         <platformCore:email>demous@it-ration.com</platformCore:email>   &am