Specifies the number of rows to scan when dynamically determining column metadata for a table.

Data Type

string

Default Value

"1000"

Remarks

This property applies only when Schema is set to SuiteQL. Since SuiteQL lacks a dedicated metadata service for standard tables and fields, row scanning helps determine which columns are available based on user permissions and NetSuite company settings.

• NetSuite does not return null columns, so scanned tables may not have complete column information.
• SuiteQL has a maximum pagesize of 1,000. Setting RowScanDepth higher than 1,000 requires multiple page requests.
• Setting this property to 0 disables row scanning, meaning all columns are listed regardless of availability.

There is no enforced maximum value for this property. However, values greater than 100,000 may experience degraded performance during row scanning. Retrieving more than 100,000 rows requires multiple operations, which may cause NetSuite to internally process many more rows than specified. Additionally, row scans larger than 100,000 rows are only supported for views with defined key columns. Views without key columns are limited to scans of 100,000 rows. It is recommended to use values above 100,000 only when necessary to retrieve missing metadata.

Adjust this property based on performance needs and column availability requirements.