Excel Add-In for Microsoft Dynamics 365

Build 22.0.8462

Miscellaneous

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


PropertyDescription
AllowDuplicateRecordsIndicates if the driver should check the configured duplicate detection rules.
CrossCompanyWhether to pull data for all companies or just the user's default company.
CustomUrlParamsThe custom query string to be included in the request.
IncludeFormattedValuesIndicates if columns that hold formatted values should be exposed.
IncludeLookUpLogicalNameIndicates if the referenced entity name for a LookUp field should be exposed.
IncludeNavigationPropertiesA boolean indicating if navigation properties should be included in the column listing.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
PagesizeThe maximum number of results to return per page from Microsoft Dynamics 365.
ReadonlyYou can use this property to enforce read-only access to Microsoft Dynamics 365 from the provider.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseClientSidePagingWhether or not the CData ADO.NET Provider for Microsoft Dynamics 365 should use multiple threads with client side paging.
UseDynamicStoredProceduresA boolean indicating if dynamic stored procedures should be exposed.
UserDefinedViewsA filepath pointing to the JSON configuration file containing your custom views.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462