Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings 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. |
| 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. |
| PreferredDateFormats | A semicolon separated string containing a list of DateTime formats which should be tried when parsing DateTime values. |
| 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. |
| 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. |
| 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. |