TDV Adapter for Smartsheet

Build 22.0.8462

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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462