Cmdlets for Smartsheet

Build 24.0.9062

TypeDetectionScheme Parameter (Connect-Smartsheet Cmdlet)

Determines how to determine the data types of columns.

Syntax

Connect-Smartsheet -TypeDetectionScheme string

Possible Values

None, RowScan, ColumnFormat

Data Type

cstr

Default Value

"RowScan"

Remarks

NoneSetting TypeDetectionScheme to None will return all columns as the string type. Note: Even when set to None, the column names will still be scanned when Header is set to True.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.
ColumnFormatSetting TypeDetectionScheme to ColumnFormat will report the data type based on the format of the column.

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