Convert JSON to XML in Python

Question

I see a number of questions on SO asking about ways to convert XML to JSON, but I'm interested in going the other way. Is there a python library for converting JSON to XML?

Edit: Nothing came back right away, so I went ahead and wrote a script that solves this problem.

Python already allows you to convert from JSON into a native dict (using json or, in versions < 2.6, simplejson), so I wrote a library that converts native dicts into an XML string.

https://github.com/quandyfactory/dict2xml

It supports int, float, boolean, string (and unicode), array and dict data types and arbitrary nesting (yay recursion).

I'll post this as an answer once 8 hours have passed.

There is no un step process for this conversion, but won't be hard to do using json package, and nay XML processing package. At this very site (stackoverflow.com/a/191617/212952) you can find some hints — Tomas Narros
– Tomas Narros, Commented Jan 24, 2012 at 14:52
In java we have a nice library to convert json to xml github.com/javadev/underscore-java/releases — Valentyn Kolesnikov
– Valentyn Kolesnikov, Commented Jan 8, 2023 at 3:49

Ryan McGreal · Accepted Answer · 2012-01-24 23:56:55Z

58

Nothing came back right away, so I went ahead and wrote a script that solves this problem.

Python already allows you to convert from JSON into a native dict (using json or, in versions < 2.6, simplejson), so I wrote a library that converts native dicts into an XML string.

https://github.com/quandyfactory/dict2xml

It supports int, float, boolean, string (and unicode), array and dict data types and arbitrary nesting (yay recursion).

answered Jan 24, 2012 at 23:56

Ryan McGreal

1,3631 gold badge9 silver badges11 bronze badges

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

1 Comment

thejohnbackes Over a year ago

awesome response to actually build (and maintain!) something to resolve a SO question!

diemacht · Accepted Answer · 2013-10-20 06:30:42Z

20

If you don't have such a package, you can try:

def json2xml(json_obj, line_padding=""):
    result_list = list()

    json_obj_type = type(json_obj)

    if json_obj_type is list:
        for sub_elem in json_obj:
            result_list.append(json2xml(sub_elem, line_padding))

        return "\n".join(result_list)

    if json_obj_type is dict:
        for tag_name in json_obj:
            sub_obj = json_obj[tag_name]
            result_list.append("%s<%s>" % (line_padding, tag_name))
            result_list.append(json2xml(sub_obj, "\t" + line_padding))
            result_list.append("%s</%s>" % (line_padding, tag_name))

        return "\n".join(result_list)

    return "%s%s" % (line_padding, json_obj)

For example:

s='{"main" : {"aaa" : "10", "bbb" : [1,2,3]}}'
j = json.loads(s)
print(json2xml(j))

Result:

<main>
        <aaa>
                10
        </aaa>
        <bbb>
                1
                2
                3
        </bbb>
</main>

answered Oct 20, 2013 at 6:30

diemacht

2,1027 gold badges30 silver badges46 bronze badges

2 Comments

Abhilash Cherukat Over a year ago

It is showing an Unresolved reference error on the recursive call in Python2.7

Ursa Major Over a year ago

given

s = {'person': {'web': {'email': '[email protected]'}, 'address': {'street1': '123 Bar St', 'street2': '', 'state': 'WI', 'zip': 55555, 'city': 'Madison'}}}

. It is giving ` j = json.loads(s) File "/usr/lib/python2.7/json/__init__.py", line 338, in loads return _default_decoder.decode(s) File "/usr/lib/python2.7/json/decoder.py", line 366, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end()) File "/usr/lib/python2.7/json/decoder.py", line 382, in raw_decode obj, end = self.scan_once(s, idx) ValueError: Expecting property name: line 1 column 2 (char 1)`

Community · Accepted Answer · 2017-05-23 12:02:41Z

15

Load it into a dict using json.loads then use anything from this question...

Serialize Python dictionary to XML

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Jan 24, 2012 at 17:18

