We use the deprecated Google Sheet tools and want to replace them with the Google Drive tools.
If we use the older (non-AMP) versions we are able to write to My Drive without difficulty. But what we need to do is write to a Shared Google Drive, so we need one of the newer (AMP) versions.
Using the latest v1.2.1 of the Google Drive Output tool we can neither write to a Shared Google Drive nor write to My Drive either. We consistently receive a pair of errors:
'Internal error: Failed to read port assignment'
'All incoming anchors closed, but plugin has errors'
I've experimented with just having AMP turned on and also having AMP turned on with Engine compatibility mode as well. I've tried three different ways of connection, via DCM, via the Web Browser option (with and without 'Connection through Own Google App checked').
The Google Drive Input tool is no better - old versions can read from My Drive, but the newer versions that should be able to read from My Drive and Shared Drive are unable to do so, with the single error:
'Internal error: Failed to read port assignment'
Designer is 2022.1.1.42604, it doesn't make any difference running it as an Admin. Tried deinstalling and reinstalling the tools multiple times, read every article I can find that mentions either of the errors....It doesn't make any difference to the output tool whether it is being passed something from a database or just from a file or Text Input tool. It doesn't matter whether you try and output a .xlsx file or a google sheet etc, whether you choose to rename or overwrite or append....there doesn't seem to be any combination of options which will work.
Has anyone encountered this and been able to resolve it?
