User Guide Getting Started Help Center Documentation Community Training
  
English
日本語
Dashboard : Manage Dashboards

Get All Dashboards beta

GET/api/3.0/dashboards
all_dashboards(fields)

Implementation Notes

Get information about all active dashboards.

Returns an array of abbreviated dashboard objects. Dashboards marked as deleted are excluded from this list.

Get the full details of a specific dashboard by id with Dashboard

Find deleted dashboards with Search Dashboards

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
fields false Requested fields. string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Create Dashboard beta

POST/api/3.0/dashboards
create_dashboard(body)

Implementation Notes

Create a dashboard with the specified information.

Creates a new dashboard object, returning the dashboard details, including the created id.

Update an existing dashboard with Update Dashboard

Permanently delete an existing dashboard with Delete Dashboard

Response Class

Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Parameters

Parameter Required? Description Parameter Type Data Type
body false Dashboard body
Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
409 Resource Already Exists
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}

Search Dashboards beta

GET/api/3.0/dashboards/search
search_dashboards(fields, id, slug, page, per_page, limit, offset, sorts, title, description, content_favorite_id, space_id, deleted, user_id, view_count)

Implementation Notes

Search all dashboards for matching criteria.

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

The parameters limit, and offset are recommended for “paging” the returned results.

Get a single dashboard by id with Dashboard

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
fields false Requested fields. string string
id false Match dashboard id. integer int64
slug false Match dashboard slug. string string
page false Requested page. integer int64
per_page false Results per page. integer int64
limit false Number of results to return. (used with offset and takes priority over page and per_page) integer int64
offset false Number of results to skip before returning any. (used with limit and takes priority over page and per_page) integer int64
sorts false Fields to sort by. string string
title false Match Dashboard title. string string
description false Match Dashboard description. string string
content_favorite_id false Filter on a content favorite id. integer int64
space_id false Filter on a particular space. string string
deleted false Filter on dashboards deleted status. string string
user_id false Filter on dashboards created by a particular user. string string
view_count false Filter on a particular value of view_count string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Create Dashboard beta

POST/api/3.0/dashboards/{lookml_dashboard_id}/import/{space_id}
import_lookml_dashboard(lookml_dashboard_id, space_id, body)

Implementation Notes

Import a LookML dashboard to a space as a UDD.

Creates a UDD (a dashboard which exists in the Looker database rather than as a LookML file) from the LookML dashboard and puts it in the space specified. The created UDD will have a lookml_link_id which links to the original LookML dashboard.

To give the imported dashboard specify a (e.g. title: “my title”) in the body of your request, otherwise the imported dashboard will have the same title as the original LookML dashboard.

For this operation to succeed the user must have permission to see the LookML dashboard in question, and have permission to create content in the space the dashboard is being imported to.

Sync a linked UDD with [Sync LookML Dashboard] (#!/Dashboard/sync_lookml_dashboard) Unlink a linked UDD by setting lookml_link_id to null with Update Dashboard

Response Class

Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Parameters

Parameter Required? Description Parameter Type Data Type
lookml_dashboard_id true Id of LookML dashboard string string
space_id true Id of space to import the dashboard to string string
body false Dashboard body
Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Response Messages

HTTP Status Code Reason Response Model
201 dashboard
Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}

Update Dashboard beta

PATCH/api/3.0/dashboards/{lookml_dashboard_id}/sync
sync_lookml_dashboard(lookml_dashboard_id, body)

Implementation Notes

Update all linked dashboards to match the specified LookML dashboard.

Any UDD (a dashboard which exists in the Looker database rather than as a LookML file) which has a lookml_link_id which specifies the LookML dashboard’s id will be updated so that it matches the current state of the LookML dashboard.

For this operation to succeed the user must have permission to view the LookML dashboard, and only linked dashboards that the user has permission to update will be synced.

To link or unlink a UDD set the lookml_link_id with Update Dashboard

Response Class

  array

Parameters

Parameter Required? Description Parameter Type Data Type
lookml_dashboard_id true Id of LookML dashboard string string
body true Dashboard body
Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}

