Read XML with nested values
Posted: Tue Aug 26, 2014 8:07 am
I'm trying to read an xml formatted like this:
Code: Select all
I'm trying with all kind of variations on <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body>
<ocFindSubscribersResponse xmlns="http://www.europ-assistance.nl/2010/12/sis">
<ocFindSubscribersResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<Subscriptions>
<dcSubscription>
<StringFields>
<KeyString>
<Key>Type verzekering</Key>
<Value>auto</Value>
</KeyString>
<KeyString>
<Key>VehicleBrand</Key>
<Value>Fiat</Value>
</KeyString>
<KeyString>
<Key>VehicleModel</Key>
<Value>Panda</Value>
</KeyString>
</StringFields>
</dcSubscription>
</Subscriptions>
</ocFindSubscribersResult>
</ocFindSubscribersResponse>
</s:Body>
</s:Envelope>
Code: Select all
could someone tell me how to approach this? <xmlRead file="Response_${Kenteken}.xml" validation="none" version="1.0">
<rowset name="RowSet" nestedSharedValues="false">
<column index="1" value="/s:Envelope/s:Body/ocFindSubscribersResponse/ocFindSubscribersResult/Subscriptions/dcSubscription/StringFields/Keystring/Key" name="Key" />
<column index="2" value="/s:Envelope/s:Body/ocFindSubscribersResponse/ocFindSubscribersResult/Subscriptions/dcSubscription/StringFields/Keystring/Value" name="Value" />
</rowset>
</xmlRead>