No Picture
Microsoft Office & VBA

REST access to blister functions

To take the idea covered in Getting lists as a restquery a little further, why not simple expose all the custom blister functions so they can be queried too. This means that you can use exactly the same […]

Google Authentication

OAuth2 and the Paypal Rest API

The Paypal Rest API uses OAuth2 a little like a Service Account, which means there’s typically no user dialog. It uses a grant type called client_credentials. Goa now supports this kind of OAuth2 flow. You’ll […]

Parse

Query parse.com from GAS

First up we’ll query the colortable  created in Updating parse.com, using the parse REST API. We can’t use the javaScript API in dome way from GAS, because it’s not caja compliant – if it were, we […]

No Picture
From VBA to Google Apps Script

What to use in place of Excel Shapes

Note that this article uses the Apps Script UI service, which has since been deprecated. I leave it here for interest. The equivalent of inserting a shape in Google Docs is to insert a drawing, […]

No Picture
Google Authentication

Oauth2 and Excel-Rest library

Now that we have Rest to Excel library, and we also know how to use oAuth2 for authentication as described in OAUTH2 and VBA. we are ready to get data into Excel using Rest Queries that need […]

Json

Combining multiple rest queries

What can you learn here? Using cRest Multiple sources Combining Putting together multiple queries on same sheet get it now So far we’ve been considering Rest queries to be discrete. In this section we are going […]

No Picture
Microsoft Office & VBA

Advanced rest library usage

What can you learn here? Using cDataSet Using cRest Using cJobject Doing unusual things with the rest library get it now Having dealt with Rest to Excel library, Adding to the rest library, Adhoc Rest Queries and Populating sheets with Rest […]

Microsoft Office & VBA

Adding to the rest library

What can you learn here? Library of Rest Calls How to add new entries How to query from data Adding more content to the rest library get it now Now that we have a generalized mechanism […]

Json

Rest Results Explorer

What can you learn here? Populate a treeview do REST queries interactively explore the results How to get rest API results into a treeview get it now In Create a treeview from json we looked at how to […]

Json

Creating a workbook from JSON manifest

Setting up the workbook layout and format Here we are going to create a workbook from the JSON manifest. The relevant section is below, and can be found at manifest.child(“setup”). Each type of data is identifed […]

No Picture
Integrating Excel with Maps and Earth

Complete Excel Address Data with Yahoo Placemaker Maps API

Geocode Excel Data with Yahoo Placemaker If you haven’t read about Yahoo rules on doing this, please do. Since we have done this in Google Maps, and in Bing Maps, I thought it would be worthwhile to see […]

No Picture
Apps Script & Java Script

Firebase JSON REST access library for Apps Script

The BigQuiz app uses Firebase for keep track of the question, category and game scores of individual players. In Firebase custom authentication with goa I showed how to use Goa to manage authentication for Firebase. This firebase access library works with […]

No Picture
Microsoft Office & VBA

Mapping and adding markers to maps

Filling in the gaps with  Mapping APIs This article will cover 2 main topics How to use the most common APIs for adding markers and information layers to Maps How to plot Excel data directly […]

No Picture
Json

Data driven VBA apps with JSON

Separating coding from defining  I think of 3 different roles in workbook app definition Consume – Use the apps and consume or maintain the data in it, and provide process, informational and operational needs Define […]

No Picture
Json

Rest to Excel library

What can you learn here? Library of Rest Calls Populate excel tables Add your own   A library to populate Excel tables with rest query results get it now  I found myself writing similar code to […]

Microsoft Office & VBA

Integrating Excel with Maps and Earth

Geocoding, Mapping and creating data driven applications straight out of Excel get it now This article will cover 3 main topics. I wrote all this stuff a few years ago, and some of the services may […]

No Picture
Execution

Execution API and Office to Apps migration

These articles are abridged from my book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available  from O’Reilly or Amazon What is the Execution API ? This is a brand new API that enables the running […]

No Picture
Apps Script & Java Script

VBA library for Ephemeral exchange

The REST API interface is pretty straightforward, but it is JSON. VBA doesn’t natively support JSON, but this library includes cJobect , which deals with all of that for you. This packages all the things you can […]

No Picture
Apps Script & Java Script

Apps Script library for Ephemeral exchange

The REST API interface is pretty straightforward, so you can recreate this with UrlFetch if you like. However this packages all the things you can do from the client in a simple library, and is […]

No Picture
Daily REST library

Urbarama API mashup – The daily rest library API

Today’s entry is pretty cool. I came across the urbarama site, which describes itself as “a collaborative world atlas of architecture and civil infrastructure”. What’s more it has an API, which will return details on […]

No Picture
From VBA to Google Apps Script

Page Rank REST API from Excel and Google Apps Script

I haven’t posted anything on new entries to the rest-excel-gas library for a while. As I mentioned in this post the library itself is available as a rest query. There have been quite a number of new APIs added […]

No Picture
REST API

Huffington Post polls results directly into Excel

I noticed this morning that Huffington post released a REST API exposing all their polling results. I’ve added that to the Excel-Rest library so you can get the results of all their polls directly into […]

No Picture
From VBA to Google Apps Script

Rest Library for Google Apps Script

In previous posts I covered a couple of conversions of Excel VBA projects to Google Apps Script, with particular emphasis on maintaining compatibility between the solutions to allow for dual maintenance. Previous conversions have been a GAS […]

No Picture
Microsoft Office & VBA

OpenCorporate data Excel REST query

I got this idea from Tony Hirst’s great blog. The OpenCorporates API gives rich information many companies. Using Google Refine to reconcile, it cleans up many sources of data to a queryable datasource. So here […]

No Picture
REST API

Visualizing Rest Results with treeview explorer

Today’s post is about how to use the jSon to treeView capability in a previous post, and apply it to explore results returned by Rest- Excel library. The library, itself a jSon structure, is visualized […]

No Picture
REST API

TweetSentiments now in the cRest Excel library

Interpreting sentiment from phrases. I came across http://tweetsentiments.com/ the other day, which is a service that tries to analyze the sentiment expressed in a phrase. The are using a technique called Support Vector machines.  You can read […]

No Picture
REST API

Google Finance Added to crest Library

Managing stock portfolio in Excel In a previous entry, I described how to add new entries to the rest-Excel library. Up till now we’ve just looked at populating static data in a worksheet with data […]

No Picture
Json

Adding to the crest- Excel Library

Following the post earlier on rest-jSon-Excel in one line of code , I found that you can do the research and add a new library entry in about 10 minutes. Here is a query to populate […]

No Picture
REST API

rest library for Excel

Eliminating repetitive coding of Excel web service integration I find myself writing more and more web service to Excel integrations. Here are just a few examples of webservice-Excel integrations from the excel ramblings site. I […]