how to parse json array in django

Question

I am new in django rest api framework and using get i am fetching the a json array whose api is this https://api.coursera.org/api/courses.v1?q=search&query=machine+learning and i am not able to parse it.Actually i want to store all the names and send them to .html file .I have used this code but didnot worked for me.

    req = requests.get('https://api.coursera.org/api/courses.v1?q=search&
                                query=machine+learning')
    jsonList = []
    jsonList.append(req.json())
    print(jsonList[0])
    userData = {}
    for value in jsonList[0]:
        parsedData.append(value["name"])
        print(value["name"])
    return render(request, 'app/profile.html', {'data': parsedData})

How did it "not work for you"? Please don't just say that it didn't work. Include the expected behavior and what behavior you saw. — Luke Taylor
– Luke Taylor, Commented May 8, 2016 at 13:17
i was getting this error Exception Value: string indices must be integers — user3923278
– user3923278, Commented May 8, 2016 at 13:23

DeepSpace · Accepted Answer · 2016-05-08 14:02:26Z

6

This actually has nothing to do with Django.

The way to get to the name attribute inside elements (there are actually many elements, each one has a 'name`):

import requests
import json

req = requests.get('https://api.coursera.org/api/courses.v1?q=search&query = machine + learning')

json_data = json.loads(req.text)

for element in json_data['elements']:
    print(element['name'])

>> Speak English Professionally: In Person, Online & On the Phone
   Machine Learning
   Learning How to Learn: Powerful mental tools to help you master tough subjects
   .
   .

Update:

To display the names in a view:

Considering that you have a very basic template:

{% for name in names %}
    <p>{{ name }}</p>
{% endfor %}

Inside your view, considering you already have the above code, and you stored all the names in a list called names:

return render(request, 'app/profile.html', context={'names': names}, status=200)  
# it's always a good habit to return an HTTP status code

edited May 8, 2016 at 14:02

answered May 8, 2016 at 12:55

DeepSpace

82.1k12 gold badges119 silver badges166 bronze badges

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

1 Comment

user3923278 Over a year ago

DeepSpace I donot want to print in console.i want to store all name and send to .html file so that i can run a loop and display those names, so how to do this,please help me.

DragonFire · Accepted Answer · 2022-08-09 06:03:37Z

0

In case you have a Json Array without A Name/Key as shown below you can do, it is very similar to accepted answer below with slight difference of not having key/name in the Json Array

[
    {
        "id": 7,
        "user": 2129
    },
    {
        "id": 8,
        "user": 2129
    }
]

In View

response = requests.post('http://127.0.0.1:8000/api/some-api/', headers=headers)

users = json.loads(response.text)
for user in users:
    print(user)

return render(request, "web_client/mine.html", {"data": users, "page": "mine"})

In Template

{% for row in data %}
  {{ row.some_key_to_print }}
{% endfor %}

answered Aug 9, 2022 at 6:03

DragonFire

4,1222 gold badges41 silver badges59 bronze badges

Collectives™ on Stack Overflow

how to parse json array in django

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