Pagination Example

[bfarrgaynor]

Are you able to provide a working example of how pagination works?

I seem to be struggling to get results on 'page 2' and beyond in any of my queries, either on saved searches like my example below, or in cases where I'm looking at a specific location that I know has lots of results.

`<?php

namespace BBEC\Console\Commands;

use Illuminate\Console\Command;
use NetSuite\NetSuiteService;
use NetSuite\Classes\InventoryNumberSearchAdvanced;
use NetSuite\Classes\SearchRequest;
use NetSuite\Classes\SearchPreferences;
use NetSuite\Classes\SearchMoreWithIdRequest;

class GetInventoryNumberSavedSearch extends Command
{
protected $signature = 'netsuite:get-inventory-numbers';
protected $description = 'Retrieve results from a NetSuite saved search on Inventory Numbers';

//protected NetSuiteService $service;

public function __construct()
{
    parent::__construct();

    // Initialize NetSuite service (using the 2024_2 endpoint).
    $this->service = new NetSuiteService([
        'endpoint'       => env('NETSUITE_API_ENDPOINT', '2024_2'),
        'host'           => env('NETSUITE_API_HOST'),
        'account'        => env('NETSUITE_API_ACCOUNT'),
        'consumerKey'    => env('NETSUITE_API_CONSUMER_KEY'),
        'consumerSecret' => env('NETSUITE_API_CONSUMER_SECRET'),
        'token'          => env('NETSUITE_API_TOKEN'),
        'tokenSecret'    => env('NETSUITE_API_TOKEN_SECRET'),
    ]);

    // Increase pageSize if you have many records (e.g., 6400).
    // NetSuite often allows up to 1000 per page.
    $this->service->setSearchPreferences(new SearchPreferences([
        'bodyFieldsOnly' => false,
        'pageSize'       => 1000,
    ]));
}

public function handle()
{
    $this->info("Running saved search 'customsearch1083' (internal ID 1083) on Inventory Numbers...");

    // 1) Create the "SearchAdvanced" record referencing your saved search ID.
    $search = new InventoryNumberSearchAdvanced();
    $search->savedSearchId = '1083';  // Script ID
    // Alternatively: $search->savedSearchScriptId = 'customsearch1083';

    // 2) Build the SearchRequest
    $request = new SearchRequest();
    $request->searchRecord = $search;

    // 3) Initial search call
    $response = $this->service->search($request);

    if (!$response->searchResult->status->isSuccess) {
        $this->error("Initial search failed: " . $response->searchResult->status->statusDetail[0]->message);
        return Command::FAILURE;
    }

    // Grab searchId, totalPages, etc.
    $searchId   = $response->searchResult->searchId;
    $totalPages = $response->searchResult->totalPages;
    $pageIndex  = 1;

    // 4) Loop through all pages (if pagination works on your account)
    do {
        // If on page > 1, call searchMoreWithId
        if ($pageIndex > 1) {
            $this->info("Fetching page {$pageIndex} of {$totalPages}...");
            $response = $this->service->searchMoreWithId(
                new SearchMoreWithIdRequest([
                    'searchId'  => $searchId,
                    'pageIndex' => $pageIndex,
                ])
            );

            if (!$response->searchResult->status->isSuccess) {
                $this->error("searchMoreWithId failed on page {$pageIndex}.");
                return Command::FAILURE;
            }
        }

        // 5) Process the returned records
        $records = $response->searchResult->recordList->record ?? [];
        foreach ($records as $record) {
            // Each $record is an InventoryNumber object (if your saved search returns that record type)
            $internalId = $record->internalId ?? 'N/A';
            $itemName   = $record->itemName ?? 'N/A';  // Example field
            $memo       = $record->memo ?? 'N/A';
            // You can also look at $record->locationsList->locations to see on-hand info per location, etc.

            $this->line("ID: {$internalId} | Item: {$itemName} | Memo: {$memo}");
        }

        $pageIndex++;
    } while ($pageIndex <= $totalPages);

    $this->info("Done retrieving saved search results.");
    return Command::SUCCESS;
}

}`

Result:

` php artisan netsuite:get-inventory-numbers
Running saved search 'customsearch1083' (internal ID 1083) on Inventory Numbers...
Fetching page 2 of 128...

In NetSuiteClient.php line 197:

No such operation 'searchMoreWithId' `

Here is another example:

