Excel Add-In for Dynamics 365 Finance and Operations

Build 21.0.7930

Miscellaneous

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


PropertyDescription
CrossCompanyWhether to pull data for all companies or just the user's default company.
CustomUrlParamsThe custom query string to be included in the request.
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.
ReadonlyYou can use this property to enforce read-only access to Dynamics 365 Finance and Operations from the provider.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UseClientSidePagingWhether or not the CData ADO.NET Provider for Dynamics 365 Finance and Operations should use multiple threads with client side paging.
UseDynamicStoredProceduresA boolean indicating if dynamic stored procedures should be exposed.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930