Blueprism :Help me to Read Complex XML

stalin

New Member
Hi ,

I have read XML with "Get Elements" Action. After that ,Results are stored in Elements collections. Each filed has been stored in collection like below list. I am not sure how to get the filed vaklues from collection and write into Excel. I have attached my workflow with respective screenshots. Attached ALM SUMMARY REPORT excel file that has the sample data that how we have to get data from xml and finally write into excel. There are 10 entities in the xml and we have to loop through and get the below field values and write into excel columns. Help me out to solve this.

Attached my workflow and xml file in .txt forward. Kindly convert to xml and do your experiments.


Need to get values from below attributes for each entity:

<Field Name="subject"><Value>1001</Value></Field>

<Field Name="project"><Value>Test_Project</Value></Field>

<Field Name="creation-time"><Value>2020-04-15</Value></Field>

<Field Name="id"><Value>1</Value></Field>

<Field Name="severity"><Value>5-Urgent</Value></Field>

<Field Name="detected-by"><Value>mc_ixmagual</Value></Field>

<Field Name="priority"><Value>5-Urgent</Value></Field>


<Field Name="detected-in-rcyc"><Value ReferenceValue="SIT Cycle 2">1002</Value></Field>

<Field Name="name"><Value>Login page is not displayed</Value></Field>



Thanks,

Stalin Ramadoss

+91-7010412359
 

Attachments

  • 1.jpg
    163.8 KB · Views: 21
  • 2.jpg
    160.5 KB · Views: 17
  • 3.jpg
    101.4 KB · Views: 15
  • 4.jpg
    119 KB · Views: 13
  • BPA Object - XML Reading.txt
    9.8 KB · Views: 14
  • Defect_Report07102020143619.txt
    37.1 KB · Views: 12
Top