topic Re: How to read value in complex xml file in Talend Studio

How to read value in complex xml file

Anonymous — Thu, 18 Apr 2019 13:42:29 GMT

Hello,

Somebody can help me on how to read value in complex xml file.

See screen short and sample of xml file that a try to read value.

Best regard

Re: How to read value in complex xml file

Anonymous — Thu, 18 Apr 2019 13:44:35 GMT

This is a sample of xml file.

Thanks

InputXML.xml

Re: How to read value in complex xml file

Anonymous — Thu, 18 Apr 2019 14:20:29 GMT

The best way to do this is to use a tFileInputXML and Xpath expressions. You can find information on the tFileInputXML component here (https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/dQGBQzM08Kw9ML1iG_Ge5g).

A good online tool for checking and perfecting your XPaths can be found here (https://www.freeformatter.com/xpath-tester.html)

Re: How to read value in complex xml file

vapukov — Thu, 18 Apr 2019 15:06:05 GMT

in addition to @rhall

a lot of time and emotions save a proper XML/JSON tools, like OxygenXML (Altova, LiquidXML) they not only allow to test XPath but also show to you XPath on the selected place in the file

Re: How to read value in complex xml file

David_Beaty — Thu, 18 Apr 2019 15:41:44 GMT

Hi,

You'll also need to implement the query aspect of parsing through the XML. So, in your example screen shot, to acquire the Job_Profile_ID you'll need to use something like:

"/wd:Report_Data/wd:Report_Entry/wd: Position_group/wd:Job_Profile/wd:ID[@wd:type='Job_Profile_ID']"

As the Loop XPath query, to only bring back the element where the wd:type is of the type you're looking for. Workday is a notoriously complex XML structure and you may find you have to query into the same file multiple times to pull out all of the values you're after.