I am looking for suggestions on the best way to take in any SQL query, run it, and output the result to a CSV. I know UiPath has different activities for different queries and has different ways to run a stored procedure. Does anybody have a good idea on how to create a generic and universal workflow to run any SQL query? Thanks
Did you try with Execute Query activities?
Yes I have used Execute Query before and I know it works. But I know different queries have to be run different ways in UiPath. So I was looking for a way to universally be able to run any query that comes in. Maybe a try/catch or a switch statement, but now sure how to set it up
If you know for which case you need to run the particular query
then you can use Switch Statement
In this way you can place your multiple queries and based on the input it will run
Mark as solution if this helps