Insert n number of rows to external MySql DB using RDB-Save by querying with connect SQL rule
Hi,
I have a page with n number of pxResults. I wanted to insert data to external MySQL DB.
I have an activity with RDB-Save method and uses connect SQL rule.
How can I give values in the query?
Could anyone please tell the syntax?
Updated: 15 Apr 2021 6:04 EDT
Indocosmo Systems Pvt Ltd
IN
My Query is
" INSERT INTO { Class name } (Item_Id,Quantity,Total＿Price,Discount,Tax,Order_Date) values ('{ASIS:Page_name.pxResults.Item_Id}','{ASIS:Page_name.Quantity}','{ASIS:Page_name.pxResults.Total_Price}','{ASIS:Page_name.pxResults.Discount}','{ASIS:Page_name.pxResults.Tax}','{ASIS:Page_name.pxResults.Order_Date}')"
Is this the correct syntax?
My activity has 3 steps -
1. property set - set a property from page
2. property set - loop pxresults of the page
3. RDB-Save - Save the properties to external database.
ERROR shown in UI :
The Flow Action post-processing activity activity_name failed: The reference Page_name.pxResults.Item_Id is not valid. Reason: list property 'pxResults' must have an index The reference Page_name.pxResults.Item_Id is not valid. Reason: list property 'pxResults' must have an index