Run Any SQL Query

Help Studio
1

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

2

@jpreziuso

Did you try with Execute Query activities?

image
image1247×344 21.3 KB

Thanks

3

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

4

@jpreziuso

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

Thanks

1 Like