Item Search with Pricing Matrix

[crichardson9]

The following code returns 50 items:

$this->netSuiteService->setSearchPreferences(false, 50, false);
$request = new SearchRequest();
$request->searchRecord = new ItemSearchAdvanced();
$request->searchRecord->criteria = new ItemSearch();
$response = $this->netSuiteService->search($request);

And since $bodyFieldsOnly is false all item data is returned (including a pricingMatrix property):

...
  ["pricingMatrix"]=>
  object(NetSuite\Classes\PricingMatrix)#1412 (2) {
    ["pricing"]=>
    array(4) {
      [0]=>
      object(NetSuite\Classes\Pricing)#1413 (4) {
        ["currency"]=>
        object(NetSuite\Classes\RecordRef)#1414 (4) {
          ["internalId"]=>
          string(1) "4"
          ["externalId"]=>
          NULL
          ["type"]=>
          NULL
          ["name"]=>
          string(3) "EUR"
        }
        ["priceLevel"]=>
        object(NetSuite\Classes\RecordRef)#1415 (4) {
          ["internalId"]=>
          string(1) "1"
          ["externalId"]=>
          NULL
          ["type"]=>
          NULL
          ["name"]=>
          string(10) "Base Price"
        }
        ["discount"]=>
        NULL
        ["priceList"]=>
        object(NetSuite\Classes\PriceList)#1416 (1) {
          ["price"]=>
          array(1) {
            [0]=>
            object(NetSuite\Classes\Price)#1417 (2) {
              ["value"]=>
              float(22.74)
              ["quantity"]=>
              float(0)
            }
          }
        }
      }
    }
    ["replaceAll"]=>
    bool(false)
  }
...

However, with $bodyFieldsOnly set to false the query takes a long time to complete (since all data is being retrieved).

Is there a way to return all items, their internal ID and their pricing matrix?

I've managed to retrieve the internal ID but no pricing data:

$this->netSuiteService->setSearchPreferences(true, 50, true);
$request = new SearchRequest();
$request->searchRecord = new ItemSearchAdvanced();
$request->searchRecord->criteria = new ItemSearch();
$request->searchRecord->columns = new ItemSearchRow();
$request->searchRecord->columns->basic = new ItemSearchRowBasic();
$request->searchRecord->columns->basic->internalId = new SearchColumnSelectField();
$response = $this->netSuiteService->search($request);

Any help or advice would be much appreciated as I've been banging my head on the desk for a while now!

[jrebs]

I'm not sure if this is possible using web services directly. I know there are some things that their API just doesn't support and the solution to those from what I've seen is to use a custom search and then use the ID of that search in your web services calls. Perhaps that could be used to accomplish your desired outcome?