Read XML with nested values
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
3 posts
Page 1 of 1
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>
- Support Specialist
- Posts: 590
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
-
Change your "Keystring" in your path to "KeyString" (as it is in your XML file)
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
3 posts
Page 1 of 1