Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| Header | Specifies whether the first row of the data is treated as column headers or not. |
| HideFormattingCharacters | Specifies whether to hide formatting characters, such as currency symbols and percentage signs, in numeric values. When enabled, numeric columns are converted from varchar to double. |
| IgnoreRowsNotFound | Specifies whether the deletion operation should proceed if any specified Row IDs are not found. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| Pagesize | Specifies the maximum number of records per page the provider returns when requesting data from Smartsheet. |
| Readonly | Toggles read-only access to Smartsheet from the provider. |
| ReportCompatibilityLevel | Specifies the level of compatibility for the returned data, determining the format and functionality provided in query results. |
| RowScanDepth | The maximum number of rows to scan to look for the columns available in a table. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| TypeDetectionScheme | Specifies the method used to determine the data types of columns, such as by scanning rows, analyzing column formats, or treating all columns as strings. |
| UseFullFilePathsAsTableNames | Specifies whether table and view names corresponding to sheets and reports should include the full file path or only the file name. |
| UseIdAsTableName | Specifies whether sheet and report IDs, rather than their names, are used as table identifiers. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |
| UseSimpleNames | Specifies whether or not simple names should be used for tables and columns. |
| ValueSource | Specifies whether the driver retrieves cell values from the Value fields, the DisplayValue field, or automatically selects based on availability. |