User Guide Help Center Documentation User Forums Training
Looker
Getting Started with the Looker API

The Looker API is a secure, “RESTful” application programming interface for managing your Looker instance, and fetching data through the Looker data platform. With the Looker API you can write applications or automation scripts to provision new Looker user accounts, run queries, schedule reports, etc. Just about anything you can do in the Looker application you can do via the Looker API.

Looker API Port and Path

The Looker API is implemented by your Looker instance. The default port for API requests is port 19999. This port number can be changed in your Looker configuration. If the default port doesn’t respond, check with your Looker admin. All Looker API endpoints require an HTTPS connection.

Here’s what a Looker API URL looks like with the default port: https://<your-looker-host-name>:19999/api/3.0/user

Client SDKs

You can use the Looker API with any programming language or application environment that can make HTTPS requests and process JSON responses. You can construct Looker API HTTPS requests manually using curl (or equivalent), the Looker Ruby SDK, or by generating a client SDK library for your language of choice. We recommend using a SDK because it takes care of the details of authentication and HTTPS requests for you, so that you can call the Looker API using simple function calls.

You’ll find SDK details on our Looker API SDKs page.

Authentication

Looker authenticates API requests using an OAuth 2.0 bearer access token in the HTTP authorization header of the request. All Looker API endpoints require a secure HTTPS connection so that the access token will be secure in transit.

The steps for achieving this depend upon whether or not you are using a SDK. Detailed instructions can be found on our Looker API Authentication page.

Interactive API Documentation and Explorer

Looker 5.14 adds API version 3.1, which is an experimental new version. The stable version of the API is 3.0, and all the API information you’ll see on this website is related to 3.0.

However, if you want to try API 3.1, you can see its documentation by going to the Interactive API Documentation and selecting the 3.1 option from the drop-down menu.

In addition to the API reference in our online documentation, Looker has interactive API documentation on the Looker instance. This local page always reflects the exact state of the Looker API on your Looker instance, because it’s generated from the code running in your Looker instance.

The default port and URL to reach your Looker instance’s API docs is https://<your-looker-host-name>:19999/api-docs/index.html. If the default URL doesn’t respond, check with your Looker admin to get the correct URL for your Looker installation.

The client ID and client secret are part of an API3 key that is specific to each Looker user. Looker admins can generate an API3 key in the Edit User page, as described here. If your Looker instance requires API login to view API documents, you must enter your client id and client secret, then click Log In in order to see the API documentation. For all Looker instances, you must enter your client id and client secret in order to issue commands using the interactive API documentation pages.

Use the drop-down menu in the upper right of the page to choose a version of the API: The stable 3.0 - current version or the 3.1 - experimental version.

Also, you can change the way that commands are displayed on the page:

The interactive API documentation combines a reference with a browser-based, interactive API Explorer. This is a way to become familiar with the Looker API without having to create a programming project and write supporting code. For each Looker API endpoint you can fill in parameters, click the Try It Out! button, and immediately see the request URL for the values you enter and the results of the API call. You have to be logged into the API with your API3 credentials in order to run API commands against the Looker instance.

Be careful with the commands you issue on this page. The Try it out button actually invokes Looker API endpoints and applies operations to your Looker instance. If you delete an object or a user via the API, the object or user will be deleted from your Looker instance.

Versioning

API stability is an important consideration when building applications. In order to help you understand which endpoints may be changed in the future, and which should remain stable, we mark certain endpoints as being in beta. For more details see our Looker API Versioning page.

Top