Migrating Google Sheets Pipelines from V3 to V4
Google Spreadsheet API is migrating from v3 to v4 API as Google announces sunsetting the v3 API on June 8, 2021. This document explains the impact on your existing Pipelines that have the Google Sheets Snaps.
Snap Setting Changes
Check box for Batch Write field in the Google Sheets Writer Snap is removed as it is a default setting for v4.
Sheet API drop-down field in the Google Sheets Browser Snap to select v3 and v4 is removed.
Functional Changes
Works in Ultra Pipelines.
Inputs without any format restrictions are accepted when the expression toggle is enabled and a Pipeline parameter is provided for the following fields:
Number of retries
Retry interval
Read timeout in seconds
Connection timeout in seconds
For an expression input, the value is evaluated and accepted if it meets the expression criteria; if not, then the default value is used.
Known Issue
A bug in the Google Sheets endpoint does not allow the use of a colon ':' in worksheet names; hence, using a colon is not supported.
Impact on Existing Pipelines
As the Sheet API drop-down field in the Google Sheets Browser Snap to select v3 and v4 is removed, the Spreadsheet Snaps themselves will execute fine but since the Snap output document format changes between v3 and v4, downstream mappings that expects the old document format will need to be updated in all such pipelines.
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.