Pooja2
(Pooja)
March 23, 2021, 10:02am
1
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)
Hiba_B
(Hiba Beldi)
March 23, 2021, 10:46am
2
Hi @Pooja2 !
Would you mind sharing your workflow (xaml) and data (xml file) ? (create dummy data if you have sensitive ones)
Pooja2
(Pooja)
March 23, 2021, 11:06am
3
Hi
<wd:data xmlns:wd=“URL”>
wd:Entry
wd:Date_Applied 2021-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.
Pooja2
(Pooja)
March 23, 2021, 11:10am
5
I am trying with deserialize activity. where getting data in the above format.
now i want each value.
Pooja2
(Pooja)
March 23, 2021, 11:13am
7
I want candidate ID from this.
Hiba_B
(Hiba Beldi)
March 23, 2021, 11:41am
8
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
ppr
(Peter Preuss)
March 23, 2021, 11:42am
9
@Pooja2
the xml is defining namespaces. Have a look below on an introduction on how to handle it:
@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)
1 Like
Pooja2
(Pooja)
March 24, 2021, 8:32am
10
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?
system
(system)
Closed
March 27, 2021, 8:32am
11
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.