TDV Adapter for Smartsheet

Build 21.0.8137

Data Type Mapping

Data Type Mappings

The adapter 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

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137