Can I download a dashboard as a CSV or PDF via the API?
Knowledge DropLast tested: Sep 27, 2019 For PDF: Yes. Use create_render_task() to schedule a job to render a d...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
How can I create a new project via the API?
Knowledge DropLast tested: Mar 8, 2018 Use the create_project call on the projects endpoint. https://docs.look...
What is a cURL API call, and what does it look like?
Knowledge DropLast tested: Nov 4, 2020 cURL is a command-line utility available on most Unix/Linux based opera...
Is it possible to connect to the API without an SSL connection?
Knowledge DropLast tested: Oct 16, 2020 Nope - connecting to the API requires an https connection with a valid...
How do I get a list of recently viewed dashboards by a user through the Looker API?
1 ) Hit login_user to login as the user (https://docs.looker.com/reference/api-and-integration/api-reference/v...
Can you add, edit, or update table calculations in Looks via the API?
Yes, you can update the query object associated with a Look. There's a property called dynamic_fields which yo...
What does the graph_derived_tables_for_model endpoint do?
You can use the graph_derived_tables_for_model endpoint (documentation) to get a dependency graph of all the P...
Is there any size or character limit on the JSON body for api calls?
Knowledge DropLast tested: Oct 1, 2019 Not that we are aware of.The input boxes on the API Docs might have a l...
Can I switch branches via the API?
Knowledge DropLast tested: May 29, 2018 Yes, the all_git_branches, git_branch, create_git_branch, update_git_b...
Can you bust the cache instance-wide via the API ?
Knowledge DropLast tested: Oct 7, 2019Nope, but you can bust the cache per-model using Datagroups. This post t...
What is the parent_id for my folder?
Knowledge DropLast tested: Mar 22, 2020 Use Case:We want to find metadata about our content so we hit the all_...
Can I create API credentials for an embed user via the API? If not, can I sudo as a user via the API?
Knowledge DropLast tested: Sep 1, 2020 It is not possible to create API credentials for an embed user, so you ...
Can one user have multiple concurrent sessions / tokens in the API in use at once?
Knowledge DropLast tested: Oct 7, 2019Yes. Multiple access tokens can be active concurrently for the same Look...
Schedule to 2 SFTP Servers Via the API
Knowledge DropLast tested: Jan 20, 2020 You can send a single schedule to 2 SFTP servers using the API! In ord...
How does query killing work via the API?
Knowledge DropLast tested: Oct 7, 2019 Here are some facts about queries are killed via the API:Only admin API...
The "How To" on initializing the SDK with different profiles in your ini file
Knowledge DropLast tested: May 13, 2020 For those that don't know, the ini file contains information like clie...
Expand Tables in PDF - API
Knowledge DropLast tested: Jul 20, 2020 We have the pdf_paper_size option for the render_task() endpoint, so w...
How to Move a Look to a New Looker Instance
Knowledge DropLast tested: Jun 25, 2020 You can find the Python script in this repository.The Easy WayUse Look...
API Error (nodename nor servname provided, or not known')
Knowledge DropLast tested: Jan 10, 2019 When you have an issue with API authentication and received the follow...
How do I get a list of dashboards that a user has access to via the API?
Knowledge DropLast tested: Dec 28, 2017 First, you will want to pull down the content_metadata_id and id field...
Automatic Looker API Auth Token Renewal in Postman
Knowledge DropLast tested: 8/26/2022Note: This content is also available on Github. Are you lazy like me and w...
Can you use the search_dashboards() API endpoint to get information about LookML dashboards?
Knowledge DropLast tested: Mar 9, 2020No. The search_dashboards() endpoint doesn't return LookML dashboards at...
Why are my API-accessed JSON objects returning numbers instead of strings?
Knowledge DropLast tested: Oct 7, 2019There was a legacy feature that allowed JSON numbers to return as string...
Steps for Creating a New User (email creds, role, group) via Python SDK
Knowledge DropLast tested: Nov 8, 2020 There are a few steps to creating a new user with the api/sdk. We have ...
Can you edit a look's visualization settings using the API?
Knowledge DropLast tested: Jun 12, 2018 Yep, you can configure a visualization of a query using the query.vis_...
Group API - User Attribute Group Value
Knowledge DropLast tested: Oct 24, 2019 We can use this endpoint to set or update an individual user attribute...
In the `update_datagroup` api call, will: {“stale_before”: now()} bust the cache?
Knowledge DropLast tested: Oct 1, 2019 Yes, this will blow the cache for that datagroup regardless of the trig...
How do I update filters on a Look with the API?
Knowledge DropLast tested: Sep 17, 2020 Get the existing query using the look endpoint Create a new query with...
sdk[object Object] (node:node_number) UnhandledPromiseRejectionWarning: Error: Error: ESOCKETTIMEDOUTat sdkError
Knowledge DropLast tested: May 29, 2020 (async () => {const sdk = LookerNodeSDK.init31();const dashboards = aw...
What is the maximum frequency at which I can send schedules/alerts?
Knowledge DropLast tested: Apr 13, 2020 1 every 5 minutes in the UI1 per minute with the APIThe other option w...
