Parse XML from API Call

tlwilli2020 — Sat, 16 Nov 2024 02:43:09 GMT

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.

Re: Parse XML from API Call

tlwilli2020 — Mon, 13 Apr 2020 15:55:18 GMT

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

topic Parse XML from API Call in Talend Studio

Parse XML from API Call

Re: Parse XML from API Call