TypeDetectionScheme Parameter (Connect-Smartsheet Cmdlet)
Determines how to determine the data types of columns.
Syntax
Connect-Smartsheet -TypeDetectionScheme string
Possible Values
None, RowScan, ColumnFormatData Type
cstr
Default Value
"RowScan"
Remarks
None | Setting 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. |
RowScan | Setting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. |
ColumnFormat | Setting TypeDetectionScheme to ColumnFormat will report the data type based on the format of the column. |