PRO: api.blockchain.info and tablesorter

Challenge: Show data from https://api.blockchain.info/charts/transactions-per-second?timespan=5weeks&rollingAverage=8hours&format=json (local dump) Shortcode: The number of Bitcoin transactions added to the mempool per second. no (sortable) x x (sortable) y (sortable) randomno (sortable) 1159355080015935508004.45520833333 192 2159355260015935526004.396875 0 3159355440015935544004.32447916667 514 4159355620015935562004.24791666667 4294 5159355800015935580004.1171875 3248 6159355980015935598004.00260416667 241 7159356160015935616003.8921875 3559 8159356340015935634003.75677083333 1028 9159356520015935652003.63541666667 2897 In Action:

www.opengov-muenchen.de: locations counting bicyle-traffic

Challenge: Show locations counting bicyle-traffic in munich https://www.opengov-muenchen.de/api/action/datastore_search?resource_id=211e882d-fadd-468a-bf8a-0014ae65a393&limit=5 (local dump of JSON) twig: <ul>{% for r in result.records %} <li>{{r.zaehlstelle_lang}}</li> {% endfor %} </ul> In Action:

API: daten.buergernetz.bz.it with free and PRO Plugin

Challenge: Display data from the API http://daten.buergernetz.bz.it/services/weather/bulletin?format=json&lang=de Free JCI-Plugin: <br> 2020-12-02T00:00:00<br> <br> Dichte Wolken mit etwas Schnee<br> <br> <br> Bedeckt: -3-3<br> <br> <br> <br> Bedeckt, leichter Schneefall: -2-2<br> <br> <br> <br> Bedeckt: -2-3<br> <br> <br> <br> Bedeckt, leichter Schneefall: -7-1<br> <br> <br> <br> Bedeckt, leichter Schneefall: -2-3<br> <br> <br> <br> Bedeckt: -6–1<br> <br> <br> <br> … Continue reading “API: daten.buergernetz.bz.it with free and PRO Plugin”

oAuth Demo

Challenge: oAuth-Authorization by retrieving frist a Token and then using this Token to get the needed JSON. These steps are needed for that: 1. Put together the “Get-Token” request: Put together a JCI-Template for retrieving the Token. Example: http://api.json-content-importer.com/extra/api/gettoken.php gives you a Token, when retrieving via CURL-Post and the Postpayload (see JCI-Template field) {“user”: “test”, … Continue reading “oAuth Demo”

API: api.coinpaprika.com with free and PRO JCI-Plugin

Challenge: Show data from https://api.coinpaprika.com/v1/exchanges/paribu?quotes=TRY Solution with the free JCI-Plugin: reported_volume_24h = 743085894.998 In Action: Solution with the PRO JCI-Plugin: Create a template with URL https://api.coinpaprika.com/v1/exchanges/paribu?quotes=TRY and this twig-code: {% set lire = quotes.TRY.reported_volume_24h|split(‘.’) %} reported_volume_24h = {{lire.0 | formatnumber(0, ”, ‘,’) }}.{{lire.1}} Store this JCI-Template and use it in a shortcode in this way: … Continue reading “API: api.coinpaprika.com with free and PRO JCI-Plugin”

Numbers and Strings in free and PRO plugin

Numbers and Strings: See this JSON: {“num”: 3.5050, “str”: “3.4040” } There is a little difference: “num” is without quotation marks, “str” is with. The JSON Content Importer Plugin and the PHP behind that handles the “num” as numeric data and removes the 0 at the end. Free jsoncontentimporter: num: 3.505, str: 3.4040 gives us … Continue reading “Numbers and Strings in free and PRO plugin”