Tables
The driver models the data in Smartsheet as a list of tables in a relational database that can be queried using standard SQL statements.
CData JDBC Driver for Smartsheet Tables
Name | Description |
Info_Attachments | Query Smartsheet Attachments. Attachments can exist on a Comment (i.e., within a Discussion), on a Row, or on a Sheet. |
Info_Columns | Query Smartsheet Columns in a Sheet or Report. |
Info_Comments | Query Smartsheet Comments in a Discussion. |
Info_Discussions | Query Smartsheet Discussions. A Discussion is a collection of one or more Comments. A Discussion can exist on a Row or a Sheet. |