Suggestion - ability to import .SQL or .txt files in Execute Query activity.
Let me explain…
In my company if RPA Developer make queries which involves big data tables it is necessary that these queries would be reviewed by Database engineers. Also, if some error occurred with getting an incorrect data, other department should be capable of checking what queries robot have executed.
All of this requires RPA developer to Copy paste queries and store them inside Robot internal files to be easily accessed by other people and this is of course increases the time needed to check if these queries are up to date.
My idea is that Execute Query/ Execute Non-Query should have an option to import file as a Query. That way we can have Query stored not inside the studio, but in some folder as a text. This also helps debugging as You do not need to copy text from inside UiPath Studio, debug in SQL Management Studio and then paste it again in UiPath Studio.
This can be partially done by creating workflow where You pass the file location and read the text, then replacing this arguments with imported arguments but if Your arguments contains symbols like – ’ " etc. and it is coded in the text and not passed as Parameters You will get an SQL error.
Also, if I want to create generic activity for all queries myself, I have set how many in_Arguments this activity should have and this is not possible if I want to create the same workflow for all queries I execute.