Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| AccountSupportsSuiteAnalyticsConnect | Specifies whether SuiteAnalytics Connect is enabled for the authenticated account. |
| AggregateColumnMode | Specifies how aggregate columns, which consolidate data from child collections, are handled. This property applies only when Schema is set to SuiteTalk. |
| ApplicationId | Specifies the Application ID required by NetSuite for API requests as of version 2020.1. |
| ConnectionLifeTime | Specifies the maximum lifetime of a connection in seconds. When the specified time elapses, the provider closes the connection. |
| CustomFieldPermissions | Specifies a comma-separated list of custom field permissions to use when retrieving metadata. Overrides the binary behavior of IncludeCustomFieldColumns , allowing selective inclusion of custom fields based on permissions. |
| IncludeChildTables | Specifies whether to display child tables. |
| IncludeCustomFieldColumns | Specifies whether to include custom fields as columns in tables. |
| IncludeCustomListTables | Specifies whether to include tables based on custom lists. |
| IncludeCustomRecordTables | Specifies whether to include tables based on custom record types. |
| IncludeLongTextColumns | Specifies whether long or rich text custom fields should be included in the schema. |
| IncludeReferenceColumns | Specifies a comma-separated list of columns to include when retrieving data from fields that reference other records. |
| MaximumConcurrentSessions | Specifies the maximum number of concurrent sessions available for use in the connection. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| NetsuiteDateFormat | The preferred date format set in NetSuite UI. |
| NetsuiteLongDateFormat | The preffered long date format set in NetSuite UI. |
| NetsuiteMetadataFolder | Specifies the directory path for downloading metadata files from NetSuite. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| Pagesize | Specifies 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. Requires UseConnectionPooling=True. |
| PoolMaxSize | Specifies the maximum number of connections allowed in the connection pool. |
| PoolMinSize | Specifies the minimum number of connections to be maintained in the connection pool at all times. |
| 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. |
| PreferredDateFormats | A semicolon separated string containing a list of DateTime formats which should be tried when parsing DateTime values. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns, expressed as a string in the format 'TableName=ColumnName;TableName=ColumnName'. |
| Readonly | Toggles read-only access to NetSuite from the provider. |
| ReportDoublesAsDecimal | Specifies whether double values should be reported as decimals. |
| RequestMemorizedTransactions | Specifies whether to include 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. This property is only required in environments where the standard licensing method is unsupported or requires a runtime key. |
| SuiteQLDateFormat | Specifies an optional override for the default Date format. |
| SuiteQLDatetimeFormat | Specifies an optional override for the default Datetime format when retrieving data with SuiteQL. |
| SuiteQLDatetimeFormula | Specifies an optional override for the formula used when filtering on date fields in SuiteQL queries. |
| Timeout | Specifies the number of seconds an operation can run before it times out and is canceled. |
| UseAsyncServices | Specifies whether to use asynchronous services for inserting, updating, and deleting records. |
| UseConnectionPooling | Enables the connection pooling feature, which allows the provider to reuse existing connections instead of creating new ones for each request. |
| UseInternalNamesForCustomizations | Specifies the mode used to control whether internal names or label names are used for custom records and fields. By default, internal names are used for both tables and columns. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |
| UserTimezoneOffset | Specifies the user's timezone offset as configured in NetSuite. This setting ensures that Date and Time values are displayed correctly based on the user's NetSuite preferences. |
| UseSimpleNames | Specifies whether or not simple names should be used for tables and columns. |
| UseUpserts | Specifies whether an INSERT operation should perform an upsert by checking the ExternalId. |
| WebServiceHost | Specifies an optional override for the NetSuite web service host, such as webservices.na1.netsuite.com. |