@praneetv9588 This is really going to be a programming exercise. You could potentially use the XMLDocument component to work with an XML file in an automation, however you'd still need to understand the XML structure and navigation programmatically. This is also really geared towards traversing the document rather than reading into XML.
My suggestion would be to do this within a C# script. You can pass your XML into the script and write you code to convert that XML into a DataTable and return that DataTable for use in the automation(s).
Here is an example I found on StackOverflow, but I am sure there are many others you can find.
Thank you for your quick response and suggestions. as mentioned tried using Script but its going into many loops as the data is available with unbounded child tags also with different scenarios which makes bit complex.
will try with XMLDOCUMENT component where i can create proxy and get child nodes according to Schema. will update the solution here once i am able to resolve either with script or Xmldocument.
Thank you again.
Posted: 3 weeks ago
Posted: 27 May 2021 13:18 EDT
Thomas Sasnett (ThomasSasnett)
Lead Robotics Architect u2013 Pega Consulting
@praneetv9588 It sounds like you may have mal-formed XML. If that is the case, the component will likely not help you. A script is the better way to go. The component might allow you to traverse each node and extract the data you need and then add that data to a table, but it would be slower than doing so in a script. I would suspect that you'd have identical issues with your script though if your XML is not valid.