1. SuiteCloud Platform
  2. SuiteTalk Web Services
  3. SuiteTalk SOAP Web Services Records Guide
  4. Searches
  5. Item Search
  6. Item Search Code Sample

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

General Notices