on 10-17-2021 08:25 AM - edited on 01-06-2022 08:40 AM by MariaW
Google Sheets v.3.0 is failing with a 401 Unauthorized error when uploading the workflow to the gallery or running the same workflow on another machine. The issue is related to encrypted values in the XML.
Google API: Retrieve Access Token (138): Google API: HTTP/1.1 401 Unauthorized Date: Tue, 28 Sep 2021 11:51:07 GMT Pragma: No-cache Expires: Mon, 01 Jane 1990 00:00:00 GMT Cache-Control: no-cache, no-store, max-age=0, must-revalidate Google API: Retrieve Access Token (138): Tool#14: Parse at char(1): Unknown variable "token_type" (Expression#1)
This is a defect (TPM-463) This is likely due to the type of encryption used by the tool which is not carried over when running workflows on another machine.
@miteshnarottam has there been any progress on this. It is creating major issues and effort related to some server migrations for us.
This is laughable. It's been a year and still not resolved. Found this issue after half an hour of debugging.
So glad I'm migrating away from this product to dbt and more scalable analytics solutions. But it was a nice starting point for a noob like me.
This error persists on Server 2021.3.2. The Community Gallery should be updated to link this defect so users don't implement the new tool and this line should be revised under the current tool
Is there any update on the resolution? Its difficult to manage workflows with Google Sheets as we are not able to publish from dev server to prod.