Update Your Smartsheet Connections Before June 3rd, 2026

Summary

Smartsheet is permanently retiring a set of older API endpoints on June 3rd, 2026. CData Smartsheet connections using the default setting UseLegacyAPI=True rely on these endpoints and will experience significant failures after this date.

Affected Products

• CData Drivers for Smartsheet (all editions, direct and OEM)
• CData Sync (Smartsheet connections)
• CData Connect AI (Smartsheet connections)

Affected Customers

All customers on driver version 2025 or below using the default connection property UseLegacyAPI=True.

What Breaks on June 3rd

If you have not updated to build v25.0.9644 or later and set UseLegacyAPI=False, the following will stop working:

1. Dynamic table listing — Sheets and reports will no longer be automatically exposed as tables and views. Any integration that relies on the driver dynamically surfacing your Smartsheet data as queryable objects will stop working.
2. Info_Home table — The Info_Home table will be removed by Smartsheet. Migrate to Info_Objects (see migration notes below).
3. Hierarchy navigation for Info_ tables — The following tables will fail for any query that traverses the Smartsheet folder and workspace hierarchy: Info_Sheets, Info_Reports, Info_Dashboards, Info_Templates, Info_Folders.

What You Need to Do

Step 1 — Update Your Driver

Download and install CData Smartsheet driver build v25.0.9644 or later from: https://www.cdata.com/drivers/smartsheet/download/

• Any earlier version below v25.0.9644: You must upgrade before proceeding.
• Version 2025 (build v25.0.9644 or later): Proceed to Step 2.

Step 2 — Update the Connection Property

In your Smartsheet connection settings, set:

UseLegacyAPI=False

Product-Specific Instructions

CData Drivers for Smartsheet

1. Download and install build v25.0.9644 or later from https://www.cdata.com/drivers/smartsheet/download/.
2. In your connection settings, set UseLegacyAPI=False.

CData Sync (Smartsheet Connections)

1. Download the latest Smartsheet connector (build v25.0.9644 or later) from CData Sync.
2. Set UseLegacyAPI=False in your Smartsheet connection properties.

CData Connect AI (Smartsheet Connections)

1. Open your Smartsheet connection settings in CData Connect AI.
2. Set UseLegacyAPI=False.

Migration Notes

Info_Home → Info_Objects

If you have queries or pipelines referencing Info_Home, rewrite them to use Info_Objects. The Info_Objects table exposes the following columns across all Smartsheet object types in a single view:

• Id
• Name
• AccessLevel
• Permalink
• CreatedAt
• ModifiedAt
• ResourceType

Note: Info_Objects always requires hierarchy navigation. Unfiltered queries against Info_Objects will traverse your full Smartsheet workspace structure.

DDL Statements

DDL statements for managing Smartsheet objects are no longer supported directly. Migrate to the following stored procedures:

• CREATE TABLE → CreateSheet stored procedure
• ALTER TABLE → UpdateSheet stored procedure
• DROP TABLE → DeleteSheet stored procedure

ImportFile Stored Procedure

The ImportFile stored procedure now requires either a FolderId or WorkspaceId to be specified when executing the procedure.

Schema Changes

Some columns across Info_Sheets, Info_Templates, Info_Workspaces, Info_Folders, Info_Reports, Info_Dashboards, and share tables will be removed and will return NULL. Review any queries or pipelines that depend on specific column availability in these tables.