Open Navigation

Looker

Looker is a business intelligence software and big data analytics platform that helps you explore, analyze and share real-time business analytics easily.

Overview

As a data exploration and discovery business intelligence platform, Looker's tool suite allows you to connect live to your data, describe and consolidate usable business definitions, and output/ share results across a variety of endpoints and workflows.

Authentication

When using the Looker connector, the first thing you will have to do is click on 'New Authentication' in the step editor:

looker-new-auth

Next, you can add your 'Client ID', 'Client secret' & 'Domain', as shown in the example:

looker-auth-params

In order to retrieve this information you will need to log into your Looker account (make sure you have Admin level clearance in your account before proceeding).

In ther heading seciton of your account click on the 'Admin' option and within the dropdown list select 'Users':

looker-admin

In the User list (which may be empty if this is your first time adding any) click on the 'Add Users' button.

looker-add-user

Create your user as appropriate and click on the new 'Add Users' button as displayed below:

looker-create-user

You will be sent to a completion page, press 'Done'.

looker-user-done

Head back to the Users page, and you will see your newly created user present. Click 'Edit'.

looker-edit-user

There will be a long list of information regarding your new user and near the bottom you will see an option called 'API£ Keys'.

looker-add-keys

Click though in order to generate the keys needs..

looker-create-keys

This is where you will find your required information. Copy the keys over to your Tray.io authentication for completion.

looker-keys-generated

Note that in the Tray.io Looker authentication options, that the 'Port' and 'Region' fields are optional parameters that should be added on an either/or basis if your Looker instance configuration is setup to use either one of these. NOTE that 'Port' and 'Region' should not both be filled for any authentication.

looker-opt-params

Basic Operations List

Full list of operations can be found HERE

  • Create API 3 credentials
  • Create two factor login information
  • Get current user
  • List users
  • Update user
  • Update user email credentials

Note on Operations usage

The Looker API requires that to add a select group of information to a user, the the relevant endpoint be used to do so. Existing creation operations include:

  • Create user email credentials: /users/{user_id}/credentials_email
  • Create password reset token: /users/{user_id}/credentials_email/password_reset
  • Create API 3 credentials: /users/{user_id}/credentials_api3
  • Create two factor login information: /users/{user_id}/credentials_totp

All of these operations require an existing user to be present when applying this information to that user.

Example usage

In the following example we create a workflow that gets a list of users, creates an individual user then retrieves that newly created user.

Please see the above section on example usage for list and get account type operations.

  1. Create a workflow with a manual trigger and add the Looker connecter with the 'List users' operation.
  2. Add the 'Create user' step using the Looker connector.
  3. Use the 'Get user' operation to complete setup utilising a final Looker connector.

1 - Setup

To begin with, create a workflow with a Manual Trigger, then add a step from the Looker connector with the operation set to 'List users':

looker-list-users

We can run our workflow and view our list of users in the output panel of the workflow, as shown in this example:

looker-list-users-output

2 - Create User

Next, add another Looker connector step and specify the operation as 'Create user'.

In the input options, set the 'First name' and 'Last name' for our new user.

looker-create-user

It is possible to add additional, custom input parameters. A full list of these parameters can be found on the Looker API documentation page.

3 - Get User ID

Finally add one more Looker connector to the workflow and set the operation to 'Get user'.

We want to set the 'User ID' to the ID of the newly created user in the previous step. In order to do this without hard coding the answer, we utilise the connector-snake in order to auto-generate a JSON path as pictured below in this example:

looker-get-user-jsonpath

Be sure to click and drag from your input panel (in this case from our User ID) towards the connector step you wish to utilise.

Your result should be something like this:

looker-user-id

We can then run the workflow to retrieve the newly created user information:

looker-get-user-output

Was this article helpful?
Yes
No