How to read the xml part from json file in python3?

Question

I have below json with xml file. I am looking for a solution to extract the xml part and traverse xml attribute using python 'ElementTree' or any other library ..

{
   "Data":{
      "myevent":{
         "payload":"<note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don't forget me this weekend!</body></note>",
         "meta_data":{
            "Env":"l1-7",
            "EventName":"myEventName",
            "Source":"mysource",
            "Hash":"myhash",
            "PayloadKey":"mypayload",
            "ByteSize":300,
            "EventTim":"myTime",
            "Entity":"myEntity",
            "version":"myVersion"
         }
      }
   }
}

Now I want to extract the "payload" value as a XML, so I can traverse it for further transformation using Python ElementTree library.

Appreciated if anybody can help on this.

Thanks

What is the problem? Have you tried anything at all?

mzjn
– mzjn

2020-12-08 06:46:43 +00:00
Commented Dec 8, 2020 at 6:46 — mzjn
– mzjn, Commented Dec 8, 2020 at 6:46

costaparas · Accepted Answer · 2020-12-08 06:51:40Z

To extract the payload (the XML), you can just index the data as you normally do in Python for dicts. This will give you a Python string. Then, you can pass it to the fromstring method so that you can traverse it.

Example:

import xml.etree.ElementTree as ET


data = {
   "Data":{
      "myevent":{
         "payload":"<note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don't forget me this weekend!</body></note>",
         "meta_data":{
            "Env":"l1-7",
            "EventName":"myEventName",
            "Source":"mysource",
            "Hash":"myhash",
            "PayloadKey":"mypayload",
            "ByteSize":300,
            "EventTim":"myTime",
            "Entity":"myEntity",
            "version":"myVersion"
         }
      }
   }
}

tree = ET.fromstring(data['Data']['myevent']['payload'])
for element in tree:
    print(element.text)

Collectives™ on Stack Overflow

How to read the xml part from json file in python3?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related