Not able to extract the specific data from XML

Hi

I want to extract a specific data from xml

getting below error

The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name.
at System.Xml.XmlConvert.VerifyNCName(String name, ExceptionType exceptionType)
at System.Xml.Linq.XName…ctor(XNamespace ns, String localName)

Hi @Pooja2 !
Would you mind sharing your workflow (xaml) and data (xml file) ? (create dummy data if you have sensitive ones)

Hi

<wd:data xmlns:wd=“URL”>
wd:Entry
wd:Date_Applied2021-02-27-08:00</wd:Date_Applied>
<wd:student data wd:Descriptor=“Sample1”>
<wd:ID wd:type=“WID”>7689999jgjg</wd:ID>
<wd:ID wd:type=“ID”>768</wd:ID>
</wd:student data>

this kind of xml file i have.

Thanks !
And your xaml ?

I am trying with deserialize activity. where getting data in the above format.
now i want each value.

What is the wanted data.

I want candidate ID from this.

When I use deserialize activity I get an error of the xml format.
The format of the xml seems to be not valid.
Checked also with an xml validator:

1 Like

@Pooja2
the xml is defining namespaces. Have a look below on an introduction on how to handle it:

1 Like

I want temp_ID from below xml.

<wd:Student_ID wd:Descriptor=“Open”>
<wd:ID wd:type=“WID”>87687678678</wd:ID>
<wd:ID wd:type=“temp_ID”>R84347</wd:ID>
</wd:Student_ID>

can any one help me to get this data?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.