29 views

Description

Xpath unable to parse node if the elements are formatted at the same node level

ex:

<abc>
    <xyz>
        <field1><subProp1>Some Val1</subProp1></field1>
        <field2><subProp2>Some Val2</subProp2></field2>
        <field3><subProp3>Some Val3</subProp3></field3>
        <field4><subProp4>Some Val4</subProp4></field4>
    </xyz>
</abc>

Steps to Reproduce

  1. Create an XML data source with XML from the Description.
  2. Set the XPath to /abc/xyz.
  3. Load All Records
  4. No records are inserted. Expected behavior is that 1 record will be inserted into the with 4 values, field1, field2, field3, field4. Each should have an XML fragment similar to "<?xml version="1.0" encoding="UTF-8"?><field1><subProp1>Some Val1</subProp1></field1>".

Workaround

Two potential workarounds include:

  1. Alter source XML to include carriage returns for all children nodes
  2. Specify 'expand node children' in the data source. This will insert the record and the child elements will be converted into additional columns. So the example above, the record will still include empty values for field1, field2, field3, field4, but will include values for additional columns field1/subProp1, field2/subProp2, field3/subProp3, field4/subProp4

Related Problem: PRB1158748

Seen In

Jakarta Patch 1

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-11-16 16:33:06
Published:2017-11-17