Django - How to process JSON response from TwelveData API in Template?

Question

In a hobby project, I am using TwelveData API to receive Time Series Data. I am using JSON format response and able to check each data (example: open, close, high, and etc.) from Python side, but the problem arises when I try to show the data in a Django Template page using a for-loop. The JSON response is similar to below image:

When I write the following for loop in the template:

{%for r in result %}
    {{r}}
{%endfor %}

It prints GOOGL, AAPL, AMZN, and TSLA <-- which is pretty good. Now when I write another for loop like:

{%for r in result %}
    {%for k in result.r %}
        {{k}}
    {%endfor %}
{%endfor %}

It prints nothing except a blank page. So I rewrite the main for-loop as follows:

{%for r,v in result %}
    {{v}}
{%endfor %}

It prints ValueError: Need 2 values to unpack in for loop; got 5.

Can anyone help me identify how to run the loop accurately so that I can get/print (maybe inside a table tag) the JSON response data as follows: open, close, high, and etc.

Thanks

Please post your data as text. Screenshots of text are far less helpful than the text itself. — Klaus D., Jan 04 '21 at 07:14
Why don't just add it to the question itself, as it is expected on Stack Overflow? — Klaus D., Jan 04 '21 at 07:44

Anton Pomieshchenko · Answer 1 · 2021-01-04T09:59:33.397

0

I think you should use items for result

{% for r,v in result.items %}
    {{r}} - {{ v }}
{% endfor %}

Also you need to convert string to json

import json

# somewhere before you pass result to template
result = json.loads(result)

edited Jan 04 '21 at 09:59

answered Jan 04 '21 at 07:19

Anton Pomieshchenko

2,051
2
10
24

No, it returns: ValueError: Need 2 values to unpack in for loop; got 5 – Shimul Jan 04 '21 at 07:40
plese provide test data, and all template – Anton Pomieshchenko Jan 04 '21 at 07:41
Here is the test data: https://notepad.pw/i10y8247 I just pass result from the backend, which produces an exact output of the file when type ```{{ result }}``` – Shimul Jan 04 '21 at 09:56
it seems I got it, you need to convert string to json – Anton Pomieshchenko Jan 04 '21 at 09:58
if it does not work, please provide code how you pass result to template. in this case this is very important – Anton Pomieshchenko Jan 04 '21 at 10:26

Minh Vương Phan · Answer 2 · 2021-01-04T08:00:23.873

Using result.r will make Django look for property, not value of the key. That is why its print nothing using your second code. You could see Anton Pomieshchenko's anwser to enumerate a dict or write a custom template filter if you want to get the value of a specific key:

from django.template.defaulttags import register
@register.filter
def get_item(dictionary, key):
    return dictionary.get(key)

usage:

{% for r in result %}
    {{ result|get_item:r }}
{% endfor %}

Django - How to process JSON response from TwelveData API in Template?

2 Answers2