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.
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:
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:
- Go to Customization > SuiteBundler > Search & Install Bundles.
- In Keywords, enter NSCPQ Bundle Migration.
- In the Name column, select NSCPQ Bundle Migration.
- 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?
Can I omit the `sublists` option when using `loadContent()`?
Why use `loadContent()` with `sublists: true` instead of `getData()` with `loadapi: true`?
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?
Weekly Update History (1)
Added the following entries: Create Template-Based Assemblies with Independent BOMs Clear Single-Row QTables
View Oracle DocsWas this article helpful?
More in NetSuite CPQ
- NetSuite CPQ Template Assemblies Get Separate BOMs
NetSuite 2026.2: CPQ Configurator 2.1.2 copies template BOMs for qualifying assemblies, allowing edits without changing the template.
- CSV Import Support for CPQ Product Configurations in NetSuite
CSV import for CPQ products in NetSuite 2025.2 enhances bulk management capabilities for product configurations.
- Configuring Items from the Customer Center in NetSuite 2026.1
In NetSuite 2026.1, users can configure items in the Customer Center by assigning roles to script deployments, enhancing transaction handling.
- Date Mask Feature for Checkbox and Radio Button in NetSuite CPQ
Date mask feature enhances Checkbox and Radio Button inputs in NetSuite CPQ 2026.1 for improved user experience.
Advertising
Reach NetSuite CPQ Professionals
Put your product in front of NetSuite experts who work with NetSuite CPQ every day.
Sponsor This Category