How to get data form SQL query row by row

Help Activities
, , ,
1

Hi all,

I want to get the SQL data row by row with the specific column name and write the data into the google sheet.

Thanks

2

@pavadharani_p

Use Connect activity and configure your connection string and test the connection

Once done use Execute query activity as below

image
image1775×348 21.7 KB

This will store to a datatable

Now use gsuite activities to write to google sheets

https://docs.uipath.com/activities/docs/google-sheets

Hope this may help you

Thanks

3

Hi @pavadharani_p

  • Install the UiPath.Database.Activities (Manage packages)
  • Use Connect Activity - test the connection
  • Use Execute Query Activity output is stored in “query_Dt” a data table.

Refer to the Link:

Here is the sample workflow
Main.xaml (6.0 KB)

Regards
Gokul

4

IMG_20210802_201936
IMG_20210802_201936899×470 100 KB

I want get Markout and totaloffer of row one and paste to Google sheet in uipath

5

Hi @pavadharani_p

Here is the SQL Query

  • Use in Execute Query Activity
    Select Markout and totaloffer from Table_Name

Refer to the Link:

6

Hi @pavadharani_p

You can write query as

select MARKOUT, TOTAL_ORDER FROM table_name
this will give you all row with two columns

select top(1) MARKOUT, TOTAL_ORDER FROM table_name
this will give you first row

7

Hi @ermanoj3101

I am not supposed to change the query from the above table I have to take column value of markout and totol_order row by row and paste in google sheet in specific column

8

One row value in one column D and second in column I and so on