Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

txmlmap not fetching extensions

We are getting a SOAP response in below format:

 

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Header/>
<soap:Body>
<n0Smiley Surprisedutput xmlnsSmiley FrustratedOAP="http://schemas.xmlsoap.org/soap/envelope/" xmlns:n0="URL1.com" xmlns:wsu="URL2.com" xmlns:xi="URL3.com" xmlns:xlink="URL4.com">
<OERstatusResult>Success/Failure</OERstatusResult>
<mediciISDocument creationDate="2019-03-19T08:26:40+00:00" schemaVersion="1.2">
<mediciISBody>
<EventList>
<AggregationEvent>
<eventTime>2019-01-08T08:43:34+01:00</eventTime>
<eventTimeZoneOffset>+01:00</eventTimeZoneOffset>
<parentID>xyz</parentID>
<childmedicis>
<medici>abc1</medici>
<medici>abc2</medici>
<medici>abc3</medici>
</childmedicis>
<action>ADD</action>
<bizStep>urn:mediciglobal:cbv:bizstep:abcing</bizStep>
<disposition>urn:mediciglobal:cbv:disp:in_progress</disposition>
.
.
.
.
<extension>
<n0:mediciList xmlns:n0="URL5.com">
<n0:mediciExtension>
<n0:medici>abc1</n0:medici>
<n0:lotNumber>12345</n0:lotNumber>
<n0Smiley TonguerodID measurementUnitCode="BOX"/>
<n0:Type>Y</n0:Type>
<n0:ID>45678</n0:ID>
</n0:mediciExtension>
<n0:mediciExtension>
<n0:medici>abc2</n0:medici>
<n0:lotNumber>12591</n0:lotNumber>
<n0Smiley TonguerodID measurementUnitCode="BOX">765769</n0Smiley TonguerodID>
<n0:Type>Y</n0:Type>
<n0:ID>734587456</n0:ID>

</n0:mediciExtension>
<n0:mediciExtension>
<n0:medici>abc3</n0:medici>
<n0:lotNumber>12591</n0:lotNumber>
<n0Smiley TonguerodID measurementUnitCode="BOX">10001274</n0Smiley TonguerodID>
<n0:Type>Y</n0:Type>
<n0:ID>647646758</n0:ID>

</n0:mediciExtension>
</n0:mediciList>
</extension>
</AggregationEvent>
</EventList>
</mediciISBody>
</mediciISDocument>
</n0Smiley Surprisedutput>
</soap:Body>
</soap:Envelope>

 

From this response i am trying to fetch "n0:ID" from the extension, but I am not able to fetch it.

The loop element is present on:

<childmedicis>
<medici>abc1</medici>
<medici>abc2</medici>
<medici>abc3</medici> and <n0:mediciExtension>

 

In the output I tried to configure the sequence of the loop elements but still for the extension part it is givng null as a result.

 

 

 

Labels (4)
1 Reply
Anonymous
Not applicable
Author

Hello,

Could you just see if you get it reproduced with talend V 7.1.1?

Best regards

Sabrina