How to use the Web API tile with Google APIs, such as Google Analytics
This article covers how to use the Web API tile to query data from Google APIs, such as Google Analytics, and display this data in Squared Up.
This article covers these areas:
Creating a new provider in Squared Up
Configuration in the Google Developer Console
Completing the provider in Squared Up
Configuring the Web API tile
Squared Up v3 with an Enterprise Application Monitoring license – this gives you the Web API tile.
A Google project account and account, such as Google Analytics.
1. Creating a new provider in Squared Up
Log on to Squared Up and navigate to the right-hand menu ☰ then system and then click on the web api perspective.
Click Add new provider
Change the provider type to OAuth
In the service name box type in a suitable name for this provider. This name is used to create a URL so it is best to avoid spaces and non-alphanumeric characters., e.g. GoogleAnalytics.
Leave the grant type as authorization code
The base URL should be
The authorization URL should
The token URL should be
At this point we need to save the provider and follow the next steps to obtain a client ID and secret from the Google Developer Console, after which we will return to complete these provider details.
Click add provider to save the provider.
Copy the redirect url displayed. This will be used in the next section.
2. Configuration in the Google Developer Console
Visit the the Google Developer Console
Create a new project as required.
Select Create Credentials > OAuth Client ID
Select Web Application
Enter the following:
Name: This can be anything
Authorised Redirect URIs: Should be the redirect url copied from Squared Up right-hand menu ☰ > system > web api. It will be your Squared Up instance followed by
GoogleAPIProvideris the name of the provider you created.
SquaredUpServeris the name of the server where Squared Up is installed.
Copy the client ID and secret to use in the next section.
3. Completing the provider in Squared Up
In Squared Up navigate to the provider you created earlier: Squared Up right-hand menu ☰ > system > web api perspective.
Click the settings button next to the provider to edit it.
Paste in the client id and secret copied from the Google Developer Console.
Paste in the relevant authorisation scope from OAuth 2.0 Scopes for Google APIs. For example, for Google Analytics it should be the URL scope listed for ‘View your Google Analytics data’ which is
Click add provider. You will be redirected to Google to login and authorize and then back to Squared Up.
If the configuration is correct then you will see a green tick.
4. Configuring the Web API tile
The walkthrough below takes you through configuring a simple scalar tile to show the number of pageviews using Google Analytics.
This walkthrough is specific to Google Analytics, but the same principle can be applied to any of the Google APIs.
Walkthrough: Configuring the Web API tile for Google Analytics
Create a new dashboard and click on the Web API tile.
Select Web API (Scalar). The Web API (Scalar) tile is designed to show a single value, such as the number of pageviews. Web API (Grid) is for showing a table of data.
In the provider section select the provider that you created earlier, for example GoogleAnalytics
Next you need to find the correct URL to put in the http mode URL box for Google Analytics:
In a separate tab browse to the Google Analytics Query Explorer
Select your Account, Property, and View.
Under metrics, start typing
pageviewsand select Page Views (ga:pageviews)
Click Run Query
Copy the URL (minus the
https://www.googleapis.com/) from the API Query URI section, so you have something like the following:
Paste this URL into the http mode URL box on your Squared Up dashboard.
Leave the headers & data section as it is, and click on to the response data section.
In the response data section, paste
rows.0.0into the key path box.
In the scalar section, paste
pageviewsinto the unit box.
How to use the Web API tile with Splunk