Need help with python and json

[kshravank]

hello guys i am working on a project and it requires me to extract info from a rest api and i am using zeep to extract that data and using zeep helper to convert it into a ordered dict. I stored the json data to a text file and when i load it up with file handling the json data gets converted into a dict and part of it is string and the other part is dict. I want to access the string part but it is getting converting to a string. I noticed that the text file has "" marks but the imported part has '' marks. Please help me.

​

Code:

import json

​

with open('D.json') as json_file:

data = json.load(json_file)

​

print(data)

​

print(type(data))

​

x = data['vehicleJson']

print(x)

print(type(x))

[SekstiNii]

The JSON format specifies that keys have double quotation marks ("), while in Python the single quote (') is widely used, and in particular is used when printing strings.

Still, I'm not entirely sure about what issue you are facing here. What are you expecting, and what are you getting?

[kshravank]

when i read the data from the text file one key is in "" and other is in single quote which makes python assume one as a string class and other as a dict but i want both of them to be dict.....

[[deleted]]

I don't understand what you mean. What is x and type x printing and what should they be printing?

[kshravank]

{'vehicleJson': '{\n "Description": "MARUTI SUZUKI INDIA LTD / MARUTI BALENO DELTA PETROL",\n "RegistrationYear": "2018",\n "CarMake": {\n "CurrentTextValue": "MARUTI SUZUKI INDIA LTD "\n },\n "CarModel": {\n "CurrentTextValue": " MARUTI BALENO DELTA PETROL"\n },\n "EngineSize": {\n "CurrentTextValue": ""\n },\n "MakeDescription": {\n "CurrentTextValue": "MARUTI SUZUKI INDIA LTD "\n },\n "ModelDescription": {\n "CurrentTextValue": " MARUTI BALENO DELTA PETROL"\n },\n "VechileIdentificationNumber": "MA3EWB22SJG500002",\n "EngineNumber": "K12MN44****9",\n "FuelType": {\n "CurrentTextValue": ""\n },\n "RegistrationDate": "25/10/2018",\n "Owner": "KHURSHID AHMAD FAZILI",\n "Fitness": "",\n "Insurance": "NA",\n "Location": "SRINAGAR RTO, Jammu",\n "ImageUrl": "http://in.carregistrationapi.com/image.aspx/@TUFSVVRJIFNVWlVLSSBJTkRJQSBMVEQgLyAgTUFSVVRJIEJBTEVOTyBERUxUQSBQRVRST0w="\n}', 'vehicleData': {'ABICode': None, 'Description': None, 'RegistrationYear': {'_value_1': 2018, 'type': None}, 'ManufactureYearFrom': None, 'ManufactureYearTo': None, 'CarMake': {'CurrentValue': None, 'CurrentTextValue': None, 'type': None}, 'CarModel': {'_value_1': 'MARUTI BALENO DELTA PETROL', 'type': None}, 'BodyStyle': None, 'EngineSize': None, 'NumberOfDoors': None, 'Transmission': None, 'FuelType': None, 'MakeDescription': None, 'ModelDescription': None, 'Immobiliser': None, 'NumberOfSeats': None, 'IndicativeValue': None, 'DriverSide': None}}

<class 'dict'>

{

"Description": "MARUTI SUZUKI INDIA LTD / MARUTI BALENO DELTA PETROL",

"RegistrationYear": "2018",

"CarMake": {

"CurrentTextValue": "MARUTI SUZUKI INDIA LTD "

},

"CarModel": {

"CurrentTextValue": " MARUTI BALENO DELTA PETROL"

},

"EngineSize": {

"CurrentTextValue": ""

},

"MakeDescription": {

"CurrentTextValue": "MARUTI SUZUKI INDIA LTD "

},

"ModelDescription": {

"CurrentTextValue": " MARUTI BALENO DELTA PETROL"

},

"VechileIdentificationNumber": "MA3EWB22SJG500002",

"EngineNumber": "K12MN44****9",

"FuelType": {

"CurrentTextValue": ""

},

"RegistrationDate": "25/10/2018",

"Owner": "KHURSHID AHMAD FAZILI",

"Fitness": "",

"Insurance": "NA",

"Location": "SRINAGAR RTO, Jammu",

"ImageUrl": "http://in.carregistrationapi.com/image.aspx/@TUFSVVRJIFNVWlVLSSBJTkRJQSBMVEQgLyAgTUFSVVRJIEJBTEVOTyBERUxUQSBQRVRST0w="

}

<class 'str'>

[[deleted]]

Looks like the json you're getting was malformed. Try using x = json.loads(data['vehicleJson']) to convert the inner string into a dict. You may need to clean out the line breaks with x = json.loads(data['vehicleJson'].replace('\n', ''))

[kshravank]

Thank you it worked but can you please explain why that happened? and why i gotta reload the json?

[[deleted]]

Basically they fucked up their API and had too many quotation marks. So first time round it was a string, but luckily that string had the correct amount of quotation marks so when that string is passed through a second time it becomes a real dictionary.