find corresponding attribute in xml with python

Question

I have this xml:

<?xml version="1.0" encoding="utf-8" ?> 
<ArrayOfEMObject2 xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.blue-order.com/ma/essencemanagerws/EssenceManager">
    <EMObject2>
        <emguid>727ef486-31b3-48c3-b38e-39561995ef80</emguid> 
        <orgname>2435e6b6-e19a-4ca5-a708-47f7d9387bb9.wav</orgname> 
        <streamclass>AUDIO</streamclass> 
        <streamtype>WAV</streamtype> 
        <prefusage>BROWSE</prefusage> 
    </EMObject2>
    <EMObject2>
        <emguid>e866abef-7571-45a7-84be-85f2ffc35b31</emguid> 
        <orgname>201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3</orgname> 
        <streamclass>AUDIO</streamclass> 
        <streamtype>MP3</streamtype> 
        <prefusage>AUX</prefusage> 
    </EMObject2>
    <EMObject2>
        <emguid>f02ab3db-93c8-4cbf-82b8-5fb06704a4ea</emguid> 
        <orgname>201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3</orgname> 
        <streamclass>AUDIO</streamclass> 
        <streamtype>MP3</streamtype> 
        <prefusage>AUX</prefusage> 
    </EMObject2>

If the streamtypeis MP3, I need the corresponding emguid and orgname.

I already have this:

from xml.etree import ElementTree
# ...
namespace = '{http://www.blue-order.com/ma/essencemanagerws/EssenceManager}'
for child in root.findall('.//{}streamtype'.format(namespace)):
    if child.text == 'MP3':

How should I proceed here?

Which XML parser are you using?

tripleee
– tripleee

2020-12-17 09:04:51 +00:00
Commented Dec 17, 2020 at 9:04 — tripleee
– tripleee, Commented Dec 17, 2020 at 9:04
I'm using ElementTree

user2811144
– user2811144

2020-12-17 09:10:06 +00:00
Commented Dec 17, 2020 at 9:10 — user2811144
– user2811144, Commented Dec 17, 2020 at 9:10

chinmaygadkari · Accepted Answer · 2020-12-17 09:57:13Z

1

You can find and check the streamtype tag and then retrieve the other information like this:

from xml.etree import ElementTree
# ...
namespace = '{http://www.blue-order.com/ma/essencemanagerws/EssenceManager}'
for child in root.findall('.//{}EMObject2'.format(namespace)):
    if child.find('{}streamtype'.format(namespace)).text == 'MP3':
        print(child.find('{}emguid'.format(namespace)).text)
        print(child.find('{}orgname'.format(namespace)).text)

answered Dec 17, 2020 at 9:57

chinmaygadkari

464 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

yazz · Accepted Answer · 2020-12-17 09:13:11Z

Try this.

from simplified_scrapy import SimplifiedDoc,utils

xml = '''
<?xml version="1.0" encoding="utf-8" ?> 
<ArrayOfEMObject2 xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.blue-order.com/ma/essencemanagerws/EssenceManager">
    <EMObject2>
        <emguid>727ef486-31b3-48c3-b38e-39561995ef80</emguid> 
        <orgname>2435e6b6-e19a-4ca5-a708-47f7d9387bb9.wav</orgname> 
        <streamclass>AUDIO</streamclass> 
        <streamtype>WAV</streamtype> 
        <prefusage>BROWSE</prefusage> 
    </EMObject2>
    <EMObject2>
        <emguid>e866abef-7571-45a7-84be-85f2ffc35b31</emguid> 
        <orgname>201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3</orgname> 
        <streamclass>AUDIO</streamclass> 
        <streamtype>MP3</streamtype> 
        <prefusage>AUX</prefusage> 
    </EMObject2>
    <EMObject2>
        <emguid>f02ab3db-93c8-4cbf-82b8-5fb06704a4ea</emguid> 
        <orgname>201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3</orgname> 
        <streamclass>AUDIO</streamclass> 
        <streamtype>MP3</streamtype> 
        <prefusage>AUX</prefusage> 
    </EMObject2>
'''
doc = SimplifiedDoc(xml)
lst = doc.selects('streamtype').contains('MP3').parent
print ([(l.emguid.text,l.orgname.text) for l in lst])

# Or
lst = doc.selects('EMObject2')
for l in lst:
    if l.streamtype.text=='MP3':
        print (l.emguid.text,l.orgname.text)

Result:

[('e866abef-7571-45a7-84be-85f2ffc35b31', '201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3'), ('f02ab3db-93c8-4cbf-82b8-5fb06704a4ea', '201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3')]
e866abef-7571-45a7-84be-85f2ffc35b31 201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3
f02ab3db-93c8-4cbf-82b8-5fb06704a4ea 201701191006474010024190133005056B91BF30000003352B00000D0F094671.mp3

tripleee · Accepted Answer · 2020-12-17 09:29:08Z

0

Here's an attempt which instead seeks the EMObject2 instances and checks their children.

namespace = '{http://www.blue-order.com/ma/essencemanagerws/EssenceManager}'
tags = {'{}{}'.format(namespace, tag): tag
        for tag in ('orgname', 'streamtype', 'emguid')}
for node in root.findall('.//{}EMObject2'.format(namespace)):
    match = dict()
    for child in node:
        if child.tag in tags:
            match[tags[child.tag]] = child.text
    try:
        if match['streamtype'] == 'MP3':
            print(match['orgname'], match['emguid'])
    except KeyError:
        pass

(I had to repair your XML by adding a closing tag to get this to run.)

answered Dec 17, 2020 at 9:29

tripleee

192k37 gold badges318 silver badges369 bronze badges

1 Comment

tripleee Over a year ago

There is probably a more idiomatic way to solve this but at least it gets the job done.

Collectives™ on Stack Overflow

find corresponding attribute in xml with python

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related