wmil

3,1892 gold badges24 silver badges24 bronze badges

Comments

Anurag Misra · Accepted Answer · 2018-09-28 12:04:09Z

4

Use dicttoxml to convert JSON directly to XML

Installation
pip install dicttoxml
or
easy_install dicttoxml

In [2]: from json import loads

In [3]: from dicttoxml import dicttoxml

In [4]: json_obj = '{"main" : {"aaa" : "10", "bbb" : [1,2,3]}}'

In [5]: xml = dicttoxml(loads(json_obj))

In [6]: print(xml)
<?xml version="1.0" encoding="UTF-8" ?><root><main type="dict"><aaa type="str">10</aaa><bbb type="list"><item type="int">1</item><item type="int">2</item><item type="int">3</item></bbb></main></root>

In [7]: xml = dicttoxml(loads(json_obj), attr_type=False)

In [8]: print(xml)
<?xml version="1.0" encoding="UTF-8" ?><root><main><aaa>10</aaa><bbb><item>1</item><item>2</item><item>3</item></bbb></main></root>

For more information on dicttoxml

answered Sep 28, 2018 at 12:04

Anurag Misra

1,57420 silver badges24 bronze badges

1 Comment

MichaelR Over a year ago

this is the same library the user who asked the question wrote..and posted inside the question..........

Jortega · Accepted Answer · 2023-11-01 23:56:16Z

2

I found xmltodict to be useful. Looks like it was released after some of the posts here. https://pypi.org/project/xmltodict/

import xmltodict
import json
sample_json = {"note": {"to": "Tove", "from": "Jani", "heading": "Reminder", "body": "Don't forget me this weekend!"}}
#############
#json to xml
#############
json_to_xml = xmltodict.unparse(sample_json)
print(json_to_xml)
#############
#xml to json
#############
x_to_j_dict = xmltodict.parse(json_to_xml)
x_to_j_string = json.dumps(x_to_j_dict)
back_to_json = json.loads(x_to_j_string)
print(back_to_json)

edited Nov 1, 2023 at 23:56

answered Nov 9, 2021 at 20:47

Jortega

3,8081 gold badge22 silver badges23 bronze badges

Comments

Kye · Accepted Answer · 2019-03-04 12:01:28Z

1

from json import loads
from dicttoxml import dicttoxml

s='{"main" : {"aaa" : "10", "bbb" : [1,2,3]}}'
xml = dicttoxml(loads(s))

Or if your data is stored in a pandas data.frame as mine often is:

df['xml'] = df['json'].apply(lambda s: dicttoxml(json.loads(s))

edited Mar 4, 2019 at 12:01

Kye

4,5413 gold badges25 silver badges49 bronze badges

answered Aug 3, 2018 at 15:31

cangers

4083 silver badges9 bronze badges

Comments

Rishabh Jhalani · Accepted Answer · 2024-05-07 11:50:18Z

Raw Python code to convert JSON to XML

Let say, JSON data is

json_data = {
'name': 'Your Name',
'age': 27,
'email': '',
'marks': {
    'hindi': 90,
    'math': 90,
    'english': 90,
    'physics': 90,
    'chemistry': None
   }
}

Python code

Import this

import xml.etree.ElementTree as ET

root = ET.Element("root")
def json_to_xml(parent_var, keyname, value):
    new_ele = ET.SubElement(parent_var, keyname)
    if value:
        if isinstance(value, dict):
            for k, v in value.items():
                json_to_xml(new_ele, k, v)
        else:
            new_ele.text = str(value)


for key, value in json_data.items():
    json_to_xml(root, key, value)

tree = ET.ElementTree(root)
# Write to file
tree.write("output.xml", encoding='utf-8', xml_declaration=True)

Final XML is exported in the output.xml file.

Collectives™ on Stack Overflow

Convert JSON to XML in Python

7 Answers 7

1 Comment

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

2 Comments

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related