Input Tool - Macro unable to update encrypted password

[farrelj3]

We have a workflow that calls a macro - and passes in the connect string and password as parameters to be used by an input tool.  The input tool connects to a redshift database.

The macro action tool is configured to replace the connection string using "Update Raw XML with Formula" option. The formula does a replace of our connection to dev -with the connection that was passed in.

The password is the encrypted password that we get from the input tool using the XML view and the <passwords> field.  The action tool does an "Update Value (Default)".

This was working perfectly for us in a 2020 version of alteryx, but since upgrading the server and the designer to 2021.4 the password is NOT getting replaced.  The connect string is getting replaced.  This fails now on both designer and server.

Did something change about how the password is encrypted and stored?  Or did rules change about how macros can update passwords?

Thank you for any insight. 

Jim

[TonyaS]

My guess is that this is due to intentional Security related changes since 2020. I am asking around to see if we can confirm that. 

[farrelj3]

Hi any word on this issue?  thanks.

[TonyaS]

One of my colleagues is reaching out to you directly for more information. 

[farrelj3 · Accepted solution]

We replace connection strings using the action tool.  The connection is replaced with a “Update Raw XML with Formula” - Replace function.  The password is replaced with an “Update Value (Default)”.

We pass into the macro a connection string and the encrypted password.  This code is allow us to switch between server based on which control is active.

Inside of the macro, we use the Action Tool to replace the connection string.  This WAS NOT working if we highlighted the “input Data (1)” line.  That seems to be the root of the problem.  If we highlight the “File – value” the replacements occur as expected.

This worked fine under version 2020.3 – it broke when we upgraded to 2021.4.

Our fix – is going into version 2020.3 – and update the highlighted row to all be the “File – value” row.

[Raj_007]

Hi, I am looking for similar solution - i just need to replace the password in dynamic input tool - could you please ping me