Add-ons
Colorize sentiment in a Google document
Anaylze and colorize the sentiment of inidivual sentences in Google using Documents Google Language API […]
APIS and techniques
APIS and techniques
Queuing asynchronous tasks to defeat rate limits
The problem with rate limits You’ve most likely hit the problem of rate-limited APIS at some point. You make a request and it gets refused because you’ve done too many requests in some time period. […]
APIS and techniques
Video transcription with Video Intelligence API
The Video Intelligence API allows you to analyze the content of videos. I covered basic labelling in Google Video Intelligence API film labelling. This section will look at how to get a transcript of a film. It turns […]
APIS and techniques
Google API
Orchestrating APIS to structure and interpret OCR data
This is the second step in Making sense of Ocr – an orchestration wrapper for the APIS we’ll need. In Google Vision and OCR I showed how to use the vision API to turn a […]
Google Cloud Platform
Bringing up an ingress controller
This is a part of the series of posts on Getting an API running in Kubernetes, and you should first have created an app to be deployed as described in Building your App ready for […]
APIS and techniques
APIS and techniques
Hitching a ride on Goa’s property store
Goa is a library to simplify Oauth2 with both Google services and other Oauth2 providers, many of which are natively supported. It takes care of dealing with HTML dialogs, refreshing tokens, getting service account data […]
Google Authentication
Google Apps Script Oauth2 for Vimeo with Goa
The Vimeo Rest API is a simple, standard API. It’s been added to the Goa library list of services. Goa library is available with this key, and on github MZx5DzNPsYjVyZaR67xXJQai_d-phDA33 Vimeo dashboard There are various kinds […]
APIS and techniques
Orchestrating APIS to analyze OCR data
This is the second step in Making sense of Ocr – an orchestration wrapper for the APIS we’ll need. In Google Vision and OCR I showed how to use the vision API to turn a pdf into a series […]
APIS and techniques
Google Vision and OCR
This is the first step in Making sense of Ocr – getting a pdf turned into a JSON map. Mechanics First of all just load your pdf file somewhere in cloud storage, then I’ll use this code […]
APIS and techniques
Making sense of OCR – Google Vision
In the project I’m using for illustrating some of the capabilities of GCP, I need to make sense of a variety of documents, some very complex and some less so. The basic problem though is that there […]
APIS and techniques
Google Video Intelligence API film labelling
The Video Intelligence API allows you to analyze the content of videos. For my use case this is super useful, because now I can Label videos with their content, and use those labels to navigate to the […]
APIS and techniques
Long running cloud platform operations and node apis
Some cloud apis are considered to be ‘long running’, which means you wont get the result right away. Rather the result is stored and you can retrieve it later. There is an api for doing […]
APIS and techniques
More cloud streaming
In Stream content to Google Cloud Storage I covered how you could stream content (in this case a video file) from a hosted URL to an object on cloud storage in preparation for labelling it with the […]
APIS and techniques
Stream content to Google Cloud Storage
This article looks at the Node implementation to stream content directly to google cloud storage, and we’ll look at how to convert that to a Cloud run function in a later one. Note that although […]
APIS and techniques
Custom domains and ssl with Firebase hosting
This is one of a series of articles about Going serverless with Firebase. You many want to read about Firebase cloud functions before this article. Using custom domains 2 of the great things you get with Firebase hosting […]
APIS and techniques
API rate limiting handling
If you use any kind of API you’ll eventually have to deal with rate limiting. Most API providers introduce rate limiting to prevent abuse if their platform, but it can be tricky to deal […]
APIS and techniques
Apollo graphql backend
This collection of articles deal with getting Graphql/Apollo server up and running on Node Rate limit handling A deep dive into rate-limiting with the Vimeo API
APIS and techniques
Vuejs, firebase, kubernetes, cockroachDB, google cloud platform and apollo graphQL
This is a new section to collate various snippets related to GraphQL both from and back ends. For the purposes of these articles, I’ll be concentrating on the integration of this collection of platforms with […]
APIS and techniques
Get web credentials from downloaded file
This describes how to use Goa, as described in Oauth2 for Apps Script in a few lines of code (which you should read first for background). The library, cGoa, is available under this project key, or on github. […]
APIS and techniques
BigQuery and the Execution API
The data for BigQuiz app is held in BigQuery. In Loading large JSON datasets into BigQuery with Apps Script I showed how you could maintain data in BigQuery with Apps Script, but now when I come to use it, […]
Google Authentication
Using OAUTH2 with a webapp published ‘as me’
In Borrowing an access token from Apps Scripts I demonstrated the simplest way to get a token to use with a Google API, by borrowing one from Apps Script. Next up, was Using a service account where could generate a […]
APIS and techniques
Using OAuth2 when published as ‘user accessing the webapp’
In Borrowing an access token from Apps Scripts I demonstrated the simplest way to get a token to use with a Google API, by borrowing one from Apps Script. Next up, was Using a service account where could generate a […]
Apps Script & Java Script
Using a service account
In Borrowing an access token from Apps Scripts I demonstrated the simplest way to get a token to use with a Google API, by borrowing one from Apps Script. However to access APIS that have no equivalent in […]
APIS and techniques
Some OAUTH2 walkthroughs
This section contains some different methods of getting an access token for use with Google APIS that are not built in or advanced services. All the demo code for the full app used in these examples […]
APIS and techniques
Using the Google Sheets V4 API from VBA to integrate Sheets and Excel
The Google Sheets V4 API is a very nice piece of work that exposes almost all of the Sheets object model in a REST API. Here’s a VBA wrapper for that API. I’ll add to […]
APIS and techniques
Google Cloud Platform
This collection of articles deal with various Google Cloud Platform APIS. The full content is below. It is part of a project that I will document at a later stage The next section is a […]
APIS and techniques
Storing and serving up images from scriptDB with Google Content Service, jSonP and jQuery
Continuing the theme of using Google Apps Script Content service and scriptDB for lots of things, today’s post cover a few tricky topics. How to convert an image to a blob so it can be […]