Delete Dashboard beta

DELETE/api/3.0/dashboards/{dashboard_id}
delete_dashboard(dashboard_id)

Implementation Notes

Delete the dashboard with the specified id.

Permanently deletes a dashboard. (The dashboard cannot be recovered after this operation.)

“Soft” delete or hide a dashboard by setting its deleted status to True with Update Dashboard.

Note: When a dashboard is deleted in the UI, it is soft deleted. Use this API call to permanently remove it, if desired.

Response Class

  None

Parameters

Parameter Required? Description Parameter Type Data Type
dashboard_id true Id of dashboard string string

Response Messages

HTTP Status Code Reason Response Model
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
405 Resource Can’t Be Modified
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
204 Successfully deleted. string

Update Dashboard beta

PATCH/api/3.0/dashboards/{dashboard_id}
update_dashboard(dashboard_id, body)

Implementation Notes

Update the dashboard with the specified id.

Changes simple (scalar) properties of the dashboard.

Response Class

Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Parameters

Parameter Required? Description Parameter Type Data Type
dashboard_id true Id of dashboard string string
body true Dashboard body
Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
405 Resource Can’t Be Modified
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get Dashboard beta

GET/api/3.0/dashboards/{dashboard_id}
dashboard(dashboard_id, fields)

Implementation Notes

Get information about the dashboard with the specified id.

Returns the full details of the identified dashboard object

Get a summary list of all active dashboards with All Dashboards

Search for dashboards with Search Dashboards

Response Class

