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 […]

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, […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 deal […]

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 […]

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 […]

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

FAA airport status API: The Daily REST library entry for Excel and GAScript

Today’s API is  “FAA airport status”  – a dataSet query API, populating rows in a spreadsheet using the Airport IATA code as a key Here’s the Excel code (included in cDataSet.xlsm downloadable from the ramblings site)

[…]

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

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 […]