Skip to main content
Server path: /looker-queries | Type: Application | PCID required: Yes

Tools


looker_queries_all_looks

Get All Looks Parameters:
ParameterTypeRequiredDefaultDescription
fieldsstringNoRequested fields.

looker_queries_all_running_queries

Get All Running Queries

looker_queries_copy_look

Copy Look Parameters:
ParameterTypeRequiredDefaultDescription
look_idstringYesLook id to copy.
folder_idstringNoFolder id to copy to.

looker_queries_create_look

Create Look Parameters:
ParameterTypeRequiredDefaultDescription
fieldsstringNoRequested fields.
bodyobjectYesLook

looker_queries_create_merge_query

Create Merge Query Parameters:
ParameterTypeRequiredDefaultDescription
fieldsstringNoRequested fields
bodyobjectNoMerge Query

looker_queries_create_query

Create Query Parameters:
ParameterTypeRequiredDefaultDescription
fieldsstringNoRequested fields.
bodyobjectYesQuery

looker_queries_create_query_task

Run Query Async Parameters:
ParameterTypeRequiredDefaultDescription
limitintegerNoRow limit (may override the limit in the saved query).
apply_formattingbooleanNoApply model-specified formatting to each result.
apply_visbooleanNoApply visualization options to results.
cachebooleanNoGet results from cache if available.
generate_drill_linksbooleanNoGenerate drill links (only applicable to ‘json_detail’ format.
force_productionbooleanNoForce use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used.
cache_onlybooleanNoRetrieve any results from cache even if the results have expired.
path_prefixstringNoPrefix to use for drill links (url encoded).
rebuild_pdtsbooleanNoRebuild PDTS used in query.
server_table_calcsbooleanNoPerform table calculations on query results
fieldsstringNoRequested fields
bodyobjectYesQuery parameters

looker_queries_create_sql_query

Create SQL Runner Query Parameters:
ParameterTypeRequiredDefaultDescription
bodyobjectYesSQL Runner Query

looker_queries_delete_look

Delete Look Parameters:
ParameterTypeRequiredDefaultDescription
look_idstringYesId of look

looker_queries_kill_query

Kill Running Query Parameters:
ParameterTypeRequiredDefaultDescription
query_task_idstringYesQuery task id.

looker_queries_look

Get Look Parameters:
ParameterTypeRequiredDefaultDescription
look_idstringYesId of look
fieldsstringNoRequested fields.

looker_queries_merge_query

Get Merge Query Parameters:
ParameterTypeRequiredDefaultDescription
merge_query_idstringYesMerge Query Id
fieldsstringNoRequested fields

looker_queries_move_look

Move Look Parameters:
ParameterTypeRequiredDefaultDescription
look_idstringYesLook id to move.
folder_idstringYesFolder id to move to.

looker_queries_query

Get Query Parameters:
ParameterTypeRequiredDefaultDescription
query_idstringYesId of query
fieldsstringNoRequested fields.

looker_queries_query_for_slug

Get Query for Slug Parameters:
ParameterTypeRequiredDefaultDescription
slugstringYesSlug of query
fieldsstringNoRequested fields.

looker_queries_query_task

Get Async Query Info Parameters:
ParameterTypeRequiredDefaultDescription
query_task_idstringYesID of the Query Task
fieldsstringNoRequested fields.

looker_queries_query_task_multi_results

Get Multiple Async Query Results Parameters:
ParameterTypeRequiredDefaultDescription
query_task_idsstring[]YesList of Query Task IDs

looker_queries_query_task_results

Get Async Query Results Parameters:
ParameterTypeRequiredDefaultDescription
query_task_idstringYesID of the Query Task

looker_queries_run_inline_query

Run Inline Query Parameters:
ParameterTypeRequiredDefaultDescription
result_formatstringYesFormat of result
limitintegerNoRow limit (may override the limit in the saved query).
apply_formattingbooleanNoApply model-specified formatting to each result.
apply_visbooleanNoApply visualization options to results.
cachebooleanNoGet results from cache if available.
image_widthintegerNoRender width for image formats.
image_heightintegerNoRender height for image formats.
generate_drill_linksbooleanNoGenerate drill links (only applicable to ‘json_detail’ format.
force_productionbooleanNoForce use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used.
cache_onlybooleanNoRetrieve any results from cache even if the results have expired.
path_prefixstringNoPrefix to use for drill links (url encoded).
rebuild_pdtsbooleanNoRebuild PDTS used in query.
server_table_calcsbooleanNoPerform table calculations on query results
enable_oauth_error_responsebooleanNoReturn a specialized OAuth error response if a database OAuth error occurs.
bodyobjectYesinline query

looker_queries_run_look

Run Look Parameters:
ParameterTypeRequiredDefaultDescription
look_idstringYesId of look
result_formatstringYesFormat of result
limitintegerNoRow limit (may override the limit in the saved query).
apply_formattingbooleanNoApply model-specified formatting to each result.
apply_visbooleanNoApply visualization options to results.
cachebooleanNoGet results from cache if available.
image_widthintegerNoRender width for image formats.
image_heightintegerNoRender height for image formats.
generate_drill_linksbooleanNoGenerate drill links (only applicable to ‘json_detail’ format.
force_productionbooleanNoForce use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used.
cache_onlybooleanNoRetrieve any results from cache even if the results have expired.
path_prefixstringNoPrefix to use for drill links (url encoded).
rebuild_pdtsbooleanNoRebuild PDTS used in query.
server_table_calcsbooleanNoPerform table calculations on query results

looker_queries_run_query

Run Query Parameters:
ParameterTypeRequiredDefaultDescription
query_idstringYesId of query
result_formatstringYesFormat of result
limitintegerNoRow limit (may override the limit in the saved query).
apply_formattingbooleanNoApply model-specified formatting to each result.
apply_visbooleanNoApply visualization options to results.
cachebooleanNoGet results from cache if available.
image_widthintegerNoRender width for image formats.
image_heightintegerNoRender height for image formats.
generate_drill_linksbooleanNoGenerate drill links (only applicable to ‘json_detail’ format.
force_productionbooleanNoForce use of production models even if the user is in development mode. Note that this flag being false does not guarantee development models will be used.
cache_onlybooleanNoRetrieve any results from cache even if the results have expired.
path_prefixstringNoPrefix to use for drill links (url encoded).
rebuild_pdtsbooleanNoRebuild PDTS used in query.
server_table_calcsbooleanNoPerform table calculations on query results
sourcestringNoSpecifies the source of this call.
enable_oauth_error_responsebooleanNoReturn a specialized OAuth error response if a database OAuth error occurs.

looker_queries_run_sql_query

Run SQL Runner Query Parameters:
ParameterTypeRequiredDefaultDescription
slugstringYesslug of query
result_formatstringYesFormat of result, options are: [“inline_json”, “json”, “json_detail”, “json_fe”, “json_bi”, “csv”, “html”, “md”, “txt”, “xlsx”, “gsxml”, “sql”, “odc”, “json_label”]
downloadstringNoDefaults to false. If set to true, the HTTP response will have content-disposition and other headers set to make the HTTP response behave as a downloadable attachment instead of as inline content.

looker_queries_run_url_encoded_query

Run Url Encoded Query Parameters:
ParameterTypeRequiredDefaultDescription
model_namestringYesModel name
view_namestringYesView name
result_formatstringYesFormat of result

looker_queries_search_looks

Search Looks Parameters:
ParameterTypeRequiredDefaultDescription
idstringNoMatch look id.
titlestringNoMatch Look title.
descriptionstringNoMatch Look description.
content_favorite_idstringNoSelect looks with a particular content favorite id
folder_idstringNoSelect looks in a particular folder.
user_idstringNoSelect looks created by a particular user.
view_countstringNoSelect looks with particular view_count value
deletedbooleanNoSelect soft-deleted looks
query_idstringNoSelect looks that reference a particular query by query_id
curatebooleanNoExclude items that exist only in personal spaces other than the users
last_viewed_atstringNoSelect looks based on when they were last viewed
fieldsstringNoRequested fields.
pageintegerNoDEPRECATED. Use limit and offset instead. Return only page N of paginated results
per_pageintegerNoDEPRECATED. Use limit and offset instead. Return N rows of data per page
limitintegerNoNumber of results to return. (used with offset and takes priority over page and per_page)
offsetintegerNoNumber of results to skip before returning any. (used with limit and takes priority over page and per_page)
sortsstringNoOne or more fields to sort results by. Sortable fields: [:title, :user_id, :id, :created_at, :space_id, :folder_id, :description, :updated_at, :last_updater_id, :view_count, :favorite_count, :content_favorite_id, :deleted, :deleted_at, :last_viewed_at, :last_accessed_at, :query_id, :certification_status]
filter_orbooleanNoCombine given search criteria in a boolean OR expression

looker_queries_sql_query

Get SQL Runner Query Parameters:
ParameterTypeRequiredDefaultDescription
slugstringYesslug of query

looker_queries_update_look

Update Look Parameters:
ParameterTypeRequiredDefaultDescription
look_idstringYesId of look
fieldsstringNoRequested fields.
bodyobjectYesLook

looker_queries_update_look_certification

Update Look Certification Parameters:
ParameterTypeRequiredDefaultDescription
look_idstringYesLook id to update certification.
bodyobjectYesCertification Data