Django object is not iterable

Question

I have an object that I'm trying to iterate over within my template.

My issue is that one of the fields response contains json data and I get this error message:

transaction' object is not iterable

{% for item in transaction %}
    {{ item.notjson_fields}}
     
    {% for jsonItem in item.response %} 

       {{jsonItem}}

    {% endfor %}

{% endfor %}

Model:

 date_created = models.DateTimeField(auto_now_add=True)
 request = JSONField()
 response = JSONField()

@Ngenator nothing shows. and transaction is a transaction = get_object_or_404(Transaction, vendor_tx_id=id) one field has json data tho in the db — GrantU
– GrantU, Commented Apr 24, 2013 at 19:18
values = list(values). whih means Transaction is not an iterable object like list, dict. There should be a method/property(attributet) that you are looking for from transaction. if get_object... is what you are using, it should return an instance of the db record that matches ur query. — CppLearner
– CppLearner, Commented Apr 24, 2013 at 19:21
Is Transaction a ManyToMany relationship? Can you post the definition of Transaction? — Paulo Bu
– Paulo Bu, Commented Apr 24, 2013 at 19:27

Ngenator · Accepted Answer · 2013-04-24 20:12:44Z

2

You are trying to iterate over a Transaction object which is not iterable.

Try something like

{{ transaction.notjson_fields}}

{% for jsonItem in transaction.response %} 
    {{ jsonItem }}
{% endfor %}

I can't be sure though without knowing what Transaction looks like

Edit:

Since response is a JSONField, you can access it like a dict. Just do

{{ transaction.response.amount }}

edited Apr 24, 2013 at 20:12

answered Apr 24, 2013 at 19:22

Ngenator

11.3k4 gold badges43 silver badges47 bronze badges

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

8 Comments

GrantU Over a year ago

ok thats seems to work but how do i get the value {{ jsonItem.amount }} is blank where {{ jsonItem }} is all the fields

Ngenator Over a year ago

It may be a string then. Do you deserialize it at all? How is it stored in the database?

GrantU Over a year ago

response is a direct store of a json request I get ie. in the db it looks like this {"VendorTxCode": "k34m73cr3rhrnghuhsw5drfg7y" etc..}

Ngenator Over a year ago

What is the field type? Are you using something like github.com/bradjasper/django-jsonfield or github.com/derek-schaefer/django-json-field? If not you need to deserialize the data into an object in order to access the key/value pairs.

GrantU Over a year ago

its a JSONField() in the model

|

SYK · Accepted Answer · 2013-04-24 19:48:31Z

1

If like Ngenator said, your field is not a JSON object but a string, you may need to load it first. First register a new template tag

    from django import template
    register = template.Library()
    import json

    @register.filter
    def load_json(value):
        return json.loads(value)

Then to get (just) the amount in your template

    {% with transaction.response|load_json as jsondict %}
    {% for k, v in jsondict.items %}
        {% if k == "amount" %}
            <td>{{ v }}</td>
        {% endif %}   
    {% endfor %}
    {% endwith %}

Good Luck.

answered Apr 24, 2013 at 19:48

SYK

6626 silver badges17 bronze badges

4 Comments

GrantU Over a year ago

you sure is not json as the field in the db is JSONField()?

SYK Over a year ago

That may depend on how you pass it from views to template. Try looping the transaction.response in your template and see what you get.

GrantU Over a year ago

I get a list of fields but not the values

SYK Over a year ago

Does {{ jsonItem.VendorTxCode }} have value?

Collectives™ on Stack Overflow

Django object is not iterable

2 Answers 2

8 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related