Does anyone have an example of an XPath definition to extract an
attribute from an XML element? The universe documentation for 10.3 and
11.1 doesn't cover this.
I am trying to get the value of "ProductId" from the following XML
example:
<pr:Feed xmlns:pr="urn:someurl">
<Data>
<Products>
<Product ProductId="ABC">
...
</Product>
<Product ProductId="123">
...
</Product>
<Product ProductId="XYZ">
...
</Product>
</Products>
</Data>
</pr>
Using the this extraction file:
<U2XML_extraction xmlns:USxml="http://www.rocketU2.com/U2-xml"; >
<file_extraction start="/Data" dictionary="XMLTESTFILE" null="EMPTY"
/>
<field_extraction field="@ID" path="Products/Product/@ProductId" ,/>
</U2XML_extraction>
I get the following error:
>LIST XMLDATA EDGENET_XML "&XML&/test.ext"
Open XML data file failed.
XMLParser error message: Fatal error at file
'/Volume1/MIS/&XML&/test.ext', line 3, column 69. Message: Expected an
attribute name
Open XML data file failed.
XMLParser error message: Fatal error at file
'/Volume1/MIS/&XML&/test.ext', line 3, column 69. Message: Expected an
attribute name
Unable to open "XMLDATA:EDGENET_XML,&XML&/test.ext" file.
>
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
