How to retrieve the DeliveryStatus from Deserialized Soap XML File?

[David_Hernandez (DH)]

I have been struggling with grabbing the delivery status from this Soap File

I have tried Deserialized_SoapFile.Element(“getShipmentInfoResponse”).element(“DeliveryStatus”)

With no luck. Not very experienced with XML, any help is great!

[ppr (Peter Preuss)]

@David_Hernandez
Welcome to the forum

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</…

[David_Hernandez (DH)]

Do I have multiple namespaces? Would each one of the url’s at the top be a namespace?

[ppr (Peter Preuss)]

Yes multiple namespaces are defined
The attached Link shows you an analysis technique to find out the used namespaces within an element. Also you can crosscheck if the prefix is present

Feel free to share your XML with us for further help, when it is needed

[David_Hernandez (DH)]

Here’s the XML file as textfile.

SoapText.txt (4.5 KB)

[ppr (Peter Preuss)]

her the top of the xDoc

the analysis, when in doubt about namespace usage

so we do see the different namsepaces, when retrieval will done by defining the steps to DeliveryStatus

or we do it with the Descendant Approach

[David_Hernandez (DH)]

After Tinkering a bit I did manage to get it!

The second Issue I have now (If you have the time) – is creating an array of each tracedata element. Each tracedata contains the history of the shipment and Ill have to parse through them separately. Can I create an element array of some sort?

[ppr (Peter Preuss)]

@David_Hernandez
Let’s scope the topic - 1 Topic = 1 case.
So other researchers can easier find solutions.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

Feel free to open for your sendond quuestion a new topic and get pick up from there. Also describe more detailed your case / expected output

Thanks for support

[David_Hernandez (DH)]

Thank you for the help so far! I posted a second topic here:

How to create an arraylist of xelements(?) from an XML file?

Hey, currently I want to create an arraylist of Xelements from each protrace instance in my xml file. Here is the xml file in text form: SoapText.txt (4.5 KB) I need to separate each protace into a list so that I can most easily access the variables inside later. Any thoughts?