- Your task:
Display JSON-data in the browser in a table which is sortable by the user. - Solution:
Install JCI-Plugin and the plugin “Table Sorter“ - Example-Code:
[jsoncontentimporterpro url=https://api.blockchain.info/charts/transactions-per-second?timespan=5weeks&rollingAverage=8hours&format=json method=rawget parser=twig] {{description}} <table id=”myTable” class=”tablesorter”>
<thead><tr>
<th>no (sortable)</th>
<th class=”sortless”>x</th>
<th>x (sortable)</th>
<th>y (sortable)</th>
<th>randomno (sortable) </tr></thead>
<tbody>
{%for v in values %}
{% if loop.index<10 %}
<tr><td>{{loop.index}}</td><td>{{v.x}}</td><td>{{v.x}}</td><td>{{v.y}}</td><td>
{{ random(5000) }} </td></tr>
{% endif %}
{% endfor %}
</tbody></table>
[/jsoncontentimporterpro]
The number of Bitcoin transactions added to the mempool per second.
| no (sortable) | x | x (sortable) | y (sortable) | randomno (sortable) |
|---|---|---|---|---|
| 1 | 1547313600 | 1547313600 | 3.33357638889 | 1106 |
| 2 | 1547315640 | 1547315640 | 3.34795138889 | 891 |
| 3 | 1547317680 | 1547317680 | 3.36003472222 | 894 |
| 4 | 1547319720 | 1547319720 | 3.40357638889 | 349 |
| 5 | 1547321760 | 1547321760 | 3.40472222222 | 4130 |
| 6 | 1547323800 | 1547323800 | 3.4509375 | 2058 |
| 7 | 1547325840 | 1547325840 | 3.499375 | 2429 |
| 8 | 1547327880 | 1547327880 | 3.44475694444 | 3663 |
| 9 | 1547329920 | 1547329920 | 3.48236111111 | 105 |
Credits: Thank you Lawrence from South Melbourne, Australia