Django JSON string to json object

Question

I am using mongodb with django and want to store json object in mongodb. Here is my code

Model

class Data(models.Model):
    deviceId = models.CharField(max_length=200)
    payload = models.CharField(max_length=2000)

View save data

deviceId = request.POST.get('deviceId')
payload = request.POST.get('payload')
data = Data.objects.create(deviceId=deviceId, payload=payload);
data.save()

View fetch data

data = json.dumps(list(Data.objects.all().values('deviceId','payload')))

Response

{
  "data":{
   "payloads":"{name:\"xyz\"}"
  "id":"xxxxx"
  },
}

The problem is with "payloads":"{name:\"xyz\"}". Here is a string instead of json Object.

I want "payloads":"{name:"xyz"}". How can convert this into json object in django. Is there anyway to convert all of the dataset into json object instead of iterating each object from dataset

Malcolm Murdoch · Accepted Answer · 2014-02-25 12:50:09Z

1

I think you should be able to just remove the json.dumps part of the script. That's a python command to translate a valid JSON object into a string!

data = list(Data.objects.all().values('deviceId','payload'))

answered Feb 25, 2014 at 12:50

Malcolm Murdoch

1,0856 silver badges9 bronze badges

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

1 Comment

Muhammad Usman Over a year ago

No, Actually it returns a list and I want response in json

mmvsbg · Accepted Answer · 2016-11-30 16:45:20Z

0

To store JSON I recommended to use JSONField.

from jsonfield import JSONField
class Data(models.Model):
    deviceId = models.CharField(max_length=200)
    payload = models.JSONField(max_length=2000)

edited Nov 30, 2016 at 16:45

mmvsbg

3,58417 gold badges56 silver badges74 bronze badges

answered Nov 30, 2016 at 15:58

slav

891 silver badge8 bronze badges

Collectives™ on Stack Overflow

Django JSON string to json object

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related