How to remove @ prefix while converting xml to json in Python

Question

I'm trying to convert xml to json in python using xmltodict library. Though, the xml is getting converted to json, before every key in dict, '@' is getting prefixed. Below is the code snippet and sample output:

import xmltodict
import json

with open('response.xml','r') as res_file:
    doc = xmltodict.parse(res_file.read())

xml_json_str = json.dumps(doc)
final_json = json.loads(xml_json_str)

Output:

"CustomerInfo": {
  "@address": "Bangalore, Karnataka 560034",
  "@email": "[email protected]",
  "@name": "Sam",
}

How to remove @ from all key's at one go?

@Solen'ya: Below is the xml content. <?xml version="1.0" encoding="UTF-8" standalone="no"?> <PIR:Data xmlns:PIR="google.com"> <CustomerInfo address="Bangalore, Karnataka 560034" email="[email protected]" name="Sam"/> </PIR:Data> — Sumit
– Sumit, Commented Dec 19, 2019 at 7:03

Sumit · Accepted Answer · 2019-12-19 11:00:37Z

6

Finally I found a solution which works like charm. While parsing the xml, set attr_prefix='' to remove all @ from keys.

Below changes worked for me:

with open('response.xml','r') as res_file:
    doc = xmltodict.parse(res_file.read(), attr_prefix='')

answered Dec 19, 2019 at 11:00

Sumit

1,4603 gold badges20 silver badges30 bronze badges

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

Comments

Vaibhav Jadhav · Accepted Answer · 2019-12-19 07:25:35Z

-1

Check this out: It will remove all the @ from all keys be it in any node: I have added one extra note just to show you the example:

def removeAtTheRate(jsonFile,final_json_edited):
    if jsonFile != {} and type(jsonFile) == dict:
        for i in jsonFile.keys():
            final_json_values = {}
            for j in jsonFile[i]:
                if j[:1] == '@':
                    final_json_values[j[1:]] = jsonFile[i][j]
            if i[:1] == '@':
                final_json_edited[i[1:]] = final_json_values
            else:
                final_json_edited[i] = final_json_values
    print(final_json_edited)

doc = {"@CustomerInfo":{"@address": "Bangalore, Karnataka 560034","@email": "[email protected]","@name": "Sam"},"Location":{"@Loc":"Mum"}}
removeAtTheRate(doc,{})

Result:

>> {'Location': {'Loc': 'Mum'}, 'CustomerInfo': {'name': 'Sam', 'address': 
'Bangalore, Karnataka 560034', 'email': '[email protected]'}}

edited Dec 19, 2019 at 7:25

answered Dec 19, 2019 at 7:09

Vaibhav Jadhav

2,0941 gold badge9 silver badges20 bronze badges

2 Comments

Vaibhav Jadhav Over a year ago

The solution by @steve.dev will give wrong output. It will delete the "C" from CustomerInfo key

Sumit Over a year ago

@ Vaibhav Jadhav: Unfortunately your solution didn't work for my complex json.

Collectives™ on Stack Overflow

How to remove @ prefix while converting xml to json in Python

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related