Search Looks

Version 4.0.25.0 (latest)

Search Looks

Returns an array of Look objects that match the specified search criteria.

If multiple search params are given and filter_or is FALSE or not specified, search params are combined in a logical AND operation. Only rows that match all search param criteria will be returned.

If filter_or is TRUE, multiple search params are combined in a logical OR operation. Results will include rows that match any of the search criteria.

String search params use case-insensitive matching. String search params can contain % and '_' as SQL LIKE pattern match wildcard expressions. example="dan%" will match "danger" and "Danzig" but not "David" example="D_m%" will match "Damage" and "dump"

Integer search params can accept a single value or a comma separated list of values. The multiple values will be combined under a logical OR operation - results will match at least one of the given values.

Most search params can accept "IS NULL" and "NOT NULL" as special expressions to match or exclude (respectively) rows where the column is null.

Boolean search params accept only "true" and "false" as values.

Get a single look by id with look(id)

Request

GET /looks/search

Datatype

Description

Request

HTTP Request

query

HTTP Query

Expand HTTP Query definition...

string

Match look id.

title

string

Match Look title.

description

string

Match Look description.

content_favorite_id

string

Select looks with a particular content favorite id

folder_id

string

Select looks in a particular folder.

user_id

string

Select looks created by a particular user.

view_count

string

Select looks with particular view_count value

deleted

boolean

Select soft-deleted looks

query_id

string

Select looks that reference a particular query by query_id

curate

boolean

Exclude items that exist only in personal spaces other than the users

last_viewed_at

string

Select looks based on when they were last viewed

fields

string

Requested fields.

page

integer

DEPRECATED. Use limit and offset instead. Return only page N of paginated results

per_page

integer

DEPRECATED. Use limit and offset instead. Return N rows of data per page

limit

integer

Number of results to return. (used with offset and takes priority over page and per_page)

offset

integer

Number of results to skip before returning any. (used with limit and takes priority over page and per_page)

sorts

string

One or more fields to sort results by. Sortable fields: [:title, :user_id, :id, :created_at, :space_id, :folder_id, :description, :updated_at, :last_updater_id, :view_count, :favorite_count, :content_favorite_id, :deleted, :deleted_at, :last_viewed_at, :last_accessed_at, :query_id]

filter_or

boolean

Combine given search criteria in a boolean OR expression

Response

200: looks

Datatype

Description

(array)

Look[]

can

object

Operations the current user is able to perform on this object

content_metadata_id

string

Id of content metadata

string

Unique Id

title

string

Look Title

user_id

string

User Id

content_favorite_id

string

Content Favorite Id

created_at

string

Time that the Look was created.

deleted

boolean

Whether or not a look is 'soft' deleted.

deleted_at

string

Time that the Look was deleted.

deleter_id

string

Id of User that deleted the look.

description

string

Description

embed_url

string

Embed Url

excel_file_url

string

Excel File Url

favorite_count

integer

Number of times favorited

google_spreadsheet_formula

string

Google Spreadsheet Formula

image_embed_url

string

Image Embed Url

is_run_on_load

boolean

auto-run query when Look viewed

last_accessed_at

string

Time that the Look was last accessed by any user

last_updater_id

string

Id of User that last updated the look.

last_viewed_at

string

Time last viewed in the Looker web UI

model

LookModel

Model

Expand LookModel definition...

string

Model Id

label

string

Model Label

public

boolean

Is Public

public_slug

string

Public Slug

public_url

string

Public Url

query_id

string

Query Id

short_url

string

Short Url

folder

FolderBase

Folder of this Look

Expand FolderBase definition...

name

string

Unique Name

parent_id

string

Id of Parent. If the parent id is null, this is a root-level entry

string

Unique Id

content_metadata_id

string

Id of content metadata

created_at

string

Time the folder was created

creator_id

string

User Id of Creator

child_count

integer

Children Count

external_id

string

Embedder's Id if this folder was autogenerated as an embedding shared folder via 'external_group_id' in an SSO embed login

is_embed

boolean

Folder is an embed folder

is_embed_shared_root

boolean

Folder is the root embed shared folder

is_embed_users_root

boolean

Folder is the root embed users folder

is_personal

boolean

Folder is a user's personal folder

is_personal_descendant

boolean

Folder is descendant of a user's personal folder

is_shared_root

boolean

Folder is the root shared folder

is_users_root

boolean

Folder is the root user folder

can

object

Operations the current user is able to perform on this object

folder_id

string

Folder Id

updated_at

string

Time that the Look was updated.

user_name

string

Name of User that created the look.

view_count

integer

Number of times viewed in the Looker web UI

400: Bad Request

Datatype

Description

(object)

Error

message

string

Error details

documentation_url

string

Documentation link

404: Not Found

Datatype

Description

(object)

Error

message

string

Error details

documentation_url

string

Documentation link

429: Too Many Requests

Datatype

Description

(object)

Error

message

string

Error details

documentation_url

string

Documentation link

Examples

Search Looks

Search Looks

Request

Response

200: looks

400: Bad Request

404: Not Found

429: Too Many Requests

Examples

Python

Kotlin

TypeScript

Swift