Category: API, JSON

After tinkering with Tables in Coda.io for planning for my website in the morning I did find I was more focused on what I needed to do on the website and completed most of the tasks in that part of the project. 3 down and one to go. Coda.io and Zapier I had a parting

It’s not often one comes across a tool that looks really really interesting where you think you can get some great leverage, but from what I have seen so far Coda.io looks really useful. I’m even starting this post off with a Part 1 as I expect to be doing quite a lot of exploration

Following on from the previous post  I want to try and be able to update a Google Sheet from a web page via the link. I will be following this video: Unfortunately there is not a link to code for this addition, unlike videos 1 & 2 so I’ll need to write it from looking

I like it when I find some useful code and it works straight away. When it doesn’t I end up spending an awful lot of time trying to figure out what is happening. turning the programmers dark magic into something comprehensible. Continuing on from the previous post I started to look at the output and

Getting data from the web and being able to manipulate it and display it on your own website. Using Google sheets to refresh the data at specified intervals allows you to get live feed from sites that do not have an API for drawing the data down. At the end of the last post I

In the previous post “Stock Data 1. Capture via API and Excel from Web” I used Excel to grab some data from the Web & show it as a Table inside Excel. After bringing the data in I had trouble creating a chart from the Table. So, after messing around with the Charts again today

I started looking at getting financial data from the Web, looking at the NZX (NZ stock Exchange) but no-one had free API’s. Actually Quandl did but it was only monthly on overall stocks/bonds and stops the previous month. So I spent a little time fluffing with their free API before realising that was the case.

In Knime you can go to the EXAMPLES from the Knime Server  in the KNIME EXPLORER Tab and open/save to local workspace some examples to play with. You may need to see about getting some API keys for the examples. I tested  Translate using Google API Example. I needed an Google Translate API key and

The above image is for LinkedIn viewers as the API doesn’t seem to fire when viewed from linkedIn. Go here to see web page where the API displays the information. There is also an Extended page with weather & forecast for Wellington, NZ, London, UK & Boston, Ma, USA. Find it here. Output from API

There is a lot of data that can be linked to via API’s (Application programming interface’s), so I’m interested in how to hook up to them to be able to use “GET” requests to download specific data (rather than downloading all the dataset). My first attempt was using Python & Stats.NZ API. I got a