xmlDeserialized.Element("export").Elements("sanctionEntity")

Help Studio
, ,
1

I am not able to get items by using above deserialized elements for below XML data. Could you please help me here. Thanks

<?xml version="1.0" encoding="UTF-8" standalone="yes"?> UNSC RESOLUTION 1483 http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF UNSC RESOLUTION 1483 http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF
2

HI,

As < is special character in this forum, your xml isn’t displayed correctly.
Can you try to use </> in the above menu or add 4 spaces at the beginning of each line?

Regards,

3

@prasannarayana.machavarap
Lets assume it is an XML which is also defining XML Namespaces we would check and analyse as described here:
XML Extraction - Handling Namespaces (Tableau, Soap, OASIS types) - Help / Community - UiPath Community Forum

Lets demonstrate it also on a sample like this:

grafik
grafik1252×202 69.1 KB

Name analysis
grafik

so we set the default Namespace
grafik

and can do e.g.

grafik
grafik810×52 22.6 KB

For looping over all sanctionEntity elements:

xDoc.root.Descendants(xnsDefault + "sanctionEntity")
4

Hi PPR Thank you very much for your help. Now i am able to loop all “nameAlias” below one is output data of loop.

Could you guide ma how to get values of firstName, LastName, LogicalId from below data.
{
“message”: “<nameAlias firstName="Saddam" middleName="" lastName="Hussein Al-Tikriti" wholeName="Saddam Hussein Al-Tikriti" function="" gender="M" title="" nameLanguage="" strong="true" regulationLanguage="en" logicalId="17" xmlns="http://eu.europa.ec/fpi/fsd/export\”>\r\n <regulationSummary regulationType="regulation" publicationDate="2003-07-08" numberTitle="1210/2003 (OJ L169)" publicationUrl="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF\" />\r\n",
“level”: “Trace”,
“logType”: “User”,
“timeStamp”: “05:43:29”,
“processVersion”: “1.0.0”,
“jobId”: “e2fe66f9-fb54-411a-b3b2-7eefd05bf6af”,
“robotName”: “ext_machavpn@corp-attended”,
“machineId”: 24,
“organizationUnitId”: 6
}

5

yes we can guide, but as mentioned

or share your XML as a text file with us. We have to refer to the details / structures

6

image

I want get Firstname, lastname, logicalid from CurrentXElement.

Please guide me here. Thanks

8

Please check your post

grafik
grafik642×441 11.5 KB

And kindly note:

9

Hi Yochi,

Please find below XML data.

   <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<export xmlns="http://eu.europa.ec/fpi/fsd/export" generationDate="2023-11-29T17:30:41.005+01:00" globalFileId="158989">
<sanctionEntity designationDetails="" unitedNationId="" euReferenceNumber="EU.27.28" logicalId="13">
    <remark>UNSC RESOLUTION 1483</remark>
    <regulation regulationType="regulation" organisationType="commission" publicationDate="2003-07-08" entryIntoForceDate="2003-07-07" numberTitle="1210/2003 (OJ L169)" programme="IRQ" logicalId="348">
        <publicationUrl>http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF</publicationUrl>
    </regulation>
    <subjectType code="person" classificationCode="P"/>
    <nameAlias firstName="Saddam" middleName="" lastName="Hussein Al-Tikriti" wholeName="Saddam Hussein Al-Tikriti" function="" gender="M" title="" nameLanguage="" strong="true" regulationLanguage="en" logicalId="17">
        <regulationSummary regulationType="regulation" publicationDate="2003-07-08" numberTitle="1210/2003 (OJ L169)" publicationUrl="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF"/>
    </nameAlias>
    <nameAlias firstName="" middleName="" lastName="" wholeName="Abu Ali" function="" title="" nameLanguage="" strong="true" regulationLanguage="en" logicalId="19">
        <regulationSummary regulationType="regulation" publicationDate="2003-07-08" numberTitle="1210/2003 (OJ L169)" publicationUrl="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF"/>
    </nameAlias>
    <nameAlias firstName="" middleName="" lastName="" wholeName="Abou Ali" function="" title="" nameLanguage="FR" strong="true" regulationLanguage="en" logicalId="380">
        <regulationSummary regulationType="regulation" publicationDate="2003-07-08" numberTitle="1210/2003 (OJ L169)" publicationUrl="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF"/>
    </nameAlias>
    <citizenship region="" countryIso2Code="IQ" countryDescription="IRAQ" regulationLanguage="en" logicalId="1">
        <regulationSummary regulationType="regulation" publicationDate="2003-07-08" numberTitle="1210/2003 (OJ L169)" publicationUrl="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF"/>
    </citizenship>
    <birthdate circa="false" calendarType="GREGORIAN" city="al-Awja, near Tikrit" zipCode="" birthdate="1937-04-28" dayOfMonth="28" monthOfYear="4" year="1937" region="" place="" countryIso2Code="IQ" countryDescription="IRAQ" regulationLanguage="en" logicalId="14">
        <regulationSummary regulationType="regulation" publicationDate="2003-07-08" numberTitle="1210/2003 (OJ L169)" publicationUrl="http://eur-lex.europa.eu/LexUriServ/LexUriServ.do?uri=OJ:L:2003:169:0006:0023:EN:PDF"/>
    </birthdate>
</sanctionEntity>
10

Lets assume:

grafik
grafik968×569 157 KB

in general it is about attribute value retrieval
grafik

And
grafik

11

Thank you PPR, Now i am able to get required data.

12

Perfect, so the topic can be closed
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum