topic Re: read xml with loops in Talend Studio

read xml with loops

Anonymous — Sat, 16 Nov 2024 03:19:37 GMT

Bonjour,

can you tell me how to manage subloops in xml ?

I am playing with tExtractXMLField and tXMLMap for hours but I did not succeed to extract data correctly from XML root :

"/GetOccurrencesResponse/GetOccurrencesResult/Occurrence"

I have a first part with ; /DataFields/DataField having attributes ; - ControlType -DataType -DisplayLabel -ElementIdentifier -Name -Value

And a second part with attributes - ID - IncidentId - Incident number ...

here is my xml :

<?xml version="1.0" encoding="ISO-8859-15"?> -<root> -<row> <Header/> <Body><GetOccurrencesResponse xmlns="http://www.abc.com/abcWebServices/v1.2/"><GetOccurrencesResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Occurrence><Attachments /><BrokenRules />

<DataField><ControlType>TextEdit</ControlType><DataType>Numeric</DataType> <DisplayLabel>Flight ID</DisplayLabel><ElementIdentifier>Ffbf9ece5ad0c47c592cf676de2f860e2</ElementIdentifier><Name>IdFlight_ergoss</Name><ReferenceListName /><Value>1</Value></DataField>

<DataField><ControlType>TextEdit</ControlType><DataType>String</DataType> <DisplayLabel>Registration</DisplayLabel><ElementIdentifier>Fa82246081ab74cf48a2a1f0af5aef4ec</ElementIdentifier><Name>Registration_ergoss</Name><ReferenceListName /><Value>test registration</Value></DataField>

</DataFields>

<ID>8641</ID> <IncidentId>-1</IncidentId> <IncidentNumber /> <IncidentStatusName /> <IncidentTitle /> <IsMain>true</IsMain> <LocationName /><Notes /> <Number>FDM-137</Number> <RecordedByPersonName>SARA, ERGOSS</RecordedByPersonName> <RecordedDate>2020-02-05T14:05:56.763</RecordedDate> <ReportTypeName>ERGOSS</ReportTypeName> <ReportedByPersonName>User, API</ReportedByPersonName> <ReportedDate>2020-02-05T13:05:00</ReportedDate> <Title>Title4Test</Title> </Occurrence><Occurrence><Attachments /><BrokenRules />

</DataFields>

<ID>8642</ID> <IncidentId>-1</IncidentId> <IncidentNumber /> <IncidentStatusName /> <IncidentTitle /> <IsMain>true</IsMain> <LocationName /> <Notes /> <Number>FDM-138</Number> <RecordedByPersonName>SARA, ERGOSS</RecordedByPersonName> <RecordedDate>2020-02-05T14:12:07.407</RecordedDate> <ReportTypeName>ERGOSS</ReportTypeName> <ReportedByPersonName>User, API</ReportedByPersonName> <ReportedDate>2020-02-05T13:12:00</ReportedDate> <Title>Title4Test</Title> </Occurrence><Occurrence><Attachments /><BrokenRules /> <Fault/> </row> </root>

...

Re: read xml with loops

Anonymous — Sun, 09 Feb 2020 21:25:49 GMT

I added screen copies ...

textractXMLfield.JPG

Re: read xml with loops

Anonymous — Mon, 10 Feb 2020 07:40:19 GMT

Here is a another full structure of my xml file for 1 occurence in input ... can someone explain how to define my xml extract component and xml metadata to be able to read such file ?

Thank's in advance for your help.

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body>
<GetOccurrenceResponse xmlns="http://www.fakeabc.com/fakeabcWebServices/v1.2/">
<GetOccurrenceResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<Attachments/>
<BrokenRules/>
<DataFields>
<DataField>
<ControlType>CheckEdit</ControlType>
<DataType>Boolean</DataType>
<DisplayLabel>Voluntary Report</DisplayLabel>
<ElementIdentifier>

To see the whole post, download it here
occurencedemo.xml
OriginalPost.pdf

Re: read xml with loops

tnewbie — Wed, 12 Feb 2020 15:03:17 GMT

DamienBlondel,

Recently i have worked considerably on xml data sources and was able to loop through the data sources. All you have to ensure here is adding the looping construct at the right place. i can probably help you if i understand your question correctly. Can you please rephrase your question and precisely ask what the problem is.

Re: read xml with loops

Anonymous — Tue, 25 Feb 2020 22:51:59 GMT

hello and thank you for your reply.

I am not able to read this complex (for me) xml structure ...

<ControlType>CheckEdit</ControlType>

<DataType>Boolean</DataType>

<DisplayLabel>Voluntary Report</DisplayLabel>

<Name>Voluntary Report</Name>

<Value>false</Value>

</DataField>

… repeated several times

</DataField>

…

</DataFields>

<ID>8872</ID> <=== these is the key of the occurence

<RecordedByPersonName>GASINI, Claudio</RecordedByPersonName>

<ReportTypeName>Air Safety Report</ReportTypeName>

<ReportedByPersonName>DBL LUFO, Stéphane</ReportedByPersonName>

</Occurrence>

… many other occurences

</Occurrence>

</GetOccurrencesResult>

</GetOccurrencesResponse>

I hope it’s clearer … you can see that for each OCCURRENCE, I have 2 blocks

DATA FIELDS data contain a list of DATA FIELD (it’s a loop) and these DATA FIELD are all linked with the next block
Identification block at the end starting with <ID> … finishing with TITLE …

Re: read xml with loops

Anonymous — Thu, 27 Feb 2020 16:53:38 GMT

Can upload xml file.

Re: read xml with loops

tnewbie — Thu, 05 Mar 2020 02:14:45 GMT

If i am understanding your problem correctly, you are facing problems in capturing data elements that are repeating with in parent node...if that is what you are looking for then the attached image should give you a fair deal of understanding on how to achieve this. You have to tag a repeating element as a loop element both at the source and target levels with in a tXMLMap component.

If my understanding about your problem is not correct, please repeat what the problem is, I can attempt to provide a solution to your problem.

xml_loop.png

Re: read xml with loops

tnewbie — Tue, 10 Mar 2020 17:26:56 GMT

Does this solve your issue..?

Re: read xml with loops

Anonymous — Sun, 05 Apr 2020 22:36:06 GMT

Bonjour,

sorry for late answer. My question is about having a double loop in the same tree.

When I import my file in input, I can see 1 loop only.

Do you know where I can define a double loop ?

regards

Damien

DoubleLoop.JPG