Nintex Connect

The Official Community Site for Nintex Software Products, including Nintex Workflow 2007, 2010 and 2013; Nintex Workflow for Project Server 2010; Nintex Reporting 2008 and Nintex Analytics 2010; Nintex Forms 2010; Nintex Live and Nintex SmartLibrary.

Welcome to Nintex Connect Sign in | Join | Help

Home

Forums

Downloads

Nintex Connect » Nintex Workflow 2007 » General Discussion » How to use Collection Operation to parse an XML string

How to use Collection Operation to parse an XML string

07-20-2011, 4:38 PM

Jonathan
Joined on 07-13-2010
Dallas, TX
Posts 11

How to use Collection Operation to parse an XML string

Reply Quote

Hi everyone - I've hit a road block working on this workflow and I hope someone out there has been through this before.

I have an XML string that I need to parse similar to the following:

?xml version="1.0" encoding="utf-8" ?>
<WorkOrders>
    <WorkOrder Number="012345" UserName="Harry Potter">
         <Account AccountId="333" RacingBroomType="Nimbus2000">
             <BroomAccessories HandleType="Maple" BristleType="Eastern Straw" StirrupType="Bronze Eagle" />
       </Account>
       <Account AccountId="963" RacingBroomType="FireBolt">
             <BroomAccessories HandleType="Hardened Walnut" BristleType="Highlands Green" StirrupType="SE4" />
       </Account>
</WorkOrder>
<WorkOrder Number="854573" UserName="Draco Malfoy">
        <Account AccountId="889" RacingBroomType="Nimbus2001">
              <BroomAccessories HandleType="Redwood" BristleType="Dragon's Hay" StirrupType="Silver Eagle 5" />
       </Account>
   </WorkOrder>
</WorkOrders>

I'm trying to query the XML and use a For Each Loop with Collection Operations, but my workflow returns incorrect results each time there is entry with multiple <Account> entries.

Thanks is advance for helping,

Jonathan