I have a saved search that contains the "Other Prices" columns, as well as Name, Location Quantity Available, and Store Description.
Here's a snippet of the XML response:
... <platformCore:searchRow xsi:type="listAcct:ItemSearchRow" xmlns:listAcct="urn:accounting_2011_1.lists.webservices.netsuite.com"> <listAcct:basic xmlns:platformCommon="urn:common_2011_1.platform.webservices.netsuite.com"> <platformCommon:itemId> <platformCore:searchValue>Sample SKU</platformCore:searchValue> </platformCommon:itemId> <platformCommon:locationQuantityAvailable> <platformCore:searchValue>18.0</platformCore:searchValue> </platformCommon:locationQuantityAvailable> <platformCommon:otherPrices> <platformCore:searchValue>9.99</platformCore:searchValue> <platformCore:customLabel>Sample Price Name 1</platformCore:customLabel> </platformCommon:otherPrices> <platformCommon:otherPrices> <platformCore:searchValue>10.99</platformCore:searchValue> <platformCore:customLabel>Sample Price Name 2</platformCore:customLabel> </platformCommon:otherPrices> <platformCommon:storeDescription> <platformCore:searchValue>Sample Item Description</platformCore:searchValue> </platformCommon:storeDescription> </listAcct:basic> </platformCore:searchRow> ...
And here's a snippet of the parsed PHP object: Array ( [0] =&gt; nsComplexObject Object ( [nsComplexObject_type] =&gt; ItemSearchRow [nsComplexObject_namespace] =&gt; urn:accounting_2011_1.lists.webservices.netsuite.com [nsComplexObject_fields] =&gt; Array ( [basic] =&gt; nsComplexObject Object ( [nsComplexObject_type] =&gt; ItemSearchRowBasic [nsComplexObject_namespace] =&gt; urn:common_2011_1.platform.webservices.netsuite.com [nsComplexObject_fields] =&gt; Array ( [itemId] =&gt; nsComplexObject Object ( [nsComplexObject_type] =&gt; SearchColumnStringField [nsComplexObject_namespace] =&gt; urn:core_2011_1.platform.webservices.netsuite.com [nsComplexObject_fields] =&gt; Array ( [searchValue] =&gt; Sample SKU ) [nsComplexObject_namespaces] =&gt; ) [locationQuantityAvailable] =&gt; nsComplexObject Object ( [nsComplexObject_type] =&gt; SearchColumnDoubleField [nsComplexObject_namespace] =&gt; urn:core_2011_1.platform.webservices.netsuite.com [nsComplexObject_fields] =&gt; Array ( [searchValue] =&gt; 18.0 ) [nsComplexObject_namespaces] =&gt; ) [<span style="color:'"Red"'">storeDescription</span>] =&gt; Array ( [0] =&gt; nsComplexObject Object ( [nsComplexObject_type] =&gt; SearchColumnDoubleField [nsComplexObject_namespace] =&gt; urn:core_2011_1.platform.webservices.netsuite.com [nsComplexObject_fields] =&gt; Array ( [searchValue] =&gt; 9.99 [customLabel] =&gt; Sample Price Name 1 ) [nsComplexObject_namespaces] =&gt; ) [1] =&gt; nsComplexObject Object ( [nsComplexObject_type] =&gt; SearchColumnDoubleField [nsComplexObject_namespace] =&gt; urn:core_2011_1.platform.webservices.netsuite.com [nsComplexObject_fields] =&gt; Array ( [searchValue] =&gt; 10.99 [customLabel] =&gt; Sample Price Name 2 ) [nsComplexObject_namespaces] =&gt; ) [2] =&gt; nsComplexObject Object ( [nsComplexObject_type] =&gt; SearchColumnDoubleField [nsComplexObject_namespace] =&gt; urn:core_2011_1.platform.webservices.netsuite.com [nsComplexObject_fields] =&gt; Array ( [searchValue] =&gt; 10.58 [customLabel] =&gt; Drop Ship Freight Included 4 - Gold ) [nsComplexObject_namespaces] =&gt; ) ... ) ) [nsComplexObject_namespaces] =&gt; ) ) [nsComplexObject_namespaces] =&gt; )
As you can see the Other Prices got parsed under the Store Description, and the Store Description is nowhere to be found.Any advice how to fix or workaround this bug? I have deleted and re-created the saved search several times, but clearly the XML it's returning is fine. It's getting parsed incorrectly