hii guys,i just struck in the middle of the process, my query is initially i scraped data from the eCommerce website and stored it in a datatable which contains 3 columns and used for each loop,in body section i used assign activity to store each row value to three variables say product,url,price. i tried to add each row value to the database it worked but only the variables are added to it not the values
Could you please show me how you assigned values ?
i assigned each row value to the variables product,url,price.and i placed those three variables in the values place i execute non query.
Remove that single quotes for those variables and then try once.
@lakshman no its not working saying invalid column names
Try like this:
Could you please share your workflow with me. Need to check once.
@lakshman thanks for your time buddy,i got the output
In your database, What is the data type for product, price and url ? Is it string or not ?
And also product and price variables are Generic variables and change it to string and then try.
@lakshman hii i get the data from my datatable to database but it retrieved some rows and for some rows only variables names pasted
Please show me your Execute Query once.
Please follow below steps.
put that Connect activity outside of the loop and make it as first step.
Then read data from Excel file and use For Each Row activity to iterate that data.
ForEach row in DataTable - use Execute Non Query and pass insert query like this:
"INSERT into product(product,url,price) Values(’ “+row(“product”).Tostring+” ', ’ “+row(“url”).Tostring+” ', ’ “+row(“price”).Tostring+” ')"