Help with deserialization with XML

Help Studio
, ,
1
<?xml version="1.0" encoding="UTF-8"?>

<ebn:EBNBatch xmlns=“urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CoreFilingMessage-4.0” xmlns:ebn=“http://bankruptcynotices.uscourts.gov/EBN-BankruptcyCase” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=“http://bankruptcynotices.uscourts.gov/EBN-BankruptcyCase http://bankruptcynotices.uscourts.gov/EBN-BankruptcyCase/1.2/EBN-BankruptcyCase.xsd” xmlns:ecf=“urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:CommonTypes-4.0” xmlns:bankruptcy=“urn:oasis:names:tc:legalxml-courtfiling:schema:xsd:BankruptcyCase-4.0” xmlns:j=“http://niem.gov/niem/domains/jxdm/4.0” xmlns:nc=“http://niem.gov/niem/niem-core/2.0” xmlns:s=“http://niem.gov/niem/structures/2.0” >

nc:DocumentIdentification
nc:IdentificationID21-802-135889-1 </nc:IdentificationID>
</nc:DocumentIdentification>
nc:DocumentPostDate
nc:DateTime2021-04-20T18:39:23 </nc:DateTime>
</nc:DocumentPostDate>
ecf:SendingMDELocationID
nc:IdentificationIDBNC </nc:IdentificationID>
</ecf:SendingMDELocationID>
ecf:SendingMDEProfileCodePDF_Embedded_XML</ecf:SendingMDEProfileCode>
ebn:BankruptcyCase
nc:CaseTitleText
OLIVE OIL &
HERMAN MUNSTER
</nc:CaseTitleText>

nc:CaseCategoryTextBK</nc:CaseCategoryText>
nc:CaseDocketID0:21-bk-12345-MN</nc:CaseDocketID>
<j:CaseAugmentation>
<j:CaseCourt>
nc:OrganizationIdentification
nc:IdentificationID0970-0 </nc:IdentificationID>
</nc:OrganizationIdentification>
nc:OrganizationLocation
nc:LocationAddress
nc:StructuredAddress
nc:LocationStreet
nc:StreetFullText325 W 19TH ST </nc:StreetFullText>
nc:StreetFullTextSTE D </nc:StreetFullText>
</nc:LocationStreet>
nc:LocationCityNameABCD </nc:LocationCityName>
nc:LocationStateUSPostalServiceCodeAZVH </nc:LocationStateUSPostalServiceCode>
nc:LocationPostalCode858884-5624677 </nc:LocationPostalCode>
</nc:StructuredAddress>
</nc:LocationAddress>
</nc:OrganizationLocation>
nc:OrganizationNameUnited States Bankruptcy Court </nc:OrganizationName>
nc:OrganizationNameDistrict of Arizona </nc:OrganizationName>
nc:OrganizationPrimaryContactInformation

I need some help with deserialization of above XML. Need to extract information like CaseTitleText, location etc.

2

You have to handle the XML Namespaces as described here

in case of further assistance is needed then please share with us the XML as text file. Thanks

3

Hi, Thank you for the response. I have attached the .txt file here. I need information like nc:CaseTitleText, nc:CaseDocketID, nc:DateTime etc…
XML.txt (11.0 KB)

4

it was necessairy to fix the XML
OLIVE OIL & → &amp; HERMAN MUNSTER or use CDATA

As described within the linked POST

Namespace analysis:
grafik

we do know the default namespace and the used namespace of nc: prefix

Setting up the nc namespace Variable:
grafik

Retrieval:
grafik

Prototypes done within immediate panel
Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

5

can you please send me the flow if possible ? much appreciated.

6

Was done within immediate panel, so use assign activities for it. Ther is no shareable XAML
Basics are also described within the topic

XML Deserialization we do:

grafik

8

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