Organize Table Data by Sublist Using Scripts in NetSuite

Updated for NetSuite 2026.2 with CPQ AI Assistant availability and configuration-data preservation guidance for SuiteApp migration.

·3 min read·43 views·View Oracle Docs

In NetSuite 2026.2, when loading dynamic and function-generated tables using scripts, you can obtain data organized by sublist. To achieve this in NetSuite CPQ Configurator, you can set the new sublist parameter for getTable().loadContent() to true. By default, this parameter is set to false, allowing you to omit it if organization by sublist isn't necessary. This new implementation is recommended over the traditional method using getData() with the loadapi parameter set to true, as it significantly enhances the performance of table loading.

Syntax Example

Here's how to use the getTable().loadContent() function with the sublist parameter:

javascript
let table = await getTable('TABLE_CODE').loadContent({
sublists: true
});

Function Output

The output in the console for the above function will display the organized table data by sublist, enabling more refined data processing and display. This improvement is particularly beneficial in applications where data volume is significant and organization plays a crucial role in usability and speed.

Key Benefits

  • Improved Performance: By using the sublist parameter, table loading becomes more efficient compared to traditional methods.
  • Flexible Implementation: The sublist parameter can be set or omitted based on specific use cases, providing flexibility in script development.

Note: Ensure that you are on the latest version of the NetSuite CPQ Configurator for optimal results.

Who This Affects

  • Administrators: Manage and implement new scripting capabilities.
  • Developers: Enhance scripts to utilize the sublist organization feature.
  • End Users: Experience improved data organization and loading times in the application.

Key implementations of this feature will help in maintaining organized and efficient data representation in various NetSuite applications, particularly those using scripting for dynamic data presentations.

CPQ Configuration Assistance

Separate from the table-loading API, the NetSuite 2026.2 release information introduces the CPQ AI Assistant in NetSuite CPQ Configurator version 1.8.0. This generative AI tool uses a large language model to guide sales representatives and buyers through product and service configurations using natural language prompts.

When a user selects a configurable item in a transaction, the Configure with CPQ Assistant button appears in the bottom-right corner. Selecting it opens a guided chat that collects configuration details, clarifies options, and provides real-time recommendations.

Users with the Administrator or CPQ Product Builder role prepare product, question, and answer records on each record's CPQ AI Assistant subtab. They can review readiness, create or improve AI descriptions, ensure record quality, and control where and when end users see the assistant.

Availability is limited to supported account locations and supported user language preferences. Regional service availability, account settings, roles, and permissions can also affect access. See Generative AI Feature Availability in NetSuite and NetSuite CPQ AI Assistant.

Preserving Configuration Data During Migration

For administrators moving from the NetSuite CPQ Configurator bundle to the corresponding SuiteApp, the NetSuite 2026.2 release information also describes the public, managed NSCPQ Bundle Migration bundle (version 1.0.0, ID 596110). It preserves configuration records and transaction field data, reducing the resources that must be exported and imported and shortening the migration process.

Install this migration bundle after updating the NetSuite CPQ Configurator bundle to the latest version and before exporting bundle data. Without it, the Configurator bundle can't be uninstalled during migration. This installation step doesn't apply to NetSuite CPQ Guided Selling.

To install the migration bundle:

  1. Go to Customization > SuiteBundler > Search & Install Bundles.
  2. In Keywords, enter NSCPQ Bundle Migration.
  3. In the Name column, select NSCPQ Bundle Migration.
  4. On the Bundle Details page, click Install.

Warning: Keep the migration bundle installed after migration to continue editing existing configured items added to transactions by the Configurator bundle. Uninstalling the migration bundle permanently deletes the configuration and transaction field data preserved from that bundle.

See Installing the Migration Bundle for NetSuite CPQ Configurator and Migrating to NetSuite CPQ SuiteApps.

Frequently Asked Questions (4)

How do I load table data organized by sublist in a NetSuite CPQ Configurator script?
Call `getTable().loadContent()` with the `sublists` option set to `true`, such as `await getTable('TABLE_CODE').loadContent({ sublists: true })`. The returned table data is organized by sublist for processing or display.
Can I omit the `sublists` option when using `loadContent()`?
Yes. The option defaults to `false`, so you can omit it when you do not need the table data organized by sublist. Set it to `true` when you do need that organization.
Why use `loadContent()` with `sublists: true` instead of `getData()` with `loadapi: true`?
The article recommends the `loadContent()` approach because it significantly improves table-loading performance compared with the traditional `getData()` method using `loadapi: true`. This can be especially useful when working with large amounts of table data.
When migrating from the NetSuite CPQ Configurator bundle to the SuiteApp, when should I install the NSCPQ Bundle Migration bundle, and can I remove it afterward?
Update the CPQ Configurator bundle to its latest version, then install the public, managed NSCPQ Bundle Migration bundle before exporting bundle data. Keep it installed after migration so you can continue editing existing configured items; uninstalling it permanently deletes the configuration and transaction field data it preserved. This step does not apply to NetSuite CPQ Guided Selling.

Weekly Update History (1)

NetSuite CPQadded

Added the following entries: Create Template-Based Assemblies with Independent BOMs Clear Single-Row QTables

View Oracle Docs
Source: Organize Table Data by Sublist Using Scripts — Oracle NetSuite Help Center. This article was generated from official Oracle documentation and enriched with additional context and best practices.

Was this article helpful?

More in NetSuite CPQ

View all NetSuite CPQ articles →