Extracting Specific Elements from XML

[jpreziuso]

I am looking to extract just the value of “8” from . I have tried a Regex match and just writing out the value based on XML Elements. I can’t find the right elements to use though. Does anybody know how I could do this? Thanks

[ppr (Peter Preuss)]

Have a look here on how to deal with namespaces:

Read from xml file

@Zlotzky Setting up the quick prototype: Variables: Handling Namespace: [grafik] ElementNames to Extract - Prototype reduced set: [grafik] Read In XML [grafik] Ensure: [grafik] Retrieval of private contact element (mandatory use of the Namespace within the name) [grafik] iterating over the list of elmentnames (ExtractNames) and reading element value: [grafik] Logs: [grafik] Find starter help here: Zlotzky.xaml (6.3 KB)

Additional demo:

Parse a SOAP XML

Hi , i have been trying to fetch a value of @ID@ from a particular @IDType@ from the XML Could you please help with the approach . [image] test.xml (742 Bytes) Thanks

[RanaMuhammadAli (Muhammad Ali)]

@jpreziuso

You have to use Deserialize JSON activity for this

Please have a look at this post. It is the same problem as you are facing. I hope it will solve your problem.

How to quickly get the value from a json

Fine try with this expression once after deserializing JSON file lets take like the output variable of Deserializa JSON activity as out_json –now in a write line activity mention as out_json(“data”)(“ret”)(3).tostring this would give you that value Cheers @fightblue

Regards,
Muhammad Ali