Data ModelCData JDBC Driver for Smartsheet 2019 - Build 19.0.7354
The CData JDBC Driver for Smartsheet 2019 models the Smartsheet API as relational tables, views, and stored procedures. Views are tables that cannot be modified.
Some API objects, like Workspaces, Folders, etc., are indexed with 'Info_'. These are defined in schema files, which are simple, text-based configuration files.
You can work with all the Sheets and Reports in your account using the driver. In addition to providing information about the static tables, the data model illustrates a sample of what your Sheets and Reports might look like. The actual data model will be obtained dynamically based on your user credentials.
When you connect, the driver gets the list of tables and the metadata for the tables by calling the appropriate Web services. Any changes you make to your Smartsheet account, such as adding a new table, adding new columns, or changing the data type of a column, will immediately be reflected when you connect using the driver.
Stored Procedures are function-like interfaces to Smartsheet. They can be used to search, update, and modify information in Smartsheet.
API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.