in the following, I will describe my situation/problem and where I currently stuck.
I want to connect to a SQL Database and execute a Query to get values from specific columns. The columns are OrderID, Name, Format, Amount, DeliveryDate. There is also a WHERE Statement which has to be dynamic and requires an input (a specific OrderID).
The values of the columns should be assigned to output arguments since they should be displayed later on in the UiPath App as well as the input argument (Order ID).
So, I already created the following activities:
- Connect to Database
- Execute Query
2.1 “SELECT OrderID, Name, Format, Amount, DeliveryDate FROM dbase1 WHERE OrderID = @orderId”
With “@orderId” as a input parameter
With “dt_output” as the Output DataTable
How do I assign the columns into output arguments, so that I later can drag them to empty lables on UiPath Apps?
The workflow works fine so far since I controled it by using Write Range Activity and saved the output DataTable to an excel sheet.
Thanks for any help!