Django list of json objects

Question

I have a django backend and from my view I want to return a list of json objects.

@api_view(('GET',))
def get_analytics(request):
    # Number of users who dogged in once to our system today
    login_count=  User.objects.filter(last_login__startswith=
        timezone.now().date()).count() # returns int
    finished_count = Exercise_state.objects.filter(exercise_id=7, progress=2).count()
    # returns int

    count_list=[]
    count_list.append(login_count)
    count_list.append(finished_count)

    data = {}
    data['login_count'] = login_count
    data['finish_count'] = finished_count
    json_data = json.dumps(data)

    return Response(json_data)

This returns "{\"finish_count\": 1, \"login_count\": 2}" However what I want is something like [{"login_count": 2, "finished_count": 3}]

How can I achieve this?

Shang Wang · Accepted Answer · 2016-06-02 13:59:35Z

2

You need JsonResponse. But if you are going to use it you don't need json.dumps(data), JsonResponse dose it for you. Quoting from django doc:

>>> from django.http import JsonResponse
>>> response = JsonResponse({'foo': 'bar'})
>>> response.content
b'{"foo": "bar"}'

If you are using django < 1.7, do(it's still available in later versions, but JsonResponse makes it eaiser):

return HttpResponse(json.dumps(data), content_type="application/json")

answered Jun 2, 2016 at 13:59

Shang Wang

25.7k21 gold badges77 silver badges95 bronze badges

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

Comments

Moses Koledoye · Accepted Answer · 2016-06-02 14:00:00Z

1

Use JsonResponse instead, to properly parse the json object:

from django.http import JsonResponse

then, you can use your original dict object:

return JsonResponse(data)

answered Jun 2, 2016 at 14:00

Moses Koledoye

78.8k8 gold badges139 silver badges141 bronze badges

Collectives™ on Stack Overflow

Django list of json objects

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related