What do you want to automate with Looker?
Prompt, edit and deploy AI agents that connect to Looker and 2,500+ other apps in seconds.
1-24of2,500+apps by most popular
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Overview#
The Looker API provides programmatic access to Looker's data exploration functionalities, allowing you to tap into your data analytics and share insights across your organization dynamically. With the Looker API on Pipedream, you can automate reporting, synchronize analytics data with other apps, and trigger data-driven workflows. Whether it's scheduling reports, updating dashboards, or integrating data insights into other systems, the Looker API empowers you to make data-informed decisions efficiently.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
looker: {
type: "app",
app: "looker",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.looker.$auth.looker_base_url}/api/4.0/user`,
headers: {
"Authorization": `token ${this.looker.$auth.oauth_access_token}`,
},
})
},
})
Example Use Cases#
Scheduled Report Dispatch: Configure a Pipedream workflow that triggers at regular intervals, fetches the latest reports from Looker, and sends them via email or Slack. This automation ensures stakeholders receive timely analytics updates without manual intervention.
Dashboard Activity Monitoring: Set up a Pipedream workflow that uses the Looker API to monitor changes or views on specific dashboards. Whenever there's a significant change, the workflow could trigger notifications or log the event in a tool like Google Sheets or a project management app like Trello, helping teams stay aligned with the latest data insights.
Data Sync Between Looker and CRM: Create a Pipedream workflow that regularly pulls data from Looker and updates the records in a Customer Relationship Management (CRM) system like Salesforce. This ensures that sales and marketing teams have access to the latest data analytics for better customer engagement and personalized experiences.
Authentication#
Name Slug: lookerLooker uses OAuth authentication. When you connect your Looker account, Pipedream will open a popup window where you can sign into Looker and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Looker API.
Pipedream requests the following authorization scopes when you connect your account:
- accessToken
POST{{custom_fields.looker_base_url}}/api/4.0/logincontent-type:application/x-www-form-urlencodedaccept:application/jsonclient_id={{custom_fields.client_id}}&client_secret={{custom_fields.client_secret}} - refreshToken
POST{{custom_fields.looker_base_url}}/api/4.0/logincontent-type:application/x-www-form-urlencodedaccept:application/jsonclient_id={{custom_fields.client_id}}&client_secret={{custom_fields.client_secret}}
Trusted by 1,000,000+ developers from startups to Fortune 500 companies