i am new to netsuite and i am trying to create a search, which i did , an item saved search, nothing special, got 4 colunms,
internal id,
name,
description,
type,
base price ,
formula (text) as sku
i am using an itemsearchadvanced in c# but i am only getting back type and description..
here is the webservice
https://webservices.netsuite.com/wsdl/v2011_2_0/netsuite.wsdl
and here s the c# code... i am going nuts.... trying to see why not all the colunms are populated....
public List<Item> SearchItem(string searchId)
{
List<Item> item = new List<Item>();
ItemSearchAdvanced _itemSearch = new ItemSearchAdvanced();
_itemSearch.savedSearchId = searchId;
try
{
SearchResult results = _service.search(_itemSearch);
if (results.status.isSuccess)
{
foreach (var row in results.searchRowList)
{
Item itm = new Item();
var myRow = (ItemSearchRow)row;
var basic = (ItemSearchRowBasic)myRow.basic;
var price= basic.basePrice[0].searchValue;
// itm.itemid = basic.itemId[0].searchValue;
// itm.type = basic.type[0].searchValue;
// item.Add(itm);
}
}
}
catch (Exception ex)
{
//send an email here
}
return item;
}
any help will be great...........