Ignoring input errors in Analytic App

Question

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?

Analytics App.PNG

ArtApa · Answer

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/

pmiecz · Answer

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 · Answer

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