Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings (when TypeDetectionScheme is set to RowScan; the default behavior).
| Smartsheet | CData Schema |
| TEXT_NUMBER (Text) | string |
| TEXT_NUMBER (Whole Number) | int (<2,147,483,647) or long (>2,147,483,647) |
| TEXT_NUMBER (Decimal) | float |
| CHECKBOX | bool |
| DATE | date |
| DATETIME | datetime |
| ABSTRACT_DATETIME | datetime |
| CONTACT_LIST | string |
| MULTI_CONTACT_LIST | string |
| PICKLIST | string |
| MULTI_PICKLIST | string |
| Symbols for CHECKBOX columns | bool |
| Symbols for PICKLIST columns | string |
For more information on Smartsheet data types, refer to Column Types from Smartsheet's API reference.