How to show Json data to Django template?

Question

I store JSON data to TextField : Data in TextField:

[{"id":1,"Name":"AC","Quantity":"12","Weight":"200","WeightTypes":"KG",
 "TotalWeight":"2400","CustomsCharge":"300.0","Subtotal":"3600"},

{"id":2,"Name":"Soap","Quantity":"12","Weight":"500",
 "WeightTypes":"GRAM","TotalWeight":"6","Customs Charge":"0.0","Subtotal":"12"}]

I receive data in my view.py: using products = json.loads(data)

After that, i am trying to show each item's in Django templates

{% for p in products %}
    {% for key, value in p.items %}
            <tr>
                <td>{{value.id}}</td>
                <td>{{value.Name}}</td>
                <td>{{value.Quantity}}</td>
                <td>{{value.CustomsCharge}}</td>
                <td>{{value.Subtotal}}</td>
                
            </tr>
        {% endfor %}
            
    {% endfor %}

But it's not working! How can i get each value from this Jason field?

Thank you in advance.

What do you mean by not working ? Explain a bit whats happening. — Biplove Lamichhane
– Biplove Lamichhane, Commented Aug 3, 2021 at 3:49
Well, actually if i use<td>{{value}}</td> then, i can get the all the value. But if i want to see get only Name or only CustomsCharges using <td>{{value.Name}}</td> then is not giving value. I am willing to access specific value. — Azharul Islam Somon
– Azharul Islam Somon, Commented Aug 3, 2021 at 4:03

binpy · Accepted Answer · 2021-09-12 00:37:57Z

2

I think you just wrong on parsing the data into template. Basicly you no need to use p.items because it will unpack your original dict items values, meanwhile yo just need to directly call on product loops.

{% for p in products %}
    <tr>
        <td>{{ p.id }}</td>
        <td>{{ p.Name }}</td>
        <td>{{ p.Quantity }} (pcs)</td>
        <td>{{ p.Weight }}</td>
        <td>{{ p.WeightTypes }}</td>
        <td>{{ p.TotalWeight }}</td>
        <td>{{ p.CustomsCharge }}</td>
        <td>{{ p.Subtotal }}</td>
    </tr>
{% endfor %}

edited Sep 12, 2021 at 0:37

answered Aug 3, 2021 at 3:59

binpy

4,2343 gold badges20 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

How to show Json data to Django template?

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