Version 4.0.25.6
Search Looks
Returns an array of Look objectsthat 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 anyof 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 lookby id with look(id)
Request
GET
/looks/search
Datatype
Description
Request
HTTP Request
query
HTTP Query
Expand HTTP Query definition...
id
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
lock
object
Operations the current user is able to perform on this object
content_metadata_id
lock
string
Id of content metadata
id
lock
string
Unique Id
title
string
Look Title
user_id
string
User Id
content_favorite_id
lock
string
Content Favorite Id
created_at
lock
string
Time that the Look was created.
deleted
boolean
Whether or not a look is 'soft' deleted.
deleted_at
lock
string
Time that the Look was deleted.
deleter_id
lock
string
Id of User that deleted the look.
description
string
Description
embed_url
lock
string
Embed Url
excel_file_url
lock
string
Excel File Url
favorite_count
lock
integer
Number of times favorited
google_spreadsheet_formula
lock
string
Google Spreadsheet Formula
image_embed_url
lock
string
Image Embed Url
is_run_on_load
boolean
auto-run query when Look viewed
last_accessed_at
lock
string
Time that the Look was last accessed by any user
last_updater_id
lock
string
Id of User that last updated the look.
last_viewed_at
lock
string
Time last viewed in the Looker web UI
Expand LookModel definition...
id
lock
string
Model Id
label
lock
string
Model Label
public
boolean
Is Public
public_slug
lock
string
Public Slug
public_url
lock
string
Public Url
query_id
string
Query Id
short_url
lock
string
Short Url
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
id
lock
string
Unique Id
content_metadata_id
lock
string
Id of content metadata
created_at
lock
string
Time the folder was created
creator_id
lock
string
User Id of Creator
child_count
lock
integer
Children Count
external_id
lock
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
lock
boolean
Folder is an embed folder
is_embed_shared_root
lock
boolean
Folder is the root embed shared folder
is_embed_users_root
lock
boolean
Folder is the root embed users folder
is_personal
lock
boolean
Folder is a user's personal folder
is_personal_descendant
lock
boolean
Folder is descendant of a user's personal folder
is_shared_root
lock
boolean
Folder is the root shared folder
is_users_root
lock
boolean
Folder is the root user folder
can
lock
object
Operations the current user is able to perform on this object
folder_id
string
Folder Id
updated_at
lock
string
Time that the Look was updated.
user_name
lock
string
Name of User that created the look.
view_count
lock
integer
Number of times viewed in the Looker web UI
400: Bad Request
Datatype
Description
(object)
message
lock
string
Error details
documentation_url
lock
string
Documentation link
404: Not Found
Datatype
Description
(object)
message
lock
string
Error details
documentation_url
lock
string
Documentation link
429: Too Many Requests
Datatype
Description
(object)
message
lock
string
Error details
documentation_url
lock
string
Documentation link
Examples
Python
Kotlin
TypeScript
Swift
