Excel Add-In for NetSuite

Build 24.0.9060

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.


PropertyDescription
AccountSupportsSuiteAnalyticsConnectA boolean indicating if Connect Service Feature is enabled for the authenticated account.
AggregateColumnModeIndicating how aggregate columns should be treated.
ApplicationIdAs of version 2020.1, requests to NetSuite require an application ID.
CustomFieldPermissionsA comma separated list of custom field permissions that gives you more control than IncludeCustomFieldColumns .
IncludeCustomFieldColumnsA boolean indicating if you would like to include custom field columns.
IncludeCustomListTablesA boolean indicating if you would like to use tables based on custom lists.
IncludeCustomRecordTablesA boolean indicating if you would like to use tables based on custom record types.
IncludeLongTextColumnsA boolean indicating if you would like to support long or rich text custom fields.
IncludeReferenceColumnsA comma separated list representing the columns to include when retrieving data from a field representing a record reference.
MaximumConcurrentSessionsThe maximum number of concurrent sessions available for use in the connection.
MaxRowsLimits the number of rows returned when no aggregation or GROUP BY is used in the query. This takes precedence over LIMIT clauses.
NetsuiteDateFormatThe preferred date format set in NetSuite UI.
NetsuiteLongDateFormatThe preffered long date format set in NetSuite UI.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe number of results to return per page from NetSuite.
ReadonlyYou can use this property to enforce read-only access to NetSuite from the provider.
ReportDoublesAsDecimalIndicates if doubles should be reported as decimal.
RequestMemorizedTransactionsA boolean indicating if you want to request memorized transactions when retrieving transactions from NetSuite.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseAsyncServicesA boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting.
UseInternalNamesForCustomizationsA 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.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.
UserTimezoneOffsetYour user timezone offset as defined in your NetSuite preferences under Home --> Preferences --> Time Zone. Ex: EST.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.
UseUpsertsA boolean indicating if you would like to perform an upsert when an INSERT operation is used.
WebServiceHostAn optional override for the web service host such as webservices.na1.netsuite.com.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060