Django object is not JSON serializable

Question

I have the following code for serializing the queryset:

def get_shop_categories(request):
    if request.method == 'POST':
        parent_id = int(request.POST.get('parent_id'))

        categories = (ShopCategory.objects.filter(enabled=True, parent=parent_id).values('id', 'title'))
        json_posts = json.dumps(categories)

        return HttpResponse(
            json_posts,
            content_type="application/json"
        )

    else:
        return HttpResponse(
            json.dumps({"success": False}),
            content_type="application/json"
        )

What I want it returns is this:

[{'id': 2, 'title': 'Tennis'}, {'id': 4, 'title': 'Basket'}]

Instead I'm getting this error:

TypeError at /ajax/get_shop_categories
[{'id': 2, 'title': 'Tennis'}, {'id': 4, 'title': 'Basket'}] is not JSON serializable

I also used serialize in this way:

categories = ShopCategory.objects.filter(enabled=True, parent=parent_id)                       
#json_posts = json.dumps(categories)
#objectQuerySet = ConventionCard.objects.filter(ownerUser = user)
json_posts = serializers.serialize('json', list(categories), fields=('id', 'title'))

but what I get I don't like:

 [{"fields":{"title":"Tennis"},"pk":2,"model":"appname.shopcategory"},{"fields":{"title":"Basket"},"pk":4,"model":"appname.shopcategory"}]

madzohan · Accepted Answer · 2014-12-28 09:45:53Z

4

categories = ShopCategory.objects.filter(enabled=True, parent=parent_id).values('id', 'title')
json_posts = mark_safe(json.dumps(list(categories), ensure_ascii=False))

answered Dec 28, 2014 at 9:45

madzohan

11.8k9 gold badges43 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

Django object is not JSON serializable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related