`<?php

namespace BBEC\Console\Commands;

use Illuminate\Console\Command;
use NetSuite\NetSuiteService;
use NetSuite\Classes\ItemSearchBasic; // Use ItemSearchBasic instead of InventoryItemSearchBasic
use NetSuite\Classes\SearchRequest;
use NetSuite\Classes\SearchPreferences;
use NetSuite\Classes\SearchMoreWithIdRequest;

class SyncNetSuiteProducts extends Command
{
protected $signature = 'netsuite:sync-products';
protected $description = 'Sync products from NetSuite and display their data';

protected $service;

public function __construct()
{
    parent::__construct();

    // Initialize NetSuite service
    $this->service = new NetSuiteService([
        'endpoint'       => env('NETSUITE_API_ENDPOINT', '2024_2'),
        'host'           => env('NETSUITE_API_HOST'),
        'account'        => env('NETSUITE_API_ACCOUNT'),
        'consumerKey'    => env('NETSUITE_API_CONSUMER_KEY'),
        'consumerSecret' => env('NETSUITE_API_CONSUMER_SECRET'),
        'token'          => env('NETSUITE_API_TOKEN'),
        'tokenSecret'    => env('NETSUITE_API_TOKEN_SECRET'),
    ]);

    // Set global search preferences
    $this->service->setSearchPreferences(new SearchPreferences([
        'bodyFieldsOnly' => false,
        'pageSize' => 50
    ]));
}

public function handle()
{
    $this->info("Fetching products from NetSuite with inventory at location 18 ...");

    $locationId = "18";
    $pageIndex = 1;

    // Use ItemSearchBasic to pull inventory info
    $search = new ItemSearchBasic();
    $request = new SearchRequest();
    $request->searchRecord = $search;

    $response = $this->service->search($request);

    if (!$response->searchResult->status->isSuccess) {
        $this->error("Initial search failed.");
        return;
    }

    $searchId = $response->searchResult->searchId;
    $totalPages = $response->searchResult->totalPages;

    do {
        if ($pageIndex > 1) {
            $response = $this->service->searchMoreWithId(
                new SearchMoreWithIdRequest([
                    'pageIndex' => $pageIndex,
                    'searchId' => $searchId,
                ])
            );

            if (!$response->searchResult->status->isSuccess) {
                $this->error("SearchMoreWithId failed on page {$pageIndex}.");
                return;
            }
        }

        $records = $response->searchResult->recordList->record ?? [];

        foreach ($records as $item) {
            $internalId = $item->internalId ?? 'N/A';
            $name = $item->displayName ?? $item->itemId ?? 'N/A';
            $qtyAtLocation = 'N/A';

            if (isset($item->locationsList) && isset($item->locationsList->locations)) {
                foreach ($item->locationsList->locations as $location) {
                    if (
                        isset($location->location->internalId) &&
                        $location->location->internalId == $locationId
                    ) {
                        $qtyAtLocation = $location->quantityAvailable ?? $location->quantityOnHand ?? '0';
                        break;
                    }
                }
            } else {
                $this->warn("Item {$internalId} has no locationsList.");
            }

            $this->line("ID: {$internalId} | Name: {$name} | Qty at Location 18: {$qtyAtLocation}");
        }

        $pageIndex++;
    } while ($pageIndex <= $totalPages);

    $this->info("Done syncing from NetSuite.");
}

}`

And the results:

`...
ID: 6464 | Name: Aquawood - Wharf's Pier 34 - 2530-665 | Qty at Location 18: N/A
Item 6465 has no locationsList.
ID: 6465 | Name: Big Ben Plus - Nottingham Oak 09 | Qty at Location 18: N/A
Item 6466 has no locationsList.
ID: 6466 | Name: Big Ben Plus - London Fog 11 | Qty at Location 18: N/A
Item 6467 has no locationsList.
ID: 6467 | Name: Big Ben Plus - Hackney 1231 | Qty at Location 18: N/A
Item 6468 has no locationsList.
ID: 6468 | Name: Big Ben Plus - Bristol Brown 13 | Qty at Location 18: N/A
Item 6469 has no locationsList.
ID: 6469 | Name: Big Ben Plus - Camber Sands 15 | Qty at Location 18: N/A
Item 6470 has no locationsList.
ID: 6470 | Name: Big Ben Plus - Soho Chic 16 | Qty at Location 18: N/A
Item 6471 has no locationsList.
ID: 6471 | Name: Big Ben Plus - Sherwood 58 | Qty at Location 18: N/A
Item 6472 has no locationsList.
ID: 6472 | Name: Camden Lock 12mm Laminate - Newcastle Ale 8389-1 | Qty at Location 18: N/A
Item 6473 has no locationsList.
ID: 6473 | Name: Camden Lock 12mm Laminate - Farynor Smoke 8389-2 | Qty at Location 18: N/A
Item 6474 has no locationsList.
ID: 6474 | Name: Camden Lock 12mm Laminate - Jasmine 8367-9 | Qty at Location 18: N/A
Item 6475 has no locationsList.
ID: 6475 | Name: Camden Lock 12mm Laminate - Regent 1754-1 | Qty at Location 18: N/A
Item 6476 has no locationsList.
ID: 6476 | Name: Camden Lock 12mm Laminate - Dorset 1014-7 | Qty at Location 18: N/A
Item 6477 has no locationsList.
ID: 6477 | Name: Camden Lock 12mm Laminate - Somerset 1008-7 | Qty at Location 18: N/A
Item 6478 has no locationsList.
ID: 6478 | Name: Camden Lock 12mm Laminate - Stratford 1014-5-6 | Qty at Location 18: N/A

In NetSuiteClient.php line 197:

No such operation 'searchMoreWithId'
`

[neclimdul]

I could probably figure something out but really it is kinda a pain. I made to help and skimming some of your code it looks like it would work for you.

https://packagist.org/packages/neclimdul/netsuite-search-iterator