Custom Columns, Lists, and Records in the Connect Service
Support ends for the NetSuite.com data source in 2025.1, and it will be removed in 2026.1. Start transitioning to the NetSuite2.com as soon as possible to avoid disruption when this change occurs.
To work with the Connect Service and custom records, see the following examples and considerations:
-
Considerations for NetSuite.com
General Considerations for Connect
The following considerations apply to both data sources:
Custom Field Limitations
Due to an internal limitation, queries over SuiteAnalytics Connect that have more than 1000 columns only work if you retrieve 1000 columns or less in the query. For example, if the Transactions table has more than 1000 columns due to the number of custom fields that have been added to the Transaction record type, attempting to query the table using the 'Select * From' construct results in the following error: 'Error: Could not find any column information for table:transactions'.
You may also see this error when joining multiple tables and trying to retrieve all fields.
To query over a table with more than 1000 columns, you must enumerate the specific columns that you want to retrieve or, if you have to use the 'Select * From' construct, you must deactivate some of the custom fields that have been added to the table so that there are 1000 columns or less.
Newly Created Custom Records
If you are using Connect and at the same time you create a new custom table or column using the same account, the newly custom record is not considered yet in your queries. After you created the custom table or column, you need to log out and open a new Connect session.
Considerations for NetSuite2.com
For details about general considerations for NetSuite2.com, see the following: