Python Forum
Thread Rating:
  • 1 Vote(s) - 4 Average
  • 1
  • 2
  • 3
  • 4
  • 5
converting json to xml
#1
HI,
I am new to python and learning , need help converting json file to xml . I have below code ( found on web ) modified a bit but is not parsing the whole file only few lines: 
appreciate any help! Cry
Thanks!
Output:
Output:
<Core> <case_id> CASE_17BC95 </case_id> <case_id> CASE_17D59E </case_id> </Core>t] Process finished with exit code 0
here is the code:
import json

def json2xml(json_obj, Line_spacing=""):
   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_spacing))

       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_spacing, tag_name))
           result_list.append(json2xml(sub_obj, "\t" + Line_spacing))
           result_list.append("%s</%s>" % (Line_spacing, tag_name))
           # print(result_list)
           return "\n".join(result_list)
   return "%s%s" % (Line_spacing, json_obj)

with open ("C://Users//test//Documents//json2.txt") as s:
data = json.load(s)
print(json2xml(data))
Reply


Messages In This Thread
converting json to xml - by pasi12 - Mar-10-2017, 06:33 PM
RE: converting json to xml - by dudeisbrendan03 - Mar-10-2017, 07:07 PM
RE: converting json to xml - by pasi12 - Mar-10-2017, 07:53 PM
RE: converting json to xml - by dudeisbrendan03 - Mar-10-2017, 09:14 PM
RE: converting json to xml - by zivoni - Mar-10-2017, 09:36 PM
RE: converting json to xml - by dudeisbrendan03 - Mar-10-2017, 09:40 PM
RE: converting json to xml - by pasi12 - Mar-10-2017, 09:46 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,620 Jan-29-2023, 03:59 PM
Last Post: eyavuz21
  Converting cells in excel to JSON format desmondtay 4 1,775 May-23-2022, 10:31 AM
Last Post: Larz60+
  Trouble converting JSON String to Dictionary RBeck22 7 5,176 Mar-28-2019, 12:12 PM
Last Post: RBeck22

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020