Category: API

         I was looking at the GlideApps showcase and the Bogdan Popa created a News App. In it he uses IMPORTXML in Google Sheets to pull in web data that he filters to different tables. A nice app. I started thinking about what other import formulas does Google Sheets have, I know it has GOOGLEFINANCE

        Developing and exploring the GlideApp into different areas has been fun and interesting. This particular app was for someone i worked with who also sells honey with a group of people, and one location is at an outdoor market stall. I thought it would be handy for people who were not prepared to buy immediately

        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