We are using customRecordSearchBasic to search a custom record of name "Item Country" using soap web services.
The request payload which we are using is:
<soap-env:Body>
<search xmlns="urn:messages_2020_1.platform.webservices.netsuite.com">
<searchRecord xmlns:q1="urn:common_2020_1.platform.webservices.netsuite.com" xmlns:q2="urn:core_2020_1.platform.webservices.netsuite.com" xsi:type="q1:CustomRecordSearchBasic">
<q1:isInactive>
<searchValue xmlns="urn:core_2020_1.platform.webservices.netsuite.com">false</searchValue>
</q1:isInactive>
<q1:recType internalId="743"></q1:recType>
</searchRecord>
</search>
</soap-env:Body>
This is the response which we are getting:
<soapenv:Body>
<searchResponse xmlns="urn:messages_2020_1.platform.webservices.netsuite.com">
<platformCore:searchResult xmlns:platformCore="urn:core_2020_1.platform.webservices.netsuite.com">
<platformCore:status isSuccess="true"/>
<platformCore:totalRecords>2</platformCore:totalRecords>
<platformCore:pageSize>1000</platformCore:pageSize>
<platformCore:totalPages>1</platformCore:totalPages>
<platformCore:pageIndex>1</platformCore:pageIndex>
<platformCore:searchId>WEBSERVICES_5075953_SB3_102820219750546121271240263_663c0be1</platformCore:searchId>
<platformCore:recordList>
<platformCore:record internalId="1" xsi:type="setupCustom:CustomRecord" xmlns:setupCustom="urn:customization_2020_1.setup.webservices.netsuite.com">
<setupCustom:isInactive>false</setupCustom:isInactive>
<setupCustom:owner internalId="1429">
<platformCore:name>Adil Sardar</platformCore:name>
</setupCustom:owner>
<setupCustom:recType internalId="743">
<platformCore:name>Item Country</platformCore:name>
</setupCustom:recType>
<setupCustom:customFieldList>
<platformCore:customField internalId="3548" scriptId="custrecord_amdi_item_for_country" xsi:type="platformCore:SelectCustomFieldRef">
<platformCore:value internalId="2904" typeId="-10">
<platformCore:name>GS-TEST-AML-101 testing molecularassay device</platformCore:name>
</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId="3549" scriptId="custrecord_amdi_country_sold_to" xsi:type="platformCore:SelectCustomFieldRef">
<platformCore:value internalId="1" typeId="-159">
<platformCore:name>Andorra</platformCore:name>
</platformCore:value>
</platformCore:customField>
</setupCustom:customFieldList>
</platformCore:record>
<platformCore:record internalId="2" xsi:type="setupCustom:CustomRecord" xmlns:setupCustom="urn:customization_2020_1.setup.webservices.netsuite.com">
<setupCustom:isInactive>false</setupCustom:isInactive>
<setupCustom:owner internalId="1429">
<platformCore:name>Adil Sardar</platformCore:name>
</setupCustom:owner>
<setupCustom:recType internalId="743">
<platformCore:name>Item Country</platformCore:name>
</setupCustom:recType>
<setupCustom:customFieldList>
<platformCore:customField internalId="3548" scriptId="custrecord_amdi_item_for_country" xsi:type="platformCore:SelectCustomFieldRef">
<platformCore:value internalId="2904" typeId="-10">
<platformCore:name>GS-TEST-AML-101 testing molecularassay device</platformCore:name>
</platformCore:value>
</platformCore:customField>
<platformCore:customField internalId="3549" scriptId="custrecord_amdi_country_sold_to" xsi:type="platformCore:SelectCustomFieldRef">
<platformCore:value internalId="12" typeId="-159">
<platformCore:name>American Samoa</platformCore:name>
</platformCore:value>
</platformCore:customField>
</setupCustom:customFieldList>
</platformCore:record>
</platformCore:recordList>
</platformCore:searchResult>
</searchResponse>
</soapenv:Body>
In this response, we are getting all objects of this custom record. We want to get some objects on the basis of the custom list attribute "custrecord_amdi_item_for_country" in this record. Please tell us how can we use this CustomRecordSearchBasic to search objects of "Item Country" on the basis of "custrecord_amdi_item_for_country" attribute.