Dashboard {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
slug (string): Content Metadata Slug,
content_favorite_id (long, read-only): Content Favorite Id,
view_count (long, read-only): Number of times viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time the dashboard was last accessed,
favorite_count (long, read-only): Number of times favorited,
user_id (long, read-only): Id of User,
title (string): Look Title,
description (string): Description,
readonly (boolean, read-only): Is Read-only,
hidden (boolean): Is Hidden,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as Integer,
space (SpaceBase, read-only): Space,
load_configuration (string): configuration option that governs how dashboard loading will happen.,
model (LookModel, read-only): Model,
space_id (string): Id of Space,
dashboard_elements (Array[DashboardElement], read-only): Elements,
dashboard_layouts (Array[DashboardLayout], read-only): Layouts,
dashboard_filters (Array[DashboardFilter], read-only): Filters,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
background_color (string): Background color,
show_title (boolean): Show title,
title_color (string): Title color,
show_filters_bar (boolean): Show filters bar. Security Note: This property only affects the cosmetic appearance of the dashboard, not a user's ability to access data. Hiding the filters bar does NOT prevent users from changing filters by other means. For information on how to set up secure data access control policies, see Control User Access to Data,
tile_background_color (string): Tile background color,
tile_text_color (string): Tile text color,
text_tile_text_color (string): Color of text on text tiles,
last_updater_id (long, read-only): Id of User that last updated the dashboard.,
deleter_id (long, read-only): Id of User that deleted the dashboard.,
deleted (boolean): Whether or not a dashboard is deleted.,
created_at (date-time, read-only): Time that the Dashboard was created.,
deleted_at (date-time, read-only): Time that the Dashboard was deleted.,
query_timezone (string): Timezone in which the Dashboard will run by default.,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard (LookML dashboard only).,
lookml_link_id (string, read-only): Links this dashboard to a particular LookML dashboard such that calling a sync operation on that LookML dashboard will update this dashboard to match.,
can (object, read-only): Operations the current user is able to perform on this object
}
SpaceBase {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
creator_id (long, read-only): User Id of Creator,
name (string, read-only): Unique Name,
parent_id (long, required): Id of Parent,
is_personal (boolean, read-only): Space is a user's personal space,
is_personal_descendant (boolean, read-only): Space is descendant of a user's personal space,
is_shared_root (boolean, read-only): Space is the root shared space,
is_users_root (boolean, read-only): Space is the root user space,
is_root (boolean, read-only): (DEPRECATED) Space is the root shared space (alias of is_shared_root),
is_user_root (boolean, read-only): (DEPRECATED) Space is the root user space (alias of is_users_root,
is_embed (boolean, read-only): Space is an embed space,
is_embed_shared_root (boolean, read-only): Space is the root embed shared space,
is_embed_users_root (boolean, read-only): Space is the root embed users space,
external_id (string, read-only): Embedder's Id if this space was autogenerated as an embedding shared space via 'external_group_id' in an SSO embed login,
child_count (long, read-only): Children Count,
can (object, read-only): Operations the current user is able to perform on this object
}
LookModel {
id (string, read-only): Model Id,
label (string, read-only): Model Label,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardElement {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
look_id (string): Id Of Look,
query_id (long): Id Of Query,
type (string): Type,
refresh_interval (string): Refresh Interval,
refresh_interval_to_i (long, read-only): Refresh Interval as integer,
note_text (string): Note Text,
note_text_as_html (string, read-only): Note Text as Html,
note_display (string): Note Display,
note_state (string): Note State,
title_hidden (boolean): Whether title is hidden,
title_text (string): Text tile title,
title (string): Title of dashboard element,
subtitle_text (string): Text tile subtitle text,
body_text (string): Text tile body text,
body_text_as_html (string, read-only): Text tile body text as Html,
look (LookWithQuery, read-only): Look,
query (Query, read-only): Query,
edit_uri (string, read-only): Relative path of URI of LookML file to edit the dashboard element (LookML dashboard only).,
merge_result_id (string): ID of merge result,
result_maker_id (long, read-only): ID of the ResultMakerLookup entry.,
result_maker (ResultMakerWithIdVisConfigAndDynamicFields, read-only): Data about the result maker.,
can (object, read-only): Operations the current user is able to perform on this object
}
LookWithQuery {
id (string, read-only): Unique Id,
content_metadata_id (long, read-only): Id of content metadata,
view_count (long, read-only): Number of times viewed in the Looker web UI,
favorite_count (long, read-only): Number of times favorited,
content_favorite_id (long, read-only): Content Favorite Id,
title (string): Look Title,
user (UserIdOnly, read-only): User,
query_id (long): Query Id,
description (string): Description,
short_url (string, read-only): Short Url,
space (SpaceBase, read-only): Space of this Look,
public (boolean, read-only): Is Public,
public_slug (string, read-only): Public Slug,
user_id (long): (Write-Only) User Id,
space_id (string): (Write-Only) Space Id,
model (LookModel, read-only): Model,
public_url (string, read-only): Public Url,
embed_url (string, read-only): Embed Url,
google_spreadsheet_formula (string, read-only): Google Spreadsheet Formula,
excel_file_url (string, read-only): Excel File Url,
url (string, read-only): Url,
query (Query, read-only): Query,
created_at (date-time, read-only): Time that the Look was created.,
updated_at (date-time, read-only): Time that the Look was updated.,
deleted_at (date-time, read-only): Time that the Look was deleted.,
last_updater_id (long, read-only): Id of User that last updated the look.,
last_viewed_at (date-time, read-only): Time last viewed in the Looker web UI,
last_accessed_at (date-time, read-only): Time that the Look was last accessed by any user,
deleter_id (long, read-only): Id of User that deleted the look.,
deleted (boolean): Whether or not the look is deleted,
is_run_on_load (boolean): auto-run query when Look viewed,
can (object, read-only): Operations the current user is able to perform on this object
}
UserIdOnly {
id (long, read-only): Unique Id
}
Query {
id (long, read-only): Unique Id,
model (string, required): Model,
view (string, required): Explore Name,
fields (Array[string]): Fields,
pivots (Array[string]): Pivots,
fill_fields (Array[string]): Fill Fields,
filters (object): Filters,
filter_expression (string): Filter Expression,
sorts (Array[string]): Sorting for the query results. Use the format ["view.field", ...] to sort on fields in ascending order. Use the format ["view.field desc", ...] to sort on fields in descending order. Use ["__UNSORTED__"] (2 underscores before and after) to disable sorting entirely. Empty sorts [] will trigger a default sort.,
limit (string): Limit,
column_limit (string): Column Limit,
total (boolean): Total,
row_total (string): Raw Total,
subtotals (Array[string]): Fields on which to run subtotals,
runtime (double): Runtime,
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, read-only): Slug,
dynamic_fields (Array[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, read-only): Share Url,
expanded_share_url (string, read-only): Expanded Share Url,
url (string, read-only): Expanded Url,
query_timezone (string): Query Timezone,
has_table_calculations (boolean, read-only): Has Table Calculations,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerWithIdVisConfigAndDynamicFields {
id (long, read-only): Unique Id.,
dynamic_fields (string, read-only): JSON string of dynamic field information.,
filterables (Array[ResultMakerFilterables], read-only): array of items that can be filtered and information about them.,
sorts (string, read-only): Sorts of the constituent Look, Query, or Merge Query,
merge_result_id (string, read-only): ID of merge result if this is a merge_result.,
total (boolean, read-only): Total of the constituent Look, Query, or Merge Query,
query_id (long, read-only): ID of query if this is a query.,
query (Query, read-only): Query,
vis_config (string, read-only): Vis config of the constituent Query, or Merge Query.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterables {
model (string, read-only): The model this filterable comes from (used for field suggestions).,
view (string, read-only): The view this filterable comes from (used for field suggestions).,
name (string, read-only): The name of the filterable thing (Query or Merged Results).,
listen (Array[ResultMakerFilterablesListen], read-only): array of dashboard_filter_name: and field: objects.,
can (object, read-only): Operations the current user is able to perform on this object
}
ResultMakerFilterablesListen {
dashboard_filter_name (string): The name of a dashboard filter to listen to.,
field (string): The name of the field in the filterable to filter with the value of the dashboard filter.
}
DashboardLayout {
id (string, read-only): Unique Id,
dashboard_id (string): Id of Dashboard,
type (string): Type,
active (boolean): Is Active,
column_width (long): Column Width,
width (long): Width,
deleted (boolean, read-only): Whether or not the dashboard layout is deleted.,
dashboard_layout_components (Array[DashboardLayoutComponent], read-only): Components,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardLayoutComponent {
id (string, read-only): Unique Id,
dashboard_layout_id (string): Id of Dashboard Layout,
dashboard_element_id (string): Id Of Dashboard Element,
row (long): Row,
column (long): Column,
width (long): Width,
height (long): Height,
deleted (boolean, read-only): Whether or not the dashboard layout component is deleted,
can (object, read-only): Operations the current user is able to perform on this object
}
DashboardFilter {
id (string, read-only): Unique Id,
dashboard_id (string, read-only): Id of Dashboard,
name (string, required): Name of filter,
title (string, required): Title of filter,
type (string, required): Type of filter: one of date, number, string, or field,
default_value (string): Default value of filter,
model (string): Model of filter (required if type = field),
explore (string): Explore of filter (required if type = field),
dimension (string): Dimension of filter (required if type = field),
field (object, read-only): Field information,
row (long): Display order of this filter relative to other filters,
listens_to_filters (Array[string]): Array of listeners for faceted filters,
allow_multiple_values (boolean): Whether the filter allows multiple filter values,
required (boolean): Whether the filter requires a value to run the dashboard,
can (object, read-only): Operations the current user is able to perform on this object
}

Parameters

Parameter Required? Description Parameter Type Data Type
dashboard_id true Id of dashboard string string
fields false Requested fields. string string

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Get Dashboard Prefetch deprecated

GET/api/3.0/dashboards/{dashboard_id}/prefetch
dashboard_prefetch(dashboard_id, dashboard_filters)

Implementation Notes

Get a prefetch for a dashboard with the specified information.

Deprecated Use DataGroups to manage cache invalidation of groups of queries.

Response Class

Prefetch {
ttl (long, read-only): Number of seconds prefetch will live for.,
created_at (date-time, read-only): Time when prefetch was created.,
computation_time (float, read-only): Number of seconds it took to compute results for prefetch.,
result_size_bytes (long, read-only): Size of result.,
hit_count (long, read-only): Number of times prefetch has been accessed.,
touched_at (date-time, read-only): Time when prefetch was last accessed.,
value (object, read-only): Data associated with the queries stored by prefetching the data,
url (string, read-only): Link to get this item,
can (object, read-only): Operations the current user is able to perform on this object
}

Parameters

Parameter Required? Description Parameter Type Data Type
dashboard_id true Id of dashboard string string
dashboard_filters false JSON encoded string of Dashboard filters that were applied to prefetch array array

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}

Create Dashboard Prefetch deprecated

POST/api/3.0/dashboards/{dashboard_id}/prefetch
create_dashboard_prefetch(dashboard_id, body)

Implementation Notes

Create a prefetch for a dashboard with the specified information.

Deprecated Use DataGroups to manage cache invalidation of groups of queries.

Response Class

PrefetchDashboardRequest {
ttl (long, read-only): Number of seconds prefetch will live for.,
access_filters (Array[PrefetchAccessFilterValue], read-only): Access filters to apply when running queries for prefetch.,
dashboard_filters (Array[PrefetchDashboardFilterValue], read-only): Dashboard filters to apply when running queries for prefetch.,
created_at (date-time, read-only): Time when prefetch was created.,
computation_time (float, read-only): Number of seconds it took to compute results for prefetch.,
result_size_bytes (long, read-only): Size of result.,
hit_count (long, read-only): Number of times prefetch has been accessed.,
touched_at (date-time, read-only): Time when prefetch was last accessed.,
can (object, read-only): Operations the current user is able to perform on this object
}
PrefetchAccessFilterValue {
model (string, read-only): Access filter model name.,
field (string, read-only): Access filter field name.,
value (string, read-only): Access filter value,
can (object, read-only): Operations the current user is able to perform on this object
}
PrefetchDashboardFilterValue {
name (string, read-only): Dashboard filter name.,
value (string, read-only): Dashboard filter value,
can (object, read-only): Operations the current user is able to perform on this object
}

Parameters

Parameter Required? Description Parameter Type Data Type
dashboard_id true Id of dashboard string string
body false Parameters for prefetch request body
PrefetchDashboardRequest {
ttl (long, read-only): Number of seconds prefetch will live for.,
access_filters (Array[PrefetchAccessFilterValue], read-only): Access filters to apply when running queries for prefetch.,
dashboard_filters (Array[PrefetchDashboardFilterValue], read-only): Dashboard filters to apply when running queries for prefetch.,
created_at (date-time, read-only): Time when prefetch was created.,
computation_time (float, read-only): Number of seconds it took to compute results for prefetch.,
result_size_bytes (long, read-only): Size of result.,
hit_count (long, read-only): Number of times prefetch has been accessed.,
touched_at (date-time, read-only): Time when prefetch was last accessed.,
can (object, read-only): Operations the current user is able to perform on this object
}
PrefetchAccessFilterValue {
model (string, read-only): Access filter model name.,
field (string, read-only): Access filter field name.,
value (string, read-only): Access filter value,
can (object, read-only): Operations the current user is able to perform on this object
}
PrefetchDashboardFilterValue {
name (string, read-only): Dashboard filter name.,
value (string, read-only): Dashboard filter value,
can (object, read-only): Operations the current user is able to perform on this object
}

Response Messages

HTTP Status Code Reason Response Model
400 Bad Request
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
404 Not Found
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
409 Resource Already Exists
Error {
message (string, read-only, required): Error details,
documentation_url (string, read-only, required): Documentation link
}
422 Validation Error
ValidationError {
message (string, read-only, required): Error details,
errors (Array[ValidationErrorDetail], read-only): Error detail array,
documentation_url (string, read-only, required): Documentation link
}
ValidationErrorDetail {
field (string, read-only): Field with error,
code (string, read-only): Error code,
message (string, read-only): Error info message,
documentation_url (string, read-only, required): Documentation link
}
Top