Read data from XML File, then push data to MSSQL

[cufis]

I have a task that is monitoring a folder. When a new file is sent there, it launches to check if the file is XML or not and goes through some steps if it is not. I want to create a subtask that will recieve the XML file path as a variable passed from the parent task, read the data, and insert the data into the corresponding tables in my MSSQL DB. Header Elements will be inserted into the "Ored" Table, and "Message" Elements will be inserted into the "OrderItems" Table. Once the sub task is complete, my main task will continue on with its routine.

I have uploaded a sample XML file that is formatted exactly as it will be sent to me.

I'm using v.5.5.2 - Premiere

[forumsupport]

Hello,

Automation Anywhere 6.0 version provides XML command using which you can capture data having XML formatting and save to the desired location to be viewed through the required application.

You can download free trial version of Automation Anywhere 6.0 from our website:
Automation Anywhere - The Automation Software. Automate & Schedule IT & Business processes easily.

We have created a sample task for your reference that extracts desired data from XML file you uploaded and stores the extracted data into MSAccess database.

To run this sample,

.Please copy .atmn file under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
.Copy .xml and .mdb file under D:\.