Getting values of XML attributes In Python

Question

I'm new to Python and I need to fetch some of the attribute values from a XML file and then to convert these values to JSON.

example:

<messages> 
    <to>Tove</to>
    <from>Jani</from>
    <heading>Reminder</heading>
    <body>Dont forget me this weekend!</body>
</messages>

{
"from":"Jani",
"body":"Dont forget me this weekend!"
}

How can I best achieve this? Would I convert it to JSON first? If yes, which library would I use? Lxml? Or would I convert it to String and then use regex to get some of the values?

black panda · Accepted Answer · 2019-11-27 20:09:56Z

2

You can use the ElementTree API to parse your XML text and get the desired values out of it.

Then you can use the JSON API to create the desired JSON output.

answered Nov 27, 2019 at 20:09

black panda

3,0111 gold badge23 silver badges28 bronze badges

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

Comments

xinjie zhang · Accepted Answer · 2019-12-31 07:52:26Z

1

I notice that your json format is just like a python dict.

from xml.dom import minidom

data = {}
with open('email.xml', 'r', encoding='utf8') as fh:
    dom = minidom.parse(fh)
# Get root element
root = dom.documentElement
for tag in root.childNodes:
    if tag.nodeType != tag.TEXT_NODE:
        key = tag.nodeName
        value = tag.childNodes[0].data
        data[key] = value
print(data)

Output is: {'to': 'Tove', 'from': 'Jani', 'heading': 'Reminder', 'body': 'Dont forget me this weekend!'}

If u want to understand xml more deeply, some component you need to know, such as root, element, node, tag, attribute and so on.

edited Dec 31, 2019 at 7:52

answered Dec 31, 2019 at 7:27

xinjie zhang

253 bronze badges

Collectives™ on Stack Overflow

Getting values of XML attributes In Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related