The CData SSIS Components for Smartsheet models the Smartsheet API as relational tables, views, and stored procedures. Views are tables that cannot be modified.

Static Tables

Some API objects, like Workspaces, Folders, etc., are indexed with 'Info_'. These are defined in schema files, which are simple, text-based configuration files.

Dynamic Tables

You can work with all the Sheets and Reports in your account using the component. 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 component 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 component.

Stored Procedures

Stored Procedures are function-like interfaces to Smartsheet. They can be used to search, update, and modify information in Smartsheet.

API Restrictions

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.