Ignoring input errors in Analytic App

[pmiecz]

I have an app that tests whether user who runs it has access to certain data connections. In some scenarios some users will not be able to successfully connect to some data sources because of their permissions. Since those Inputs whose connections throw an error fail, is there a way to ignore those errors and run the remainder of the app?

[ArtApa]

Hi @pmiecz - You may choose not to run Inputs that will give you errors. Here is how you can organise it: https://community.alteryx.com/t5/Interactive-Lessons/Implementing-Conditional-Routing/ta-p/243117 

[pmiecz]

Hi @ArtSpa, because the whole purpose of the workflow is to check whether the user can or cannot access certain data sources, not being able to connect to a source is exactly what I'm logging. I should have added that the workflow runs fine as a standard workflow since the errors can be just ignored, but fails as an Analytics App.

[ArtApa]

Hi @pmiecz - I think trying to run into an error is not an ideal method. Would you like to consider reading metadata instead? You could use a service account to read permissions and then compare them against a user's credentials before going to the next step.

Here is an article on the topic, but you can easily replicate the same logic in Alteryx: https://sqlserverguides.com/sql-server-user-permissions/