Best Of

Great question, @Mike B

I checked the official Smartsheet documentation here:

• Deprecation Process
• API Changelog

Based on the deprecation process and the most recent changelog, here’s what this means:

Impact on Power BI / Power Automate Smartsheet Connectors:

• If you're using the official Smartsheet connectors in Microsoft tools (Power BI, Power Automate, Power Apps), they should continue to work as long as both Smartsheet and Microsoft update those connectors before the sunset date (Feb 9, 2026).
• It’s very likely they’ll be updated, since they rely on common endpoints and both companies have strong incentives to maintain compatibility.
• However, if you’re calling the Smartsheet API directly using HTTP actions in Power Automate (or custom code), check if you’re using deprecated parameters like includeAll, unlimited pageSize values, or relying on totalCount/totalPages, and migrate to the new token-based pagination methods.

@Lee Joramo – Regarding SDKs & Sample Code:

• Smartsheet typically updates SDKs during deprecation periods to support new API requirements, so SDK updates are likely.
• For the includeAll → token-based pagination migration, sample code should be available in the API documentation and SDK GitHub repos as new patterns roll out.
• Token pagination basics: request the first page with paginationType=token, then use the lastKey from each response to get the next page until no lastKey is returned.

My Recommendations:

Audit your setup now:

• Connector users: Monitor Microsoft’s Power Platform release notes for Smartsheet connector updates.
• HTTP/Custom users: Check your endpoints against the Aug 4, 2025, deprecation list.

Start planning now:

• Replace includeAll=true with token-based pagination loops.
• Ensure pageSize ≤ 10,000 for endpoints still supporting offset pagination.
• Remove dependencies on totalCount / totalPages (they’ll return -1 post-sunset).
• Note: /sights (dashboards) will switch to token pagination soon, but it’s not active yet.

Test early:

• Don’t wait until Feb 2026—use the deprecation period to test and refine.
• Offset pagination may still work for now, but token pagination is the safest long-term choice.

Bottom line: Most users won’t see major disruption, but review your setup now so you’re ready before the sunset date. Keep monitoring the API Changelog for updates!