Update Look

Version 4.0.24.20 (latest)

Modify a Look

Use this function to modify parts of a look. Property values given in a call to update_look are applied to the existing look, so there's no need to include properties whose values are not changing. It's best to specify only the properties you want to change and leave everything else out of your update_look call. Look properties marked 'read-only' will be ignored.

When a user deletes a look in the Looker UI, the look data remains in the database but is marked with a deleted flag ("soft-deleted"). Soft-deleted looks can be undeleted (by an admin) if the delete was in error.

To soft-delete a look via the API, use update_look() to change the look's deleted property to true. You can undelete a look by calling update_look to change the look's deleted property to false.

Soft-deleted looks are excluded from the results of all_looks() and search_looks(), so they essentially disappear from view even though they still reside in the db. You can pass deleted: true as a parameter to search_looks() to list soft-deleted looks.

NOTE: delete_look() performs a "hard delete" - the look data is removed from the Looker database and destroyed. There is no "undo" for delete_look().

Request

PATCH /looks/{look_id}
Datatype
Description
Request
HTTP Request
path
HTTP Path
Expand HTTP Path definition...
look_id
string
Id of look
body
HTTP Body
Expand HTTP Body definition...
body
Look
Expand LookWithQuery definition...
can
object
Operations the current user is able to perform on this object
content_metadata_id
string
Id of content metadata
id
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
Model
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
Folder of this Look
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
query
Query
url
string
Url
query
HTTP Query
Expand HTTP Query definition...
fields
string
Requested fields.

Response

200: Look

Datatype
Description
(object)
can
object
Operations the current user is able to perform on this object
content_metadata_id
string
Id of content metadata
id
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
Model
Expand LookModel definition...
id
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
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
id
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
query
Query
Expand Query definition...
can
object
Operations the current user is able to perform on this object
id
string
Unique Id
model
string
Model
view
string
Explore Name
fields
string[]
pivots
string[]
fill_fields
string[]
filters
object
Filters will contain data pertaining to complex filters that do not contain "or" conditions. When "or" conditions are present, filter data will be found on the `filter_expression` property.
filter_expression
string
Filter Expression
sorts
string[]
limit
string
Row limit. To download unlimited results, set the limit to -1 (negative one).
column_limit
string
Column Limit
total
boolean
Total
row_total
string
Raw Total
subtotals
string[]
vis_config
object
Visualization configuration properties. These properties are typically opaque and differ based on the type of visualization used. There is no specified set of allowed keys. The values can be any type supported by JSON. A "type" key with a string value is often present, and is used by Looker to determine which visualization to present. Visualizations ignore unknown vis_config properties.
filter_config
object
The filter_config represents the state of the filter UI on the explore page for a given query. When running a query via the Looker UI, this parameter takes precedence over "filters". When creating a query or modifying an existing query, "filter_config" should be set to null. Setting it to any other value could cause unexpected filtering behavior. The format should be considered opaque.
visible_ui_sections
string
Visible UI Sections
slug
string
Slug
dynamic_fields
string
Dynamic Fields
client_id
string
Client Id: used to generate shortened explore URLs. If set by client, must be a unique 22 character alphanumeric string. Otherwise one will be generated.
share_url
string
Share Url
expanded_share_url
string
Expanded Share Url
url
string
Expanded Url
query_timezone
string
Query Timezone
has_table_calculations
boolean
Has Table Calculations
url
string
Url

400: Bad Request

Datatype
Description
(object)
message
string
Error details
documentation_url
string
Documentation link

404: Not Found

Datatype
Description
(object)
message
string
Error details
documentation_url
string
Documentation link

422: Validation Error

Datatype
Description
(object)
message
string
Error details
Expand ValidationErrorDetail definition...
field
string
Field with error
code
string
Error code
message
string
Error info message
documentation_url
string
Documentation link
documentation_url
string
Documentation link

429: Too Many Requests

Datatype
Description
(object)
message
string
Error details
documentation_url
string
Documentation link

Examples