Follow-On Topics

Related Topics

# Runtime Processing

The options set in the configuration of the Step determine the fields present in the output recordset. Only those fields selected are created in the output recordset.

At runtime, the data exposed in the output Recordset of the Step is a union of all the child objects selected in the XML structure, thereby converting the hierarchical data contained within the XML into a flat recordset as used by King Task Centre.

The following example shows what happens at runtime when XML data representing a parent/child relationship is transformed into a King Task Centre recordset through the Convert XML to Recordset tool.

    <Customer>
         <Code>Cust1</Code>
         <Name>Demo Customer</Name>
         <Address>
              <Street>2 Test Street</Street>
              <City>Somewhere</City>
         </Address>
         <Address>
              <Street>2 Another Street</Street>
              <City>Nowheresville</City>
         </Address>
         <Contact>
              <Name>John Smith</Name>
              <Position>Manager</Position>
         </Contact>
         <Contact>
              <Name>Fred Bloggs</Name>
              <Position>Cleaner</Position>
         </Contact>
    </Customer>

If the Convert XML to Recordset Tool is configured to output all of these objects (the main customer info, the addresses and the contacts) then the output Recordset at runtime looks like this:

Code | Name | Address_Street | Address_City | Contact_Name | Contact_Position
--- | --- | --- | --- | --- | ---
Cust1 | Demo Customer | 2 Test Street | Somewhere | NULL | NULL
Cust1 | Demo Customer | 2 Another Street | Nowheresville | NULL | NULL
Cust1 | Demo Customer | NULL | NULL | John Smith | Manager
Cust1 | Demo Customer | NULL | NULL | Fred Bloggs | Cleaner

Copyright © 2018 Quadrant Software B.V. All rights reserved.