Object of type QuerySet is not JSON serializable Django

Question

When I am trying to send values in JsonResponse then The error is coming(object of type QuerySet is not JSON serializable )

def ajaxAgent(request):
    data = CommCenter.objects.values()
    responseData = { 'status': 'success', 'msg' : data}
    return JsonResponse(responseData)

Does this answer your question? [Output Django queryset as JSON](https://stackoverflow.com/questions/15874233/output-django-queryset-as-json) — Vadorequest, Nov 08 '19 at 11:26

score 7 · Accepted Answer · answered Nov 07 '19 at 12:52

7

Please find here the answer:

from django.http import JsonResponse

def some_view(request):
    data = list(SomeModel.objects.values())
    return JsonResponse(data, safe=False)  # or JsonResponse({'data': data})

answered Nov 07 '19 at 12:52

Hugo Martin

167
6

score 2 · Answer 2 · answered Nov 16 '20 at 19:19

What worked for me was using values_list() and converting to list using list

def ajaxAgent(request):
    data = CommCenter.objects.filter().values_list()
    responseData = { 'status': 'success', 'msg' : list(data)}
    return JsonResponse(responseData)

score 0 · Answer 3 · answered Nov 07 '19 at 12:46

0

You will have to write a model serializer to serialize the values of the objects into JSON that are returned to you as list when you fetch objects using Django ORM. Check this link out for more details ModelSerializer

answered Nov 07 '19 at 12:46

satyam soni

259
1
9

Object of type QuerySet is not JSON serializable Django

3 Answers3

Linked