BLACKLIST XML -- parser is in python code.

 <row>

  <B>

    <BlackListBulkSearch>

      <SerialNumber>123</SerialNumber>

      <Item>

        <BlackListStatus>YES</BlackListStatus>

        <BlackListNo>10</BlackListNo>

        <BlackListedDate>2046-11-21</BlackListedDate>

        <Name>HETAUDA LEATHER INDUSTRIES</Name>

        <FatherName>NULL</FatherName>

        <CitizenshipNo>NULL</CitizenshipNo>

        <CitizenshipIssuedDate>NULL</CitizenshipIssuedDate>

        <CitizenshipIssuedDistrict>NULL</CitizenshipIssuedDistrict>

        <PanNo>NULL</PanNo>

        <CompanyRegNo>002-2701-8-1</CompanyRegNo>

        <ConsumerDOB>NULL</ConsumerDOB>

        <CompanyRegDate>1999-12-31</CompanyRegDate>

        <CompanyRegAuth>Office Of Company Registrar</CompanyRegAuth>

        <PassportNo>NULL</PassportNo>

        <IndianEmbassyNo>NULL</IndianEmbassyNo>

      </Item>

      <Item>

        <BlackListStatus>YES</BlackListStatus>

        <BlackListNo>10</BlackListNo>

        <BlackListedDate>2046-11-21</BlackListedDate>

        <Name>BANSBARI LEATHER AND SHOE FACTORY</Name>

        <FatherName>NULL</FatherName>

        <CitizenshipNo>NULL</CitizenshipNo>

        <CitizenshipIssuedDate>NULL</CitizenshipIssuedDate>

        <CitizenshipIssuedDistrict>NULL</CitizenshipIssuedDistrict>

        <PanNo>NULL</PanNo>

        <CompanyRegNo>002-2701-8-1-2</CompanyRegNo>

        <ConsumerDOB>NULL</ConsumerDOB>

        <CompanyRegDate>1999-12-31</CompanyRegDate>

        <CompanyRegAuth>Office Of Company Registrar</CompanyRegAuth>

        <PassportNo>NULL</PassportNo>

        <IndianEmbassyNo>NULL</IndianEmbassyNo>

      </Item>

      <Item>

        <BlackListStatus>YES</BlackListStatus>

        <BlackListNo>20</BlackListNo>

        <BlackListedDate>2047-01-03</BlackListedDate>

        <Name>BIDHYA DEVI BHATTARAI</Name>

        <FatherName>NA</FatherName>

        <CitizenshipNo>002-3401-2-1-1</CitizenshipNo>

        <CitizenshipIssuedDate>2010-01-01</CitizenshipIssuedDate>

        <CitizenshipIssuedDistrict>Kathmandu</CitizenshipIssuedDistrict>

        <PanNo>NULL</PanNo>

        <CompanyRegNo>NULL</CompanyRegNo>

        <ConsumerDOB>1999-12-31</ConsumerDOB>

        <CompanyRegDate>NULL</CompanyRegDate>

        <CompanyRegAuth>NULL</CompanyRegAuth>

        <PassportNo>NULL</PassportNo>

        <IndianEmbassyNo>NULL</IndianEmbassyNo>

      </Item>

    </BlackListBulkSearch>

  </B>

</row>




import xml.etree.ElementTree as ET
data= '''
<BlackListBulkSearch>
<SerialNumber>123</SerialNumber>
<Item>
<BlackListStatus>YES</BlackListStatus>
<BlackListNo>10</BlackListNo>
</Item>
<Item>
<BlackListStatus>YES</BlackListStatus>
<BlackListNo>500</BlackListNo>
</Item>
</BlackListBulkSearch>'''

myroot = ET.fromstring(data)
print(myroot.tag)
#print(myroot[0].tag) #denotes first child
#print(myroot[0].attrib) #attrib are present as dictionary

#for x in myroot[0]:
#print(x.tag,x.attrib)

#for x in myroot[0]:
#print(x.text)

for x in myroot.findall('Item'):
item =x.find('BlackListStatus').text
froms =x.find('BlackListNo').text

print(item,froms)

Comments