topic Re: Extracting XML with a parent loop which has multiple child loops in Talend Studio

Extracting XML with a parent loop which has multiple child loops

Anonymous — Fri, 27 Feb 2015 07:25:10 GMT

Hi All,
I am trying to extract data from xml file (actually the data is returned by a web service call using tRESTClient).
This particular response/XML file has a parent loop and each parent has 4 or 5 child loops.
I tried parsing this using tExtractXMLField, tXMLMap, tFileInputXML but not able to parse it correctly. I found each of the component has their own limitation while reading and writing the data, hence none of those is able to parse this XML or even combination of those components also couldn't do it.
Can anybody please help me with this?
Here's the XML:

<set>
    <ActivityInstance>
        <processUUID>
            <value>DiscountApproval--1.0</value>
        </processUUID>
        <instanceUUID>            <value>D

To see the whole post, download it here

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Fri, 27 Feb 2015 10:19:03 GMT

check this post which smiler to your scenario.
read-xml-with-nested-loops

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Fri, 27 Feb 2015 19:13:37 GMT

Thanks.
But we're not looking to break one row XML data into multiple rows/schemas.
We need to parse that XML in one data row i.e. one schema. So that we can play around with this one row schema with our needs.
And how do we convert those parent loops and multiple child nested loops to Json?

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Fri, 27 Feb 2015 19:15:33 GMT

Can anyone write one demo job to read that XML to row schema and then convert it into json?
It will be of great help. Thanks a ton in advance.

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Sat, 28 Feb 2015 10:55:15 GMT

Anyone?

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Sun, 01 Mar 2015 11:21:40 GMT

Someone?

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Mon, 02 Mar 2015 06:31:49 GMT

No one?

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Mon, 02 Mar 2015 06:46:46 GMT

Can you show us what output are you looking? also show us what are the ways you tried, and output you got, it will help us too.

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Mon, 02 Mar 2015 18:57:59 GMT

I want the XML from my first post, as a JSON output.
I tried various components like tXMLMap, tExtractXML, tExctractMSXml, tWriteJson. All has their advantages and limitations. I can read the XML fine but I am not able to convert it into JSON due to the limitation of tWriteJson which allows only one loop.
Also I've don't have good knowledge on how to use Data Mappings (I do have Enterprise Version), still I managed to play it around and create my own tMyMap (custom map like tMap, tHMap, tXMLMap). But even in that case, I just don't know how would I convert my data into JSON!!
I am simply stuck due to various limitations of different components and not able to find my way out of this.
If experts don't have answers to above questions then One final question for you guys: IS THIS EVEN POSSIBLE TO DO IN TALEND? XML to JSON, that's it!!!!! Or we just have to use some third party library to create JSON using tJava, tJavaFlex, etc?

Re: Extracting XML with a parent loop which has multiple child loops

Anonymous — Tue, 03 Mar 2015 12:26:29 GMT

Folks?