Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| AccountSupportsSuiteAnalyticsConnect | A boolean indicating if Connect Service Feature is enabled for the authenticated account. |
| AggregateColumnMode | Indicating how aggregate columns should be treated. |
| ApplicationId | As of version 2020.1, requests to NetSuite require an application ID. |
| ConnectionLifeTime | Specifies the maximum lifetime of a connection in seconds. When the specified time elapses, the provider closes the connection. Set to 0 or leave empty for no time limit. |
| CustomFieldPermissions | A comma separated list of custom field permissions that gives you more control than IncludeCustomFieldColumns . |
| IncludeCustomFieldColumns | A boolean indicating if you would like to include custom field columns. |
| IncludeCustomListTables | A boolean indicating if you would like to use tables based on custom lists. |
| IncludeCustomRecordTables | A boolean indicating if you would like to use tables based on custom record types. |
| IncludeLongTextColumns | A boolean indicating if you would like to support long or rich text custom fields. |
| IncludeReferenceColumns | A comma separated list representing the columns to include when retrieving data from a field representing a record reference. |
| MaximumConcurrentSessions | The maximum number of concurrent sessions available for use in the connection. |
| MaxRows | Specifies the maximum rows returned for queries without aggregation or GROUP BY. |
| NetsuiteDateFormat | The preferred date format set in NetSuite UI. |
| NetsuiteLongDateFormat | The preffered long date format set in NetSuite UI. |
| Other | Specifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties. |
| Pagesize | The number of results to return per page from NetSuite. |
| PoolIdleTimeout | Specifies the maximum idle time, in seconds, that a connection can remain in the pool before being closed. |
| PoolMaxSize | Specifies the maximum number of connections allowed in the connection pool. The default value is 100. Set to 0 or a negative value to disable pooling. |
| PoolMinSize | Specifies the minimum number of connections maintained in the connection pool. The default value is 1. |
| PoolWaitTime | Specifies the maximum number of seconds a connection request waits for an available connection in the pool. If the wait exceeds this time, an error is returned. The default is 60 seconds. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns. Use the format 'TableName=ColumnName;TableName=ColumnName'. The default is an empty string, which disables this property. |
| Readonly | Toggles read-only access to NetSuite from the provider. |
| ReportDoublesAsDecimal | Indicates if doubles should be reported as decimal. |
| RequestMemorizedTransactions | A boolean indicating if you want to request memorized transactions when retrieving transactions from NetSuite. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. Use this property only in environments where the standard licensing method is unsupported or requires a runtime key. |
| SuiteQLDateFormat | An optional override for Date format. |
| SuiteQLDatetimeFormat | An optional override for Datetime format. |
| SuiteQLDatetimeFormula | An optional override for formula used when filtering on date field types. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UseAsyncServices | A boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting. |
| UseConnectionPooling | Enables the connection pooling feature, which allows the provider to reuse existing connections instead of creating new ones for each request. |
| UseInternalNamesForCustomizations | A enum indicating whether you want to use internal names or labels for customizations. The default behavior of the NetSuite displays records and columns with their internal names. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file. |
| UserTimezoneOffset | Your user timezone offset as defined in your NetSuite preferences under Home --> Preferences --> Time Zone. Ex: EST. |
| UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |
| UseUpserts | A boolean indicating if you would like to perform an upsert when an INSERT operation is used. |
| WebServiceHost | An optional override for the web service host such as webservices.na1.netsuite.com. |