Data Type Mapping
Data Type Mappings
The add-in 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.