Parse XML from API Call

[tlwilli2020]

First, let me thank you all in advance for you help.  And second, I apologize in advance as I'm only like 2 weeks into using Talend as a tool, so i'm pretty unfamiliar with all of the features.  I've searched the web and can't seem to find a working solution for this problem.  I can't imagine it is unique, so I imagine it is user error and not using the proper components

Scenario:

1) making an API call to a 3rd party service

2) here is a sample of the data.  For each "employee" in the data, there is a possibility that there will be 1 or more rows of data.  

  

3) At the end of the day, i need to flatten this out to look something like:

employeeid, date, location..jobTitle, reportsTo

I've used the tExtractXml component and can get it to print out on the screen each individual employee id.. But I cannot seem to figure out how to "flatten" it out to also show the row level data. 

Any guidance or pointers would be greatly appreciated.

Thanks.

[tlwilli2020 · Accepted solution]

It turns out to actually be a pretty easy problem to solve once I read up on XML and how to use the tExtractXMLfield component.  I'm not entirely sure if this is the "optimal" solution, but it certainly works.  

Screen Shot 2020-04-13 at 9.53.24 AM.png