Data Model
The CData Python Connector for Smartsheet models the Smartsheet data as an easy-to-use SQL database.
Tables
The data model of the connector is dynamic. This means that, when you connect using the connector, any changes you make in the Smartsheet UI, such as adding a new table, adding new columns, or changing a column's data type, are automatically included in the schema of the connector.
However, some tables and views, such as workspaces and folders, are static. These are defined in schema files, which are simple, text-based configuration files. The static tables and views are prefixed with 'Info_'.
Common tables include:
| Table | Description |
| Info_Sheets | Explore detailed metadata and structure of Smartsheet sheets, including their components like columns, rows, and attachments. |
| Info_Rows | Retrieve detailed row data, including cells, discussions, and attachments, for enhanced row-level analysis. |
| Info_Columns | Retrieve metadata and properties of columns in Smartsheet sheets or reports, essential for understanding sheet structures. |
| Info_Cells | Explore individual cell data in Smartsheet rows, offering granular insights into sheet contents. |
| Info_Attachments | Retrieve detailed information about Smartsheet attachments, which can be associated with comments, rows, or sheets, providing a comprehensive view of file dependencies. |
| Info_Comments | Access comments within discussions in Smartsheet, providing insights into collaboration history. |
| Info_Discussions | Analyze discussion threads, including comments, tied to specific rows or sheets for better communication tracking. |
| Info_Users | Query user data within an organization for administrative and reporting purposes. |
| Info_Workspaces | Access workspace-level details, including sheets and folders, for better organizational insights. |
| Info_Folders | Explore folder structures in Smartsheet, including user-level folders and workspace organization. |
| Info_Reports | Query Smartsheet reports, providing insights into custom aggregated data across sheets. |
| Info_Templates | Retrieve Smartsheet template information to streamline the creation of standardized sheets. |
| Info_Groups | Retrieve group information for enhanced user management and role-based permissions in Smartsheet. |
| Info_Contacts | Query Smartsheet user contact details, facilitating management of personal and shared connections. |
| Info_Home | Access items available on the Smartsheet Home tab, offering a centralized view of user-permissible objects. |
| Info_Favorites | Retrieve a user's favorite items in Smartsheet, helping prioritize frequently accessed content. |
| Info_ServerInformation | Access Smartsheet server information and application constants, useful for API integrations. |
| Info_CellHistory | Access the historical changes of specific cells in Smartsheet, enabling detailed audit and tracking capabilities. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including managing sheets and attachments, and retrieving OAuth credentials.
API Restrictions
The connector uses the Smartsheet API to process supported filters. The connector processes other filters client-side within the connector.