Data Type Mapping
Data Type Mappings
The connector maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| Smartsheet | CData Schema |
| Auto-Number | int |
| Checkbox | bool |
| Contact list | string |
| Created (Date) | datetime |
| Created By | string |
| Date | date |
| Dropdown List | string |
| Modified (Date) | datetime |
| Modified By | string |
| Symbols (Flag/Star) | bool |
| Symbols (Dropdowns) | string |
| Text/Number (Text) | string |
| Text/Number (Whole Number) | int (<2,147,483,647) or long (>2,147,483,647) |
| Text/Number (Decimal) | float |