Issue-number: 296

summary: Applied ML. Faking news. COVID-19: Behind the numbers. Monitoring ML. Azure Architectures. Assessing data advantage for AI. number: 296 title: Issue 296 url: https://dataelixir.com/issues/296 published_at29.07.20, 15:31

PRO: Calc with data from 2 JSON-URLs by merging the JSON-feeds

Challenge: You have two JSON feeds you want to merge and calc with the JSON-values. Example-Solution: Examle JSON-Feeds: http://api.json-content-importer.com/extra/json/n1.json and http://api.json-content-importer.com/extra/json/n2.json Create a new JCI-Template and use one JSON-feed-URL as “URL of Template” http://api.json-content-importer.com/extra/json/n1.json twig: {% set secondjsonurl = “http://api.json-content-importer.com/extra/json/n2.json” %} {% set sc = “” %} {% set json2feed = (sc | doshortcode ) … Continue reading “PRO: Calc with data from 2 JSON-URLs by merging the JSON-feeds”

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 3036 2159355260015935526004.396875 4817 3159355440015935544004.32447916667 1146 4159355620015935562004.24791666667 2214 5159355800015935580004.1171875 1375 6159355980015935598004.00260416667 1388 7159356160015935616003.8921875 4836 8159356340015935634003.75677083333 73 9159356520015935652003.63541666667 881 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-08-09T00:00:00<br> <br> Sehr sonnig, am Nachmittag heiß<br> <br> <br> Heiter: 16-30<br> <br> <br> <br> Heiter: 17-33<br> <br> <br> <br> Heiter: 19-34<br> <br> <br> <br> Heiter: 12-30<br> <br> <br> <br> Heiter: 15-32<br> <br> <br> <br> Heiter: 12-31<br> <br> <br> <br> PRO JCI-Plugin: twig-code: {{today.date | date(‘d.m.Y, … 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”