LookerLooker is a business intelligence software and big data analytics platform that helps you explore, analyze and share real-time business analytics easily.
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.
When using the Looker connector, the first thing you will have to do is click on 'New Authentication' in the step editor:
Next, you can add your 'Client ID', 'Client secret' & 'Domain', as shown in the example:
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':
In the User list (which may be empty if this is your first time adding any) click on the 'Add Users' button.
Create your user as appropriate and click on the new 'Add Users' button as displayed below:
You will be sent to a completion page, press 'Done'.
Head back to the Users page, and you will see your newly created user present. Click 'Edit'.
There will be a long list of information regarding your new user and near the bottom you will see an option called 'API£ Keys'.
Click though in order to generate the keys needs..
This is where you will find your required information. Copy the keys over to your Tray.io authentication for completion.
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.
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
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:
- Create password reset token:
- Create API 3 credentials:
- Create two factor login information:
All of these operations require an existing user to be present when applying this information to that user.
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.
- Create a workflow with a manual trigger and add the Looker connecter with the 'List users' operation.
- Add the 'Create user' step using the Looker connector.
- Use the 'Get user' operation to complete setup utilising a final Looker connector.
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':
We can run our workflow and view our list of users in the output panel of the workflow, as shown in this example:
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.
It is possible to add additional, custom input parameters. A full list of these parameters can be found on the Looker API documentation page.
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:
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:
We can then run the workflow to retrieve the newly created user information: