Item Search Code Sample
The following example shows how to search for all inventory items that use the word “cashmere” in their internal name field.
C#
private void myItemSearch()
{
ItemSearchBasic myItemSearchBasic = new ItemSearchBasic();
SearchEnumMultiSelectField myEnum = new SearchEnumMultiSelectField();
myEnum.@operator = SearchEnumMultiSelectFieldOperator.anyOf;
myEnum.operatorSpecified = true;
String[] searchStringArray = new String[1];
searchStringArray[0] = "_inventoryItem";
myEnum.searchValue = searchStringArray;
myItemSearchBasic.type = myEnum;
SearchStringField myName = new SearchStringField();
myName.@operator = SearchStringFieldOperator.contains;
myName.operatorSpecified = true;
String myNameValue = "cashmere";
myName.searchValue = myNameValue;
myItemSearchBasic.displayName = myName;
ItemSearch myItemSearch = new ItemSearch();
myItemSearch.basic = myItemSearchBasic;
SearchResult searchResult = _service.search(myItemSearch);
}
SOAP Request
<soap:Body>
<search xmlns="urn:messages_2017_1.platform.webservices.netsuite.com">
<searchRecord xsi:type="q1:ItemSearch" xmlns:q1="urn:accounting_2017_1.lists.webservices.netsuite.com">
<q1:basic>
<displayName operator="contains" xmlns="urn:common_2017_1.platform.webservices.netsuite.com">
<searchValue xmlns="urn:core_2017_1.platform.webservices.netsuite.com">cashmere</searchValue>
</displayName>
<type operator="anyOf" xmlns="urn:common_2017_1.platform.webservices.netsuite.com">
<searchValue xmlns="urn:core_2017_1.platform.webservices.netsuite.com">_inventoryItem</searchValue>
</type>
</q1:basic>
</searchRecord>
</search>
</soap:Body>
SOAP Response
<soapenv:Body>
<searchResponse xmlns="urn:messages_2017_1.platform.webservices.netsuite.com">
<platformCore:searchResult xmlns:platformCore="urn:core_2017_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_000071_062020152867517261670438420_ab84bfa4e9f1b</platformCore:searchId>
<platformCore:recordList>
<platformCore:record xsi:type="listAcct:InventoryItem" externalId="2000A" internalId="99" xmlns:listAcct="urn:accounting_2017_1.lists.webservices.netsuite.com">
<listAcct:createdDate>2015-06-20T02:49:21.000-07:00</listAcct:createdDate>
<listAcct:lastModifiedDate>2015-06-20T03:51:12.000-07:00</listAcct:lastModifiedDate>
<listAcct:copyDescription>false</listAcct:copyDescription>
<listAcct:cogsAccount internalId="55">
<platformCore:name>5000 Purchases</platformCore:name>
</listAcct:cogsAccount>
<listAcct:includeChildren>false</listAcct:includeChildren>
<listAcct:incomeAccount internalId="54">
<platformCore:name>4000 Sales</platformCore:name>
</listAcct:incomeAccount>
<listAcct:taxSchedule internalId="1">
<platformCore:name>S1</platformCore:name>
</listAcct:taxSchedule>
<listAcct:deferRevRec>false</listAcct:deferRevRec>
<listAcct:assetAccount internalId="10">
<platformCore:name>1200 Inventory</platformCore:name>
</listAcct:assetAccount>
...
<listAcct:outOfStockBehavior>_default</listAcct:outOfStockBehavior>
<listAcct:itemId>Cashmere Sweater</listAcct:itemId>
<listAcct:displayName>Cashmere Sweater</listAcct:displayName>
<listAcct:isOnline>false</listAcct:isOnline>
<listAcct:offerSupport>false</listAcct:offerSupport>
<listAcct:isInactive>false</listAcct:isInactive>
<listAcct:availableToPartners>false</listAcct:availableToPartners>
<listAcct:currency>USA</listAcct:currency>
</platformCore:record>
</platformCore:recordList>
</platformCore:searchResult>
</searchResponse>
</soapenv:Body>
Related Topics
- Item Search
- Item Search Usage Notes
- Items
- Usage Notes for Item Record Types
- Working with Matrix Items in SOAP web services
- Shared Field Definitions for Items
- How to Use the SOAP Web Services Records Help
- SOAP Web Services Supported Records
- SOAP Schema Browser
- SuiteTalk SOAP Web Services Platform Overview