How to pass insert query to datatable

Help
1

hi guys,

this my query:
INSERT INTO demo.ewb_details (eway_bill_no,nic_eway_bill_date,user_gstin,nic_valid_upto,transportation_mode,nic_actual_distance,supply_type,sub_supply_type,document_type,document_no,document_date,from_gstin,from_address1,to_address1,to_gstin,taxable_value,cgst_value,sgst_value,igst_value,cess_value,fu_9,fu_7,fu_4,transporter_id,transporter_name,transportation_document_no,transportation_document_date,vehicle_no,active,is_active,load_id,udid,ewb_details_batch_id,user_name,gstin_id,company_id,initiated_by,created_by,updated_by,created_date,updated_date,nic_document_status_created_by,nic_eway_bill_date,nic_valid_upto)values (‘801004310210’,‘2018-05-03 12:37:00’,‘18AACCS0144E1ZS’,‘2018-05-18 23:59:00’,‘Road’,‘1430’,'Outward ',‘Supply’,‘Tax Invoice’,'G0082 ‘,‘2018-05-03’,‘18AACCS0144E1ZS’,‘GSTIN : 18AAC CS014 4E1ZS M/S GLAXO SMITHKLINE CONSUMER HEALTHCARE LTD. , ASSAM :: Dispatch From :: Industrial Area Mangaldai,ASSAM-784125’,‘GSTIN : 18AAC CS014 4E1ZS M/S GLAXO SMITHKLINE CONSUMER HEALTHCARE LTD. , ASSAM :: Dispatch From :: Industrial Area Mangaldai,ASSAM-784125’,‘21AACCS0144E1Z5’,‘3582381.6’,‘0’,‘0’,‘644828.69’,‘0’,‘0’,‘0’,‘4227210.29’,‘18AADCP1208P1Z8’,‘ACM LOGISTICS PVT.LTD’,‘2657’,’ 03/05/2018 ','PB13AW6948 ',‘Y’,‘Y’,‘100010’,‘18AACCS0144E1ZS:G0082 :Outward ‘,‘100010’,’’,‘189’,‘37’,‘NIC’,‘Generated Offline’,‘Engine’,now()::timestamp,now()::timestamp,‘Generated Offline’,03/05/2018 12:37:00 PM,‘18/05/2018 11:59:00 PM’);

and i am passing

“INSERT INTO demo.ewb_details (eway_bill_no,nic_eway_bill_date,user_gstin,nic_valid_upto,transportation_mode,nic_actual_distance,supply_type,sub_supply_type,document_type,document_no,document_date,from_gstin,from_address1,to_address1,to_gstin,taxable_value,cgst_value,sgst_value,igst_value,cess_value,fu_9,fu_7,fu_4,transporter_id,transporter_name,transportation_document_no,transportation_document_date,vehicle_no,active,is_active,load_id,udid,ewb_details_batch_id,user_name,gstin_id,company_id,initiated_by,created_by,updated_by,created_date,updated_date,nic_document_status_created_by,nic_eway_bill_date,nic_valid_upto)values (”+“'” ewbno"‘“+”,“+”’“str1”‘“+”,“+”’“usergstin”‘“+”,“+”’“nicvalidupto”‘“+”,“+”’“Mode”‘“+”,“+”’“distance”‘“+”,“+”’“typ”‘“+”,“+”’“subsupplytype”‘“+”,“+”’“doctype”‘“+”,“+”’“docno”‘“+”,“+”’“docdatetrim”‘“+”,“+”’“gst”‘“+”,“+”’“FromAddress”‘“+”,“+”’“toaddr”‘“+”,“+”’“togst”‘“+”,“+”’“TotTaxableAmt”‘“+”,“+”’“CGSTAmt”‘“+”,“+”’“SGSTAmt”‘“+”,“+”’“IGSTAmt”‘“+”,“+”’“CESSAmt”‘“+”,“+”’“fu9”‘“+”,“+”’“OtherAmt”‘“+”,“+”’“TotalInvAmt”‘“+”,“+”’“transid”‘“+”,“+”’“transidname”‘“+”,“+”’“transdocno”‘“+”,“+”’“transdocdate”‘“+”,“+”’“vehno”‘“+”,“+”‘Y’“+”,“+”‘Y’“+”,“+”‘100010’“+”,“+”’“ud”‘“+”,“+”’“100010”‘“+”,“+”’“+”,“+”‘“189”’“+”,“+”‘“37”’“+”,“+”‘“NIC”’“+”,“+”‘“Generated Offline”’“+”,“+”‘“Engine”’“+”,“+“now()::timestamp”+”,“+“now()::timestamp”+”,“+”‘“Generated Offline”’“+”,“+”‘“nicewbno”’“+”,“+”‘“nicupto”’“+”);"

Getting end of expression missing

1 Like
2

Buddy @smita.mobifly

–you can use execute query activity to insert this to your db

pass the query in string format
like this

image
image952×474 25 KB

Use the connection wizard to enter your details and you can even test the connection whether it got connected to the db or not…

this activity can be obtained from package like uipath.database.activities in manage packages menu in design tab

Only thing you need is to have the server name, username and password for the same

Or if you have a datatable with you instead of a query you can use insert query to insert that datatable to the db and you have to mention the datatable name and db name as input
Cheers

1 Like
3

Is that working buddy

Cheers

4

thanku you so much , this is very easy technique but i have done another way.
this is my query and its works.

“INSERT INTO demo.ewb_details (eway_bill_no,nic_eway_bill_date,user_gstin,nic_valid_upto,transportation_mode,nic_actual_distance,supply_type,sub_supply_type,document_type,document_no,document_date,from_gstin,from_address1,to_address1,to_gstin,taxable_value,cgst_value,sgst_value,igst_value,cess_value,fu_9,fu_7,fu_4,transporter_id,transporter_name,transportation_document_no,transportation_document_date,vehicle_no,active,is_active,load_id,udid,ewb_details_batch_id,user_name,gstin_id,company_id,initiated_by,created_by,updated_by,created_date,updated_date,nic_document_status_created_by,nic_eway_bill_date,nic_valid_upto)values ('”+ ewbno + “‘,’” +str1 + “‘,’” +usergstin+“‘,’” +nicvalidupto + “‘,’” +Mode+“‘,’” +distance+ “‘,’” +typ+“‘,’” +subsupplytype+ “‘,’” +doctype+“‘,’” +docno+“‘,’” +docdatetrim+ “‘,’” +gst+“‘,’” +FromAddress+“‘,’” +toaddr+“‘,’” +togst+“‘,’” +TotTaxableAmt+ “‘,’” +CGSTAmt+“‘,’” +SGSTAmt+ “‘,’” +IGSTAmt+“‘,’” +CESSAmt+ “‘,’” +fu9+“‘,’” +OtherAmt+ “‘,’” +TotalInvAmt+“‘,’” +transid+ “‘,’” +transidname+“‘,’” +transdocno+ “‘,’” +transdocdate+“‘,’” +vehnoe+“‘,‘Y’,‘Y’,‘100010’,’“ud+”‘,‘100010’,’',‘189’,‘37’,‘NIC’,‘Generated Offline’, '” +distance+“‘,‘Engine’,now()::timestamp, now()::timestamp, now()::timestamp, ‘Generated Offline’,’” +nicewbno+ “‘,’” +nicupto+“');”

1 Like
5

Great…

Cheers buddy

6

thanku so much…

1 Like
7

Kindly close this topic buddy with comment marked solution

Cheers @smita.mobifly

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.