Update the user name and password frequently using Macros

[Dinesh]

Hi,

I have a requirement of updating a password instead of hard coding it when using to connect to a share point using Alteryx.

We want to schedule the work flow on a daily basis and we dont want to open each workflows and update the password(share point list input tool ) when the password changes.

So i need your thoughts on how to implement the solution without our workflows failing and where we can update the password in one location that will get captured in the share point list input tools.

Thanks,

Dinesh

[KaneG · Accepted solution]

Hi @Dinesh,

You can wrap your module in a macro and then have a governing workflow that has an input tool pointing to where the password is stored, that then updates the macro with the current password.

Kane

[diksha1107]

Hi @KaneG ,

Thank you for the answer.

But can you please explain it, how to implement the solution.

[KaneG]

So the critical info is:

• A location that stores the User/Pass
• The workflow that needs to be run, be converted to a macro
• Create a workflow that connects to the location with the User/Pass and passes that in to the macro

I don't have an example as it's more of an idea. If the above is not clear, can you please indicate which part?

[diksha1107]

Thank you so much for the help @KaneG .