Question
CIGNA Health Solutions India
IN
Last activity: 27 May 2021 13:18 EDT
Read XML and Get DataTable as output
Hi All,
I would like to read a xml which is Complex type and it has Dynamic Tags added to a schema.
for example I have parent tag as <Account > one account can have many number of transaction numbers.
here the tag <transaction> gets dynamically added as some time 5 child tags or sometime 100child tags.
Using Document module its going difficult. is there any other method to work on this? please help me here.
Pegasystems Inc.
US
@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.
https://stackoverflow.com/questions/6228315/convert-xml-to-datatable
CIGNA Health Solutions India
IN
@ThomasSasnett Hi Thomas,
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.
Pegasystems Inc.
US
@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.