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
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.
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 Spreadsheets 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.