Need help in parsing repeating XML data

[Suhas_M (Suhas Mariyappa)]

Hi All,

I am trying to extract the contract type value from the below XML however, I am facing challenge as Integration_Field_Override_Data is repeating and I am just getting the value of the Organization Full Address as it is the first instance.

Kindly help me and this is how I am parsing the XML.

Deserialized_XML.Element( in_soapenv+“Envelope” ).Element( in_soapenv+“Body” ).Element( in_wdd + “Get_Workers_Response”).
Element(in_wdd+“Response_Data”).Element(in_wdd+“Worker”).Element(in_wdd+“Worker_Data”).Element(in_wdd+“Integration_Field_Override_Data”).
Element(in_wdd+“Value”).value

Xml dump data

<env:Envelope xmlns:env=http://schemas.xmlsoap.org/soap/envelope/>
env:Body
<wd:Get_Workers_Response wd:version=“v76.1” xmlns:wd=“uruin:com.workday/besvc”>
wd:Response_Data
wd:Worker
wd:Worker_Data
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>fa9d2e59c7a70123bef50hg3df6183e0000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT HR RPA Get Workers Field Override”>Organization Full Address</wd:ID>
</wd:Field_Reference>
wd:ValueCalle 7 N. 123-35 Ptisos 4 y 5&#xa;Address Bogotá&#xa;110111&#xa;</wd:Value>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>fa9d2e59c7a70123c38e38afcf35g5c0000</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT HR RPA Get Workers Field Override”>Organization Address Line 1</wd:ID>
</wd:Field_Reference>
wd:ValueCalle 7 N. 123-35 Ptisos 4 y 5</wd:Value>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>fa9d2e59c7a70345123c38e38afcf5c0001</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT HR RPA Get Workers Field Override”>Organization Address Line 2</wd:ID>
</wd:Field_Reference>
</wd:Integration_Field_Override_Data>
wd:Integration_Field_Override_Data
wd:Field_Reference
<wd:ID wd:type=“WID”>38577560a3455201279798350486700001</wd:ID>
<wd:ID wd:type=“Integration_Document_Field_Name” wd:parent_type=“Integration_Document_Name” wd:parent_id=“INT HR RPA Get Workers Field Override”>Contract Type</wd:ID>
</wd:Field_Reference>
wd:ValuePermanent</wd:Value>
</wd:Integration_Field_Override_Data>
</</wd:Worker_Data>
</wd:Worker>
</wd:Response_Data>
</wd:Get_Workers_Response>
</env:Body>
</env:Envelope>wd:Integration_Field_Override_Data>

Let me know if you need any additional details on this.

Regards,
Suhas

[Yoichi]

Hi,

Can you share your xml as a file?

Regards,

[ppr (Peter Preuss)]

@Suhas_M
Have a look here:

XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types)

Going ahead Serializing the XML - output: xDoc | DataType: XDocument: [grafik] Checking if we have to handle XML namespaces [grafik] We do have: [grafik] Checking for some children: [grafik] Defining Namespace Variable [grafik] In some cases, we can also do: Assign Activity - xnsDefault = xDoc.Root.Name.Namespace Checkin the retrieval [grafik] xDoc.Descendants(xnsDefault + "productVersion") GetDescendants { [<productVersion build="456" xmlns="http://tableau.com/api">123</…

It looks like you do handle namespaces. Working with the Descendants(YourNamespane + “YourElementLocalName”) will help to process multi occurences

[ushu (Usha kiranmai)]

@Suhas_M Can you share this format in notepad++