XML (Extensible Markup Language) can create elements to store data. It is used for exchanging structured data over APIs and applications. JSON (JavaScript Object Notation) is also a very commonly used data structure notation to transfer the data between APIs and web applications. It is based on arrays and dictionaries. It was built as an improvement over XML.<\/p>\n
The Python programming language has modules available to parse both JSON and XML data. There is no direct method to convert XML to JSON so we will use a dictionary as an intermediary. We will learn how to perform this conversion in this article.
\n
Table of Contents<\/p>
xmltodict<\/code> and json<\/code> module to convert XML data to JSON<\/span><\/h2>\nThe xmltodict<\/code> is a module used to read and parse XML data to dictionary and list type structures. We can use the xmltodict.parse()<\/code> function from this module to achieve this. <\/p>\nWe can then use the json<\/code> module to write this data to JSON type. The json.dump()<\/code> function can write the given object to a JSON string. <\/p>\nSee the following code.<\/p>\n
\nimport xmltodict, json\nxml_string = \"\"\"\n \n 102<\/id>\n Mark<\/name>\n Accounts<\/dept>\n 75000<\/sal>\n <\/emp>\n\"\"\"\nd = xmltodict.parse(xml_string)\njson_str = json.dumps(d)\nprint(json_str) \n<\/pre>\nOutput:<\/p>\n
\n{“emp”: {“id”: “102”, “name”: “Mark”, “dept”: “Accounts”, “sal”: “75000”}}\n<\/div>\nIn the above example,<\/p>\n
\n- We created an object which stores the XML string.<\/li>\n
- The
xmltodict.parse()<\/code> function parses this to a dictionary type object.<\/li>\n- We pass this object to the
json.dump()<\/code> function which returns a JSON formatted string.<\/li>\n<\/ul>\nUsing the xml.etree.ElementTree<\/code> and json<\/code> module to convert XML data to JSON<\/span><\/h2>\nThe xml.etree<\/code> module is an efficient method to parse the XML data as a tree. We can use this module to create a user-defined function that will parse our XML string to a dictionary, which we can write as a JSON file using the json<\/code> module.<\/p>\nSee the code below.<\/p>\n
\nfrom collections import defaultdict\nfrom xml.etree import ElementTree as ET\ndef xmldict(t):\n d = {t.tag: {} if t.attrib else None}\n children = list(t)\n if children:\n dd = defaultdict(list)\n for dc in map(xmldict, children):\n for k, v in dc.items():\n dd[k].append(v)\n d = {t.tag: {k: v[0] if len(v) == 1 else v\n for k, v in dd.items()}}\n if t.text:\n text = t.text.strip()\n if children or t.attrib:\n if text:\n d[t.tag]['#text'] = text\n else:\n d[t.tag] = text\n return d\nxml_string = \"\"\"\n \n 102<\/id>\n Mark<\/name>\n Accounts<\/dept>\n 75000<\/sal>\n <\/emp>\n\"\"\"\nxml_data = ET.XML(xml_string)\nd = xmldict(xml_data)\njson_str = json.dumps(d)\nprint(json_str) \n<\/pre>\nOutput:<\/p>\n
\n{“emp”: {“id”: “102”, “name”: “Mark”, “dept”: “Accounts”, “sal”: “75000”}}\n<\/div>\nNow, let us understand what we implemented in the above code.<\/p>\n
\n- We pass the XML string using the
ET.XML()<\/code> function.<\/li>\n- We pass this data to a function called
xmldict()<\/code>.<\/li>\n- We process this data to return a dictionary.<\/li>\n
- This dictionary is then passed to the
json.dump()<\/code> function, which returns the final JSON data.<\/li>\n<\/ul>\nUsing the xmljson<\/code> and json<\/code> module to convert XML data to JSON<\/span><\/h2>\nThe xmljson<\/code> is a new and simple library available to process XML data in Python. It provides different objects to parse the data differently. <\/p>\nWe can use the xmljson.Yahoo()<\/code> constructor to initialize an object that can be used to work with XML string. The xtree.ElementTree.fromstring()<\/code> function returns an XML string, and we use the data()<\/code> function with this object to parse this string. This will return a dictionary with the required data.<\/p>\nThen as we did earlier, we convert this dictionary to JSON using the json.dump()<\/code> function.<\/p>\nFor example,<\/p>\n
\nimport xmljson\nfrom xml.etree import ElementTree as ET\nxml_string = \"\"\"\n \n 102<\/id>\n Mark<\/name>\n Accounts<\/dept>\n 75000<\/sal>\n <\/emp>\n\"\"\"\nP = xmljson.Yahoo(dict_type = dict)\nd = P.data(ET.fromstring(xml_string))\njson_str = json.dumps(d)\nprint(json_str) \n<\/pre>\nOutput:<\/p>\n
\n{“emp”: {“id”: “102”, “name”: “Mark”, “dept”: “Accounts”, “sal”: “75000”}}\n<\/div>\nThat’s all about how to convert XML to JSON in Python.<\/p>\n","protected":false},"excerpt":{"rendered":"
Table of ContentsUsing the xmltodict and json module to convert XML data to JSONUsing the xml.etree.ElementTree and json module to convert XML data to JSONUsing the xmljson and json module to convert XML data to JSON XML (Extensible Markup Language) can create elements to store data. It is used for exchanging structured data over APIs […]<\/p>\n","protected":false},"author":1,"featured_media":16514,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_mi_skip_tracking":false},"categories":[145],"tags":[],"_links":{"self":[{"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/posts\/16433"}],"collection":[{"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/comments?post=16433"}],"version-history":[{"count":0,"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/posts\/16433\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/media\/16514"}],"wp:attachment":[{"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/media?parent=16433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/categories?post=16433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/java2blog.com\/wp-json\/wp\/v2\/tags?post=16433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}