TDV Adapter for Smartsheet

Build 21.0.8137

Miscellaneous

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


PropertyDescription
HideFormattingCharactersSet to True if you want to hide currency symbols and percentage signs in numeric values. This will also convert these columns from varchar to double. Only works if TypeDetectionScheme is set to RowScan and at least the first RowScanDepth values for that column are convertable to double.
IgnoreRowsNotFoundIf set to false and any of the specified Row IDs are not found, no rows will be deleted, and a 'not found' error will be returned.
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 Smartsheet.
ReadonlyYou can use this property to enforce read-only access to Smartsheet from the provider.
ReportCompatibilityLevelControls whether new functionality, such as multi-contact data is returned as: Backwards-compatible, text format (level 0, default) Multi-contact data (level 1) Multi-contact data (report-compatible, level 2) Multi-picklist data (level 3) .
RowScanDepthThe maximum number of rows to scan to look for the columns available in a table.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
TypeDetectionSchemeDetermines how to determine the data types of columns.
UseFullFilePathsAsTableNamesWhether or not to include the full file path in the name of an exposed table or view, corresponding to a sheet or report.
UseSimpleNamesBoolean determining if simple names should be used for tables and columns.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137