What do you want to automate with Metabase?
Prompt, edit and deploy AI agents that connect to Metabase and 2,500+ other apps in seconds.
1-24of2,700+apps by most popular
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Overview#
The Metabase API opens a gateway to interact with Metabase programmatically, enabling you to automate reporting, dashboards, and data analysis operations. With Pipedream, you can harness this API to trigger workflows, manipulate data, and integrate with various other apps to create a seamless data ecosystem. Think of syncing Metabase insights with other tools, automating report generation, or reacting to events within your Metabase instance in real-time.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
metabase: {
type: "app",
app: "metabase",
}
},
async run({steps, $}) {
return await axios($, {
url: `${this.metabase.$auth.server_address}/api/user/current`,
headers: {
"X-Metabase-Session": `${this.metabase.$auth.oauth_access_token}`,
},
})
},
})
Example Use Cases#
Automated Reporting: Use Pipedream to set up scheduled triggers that fetch reports from Metabase and send them via email or Slack. This workflow can help teams stay updated with the latest insights without manual intervention.
Dashboard Sync: Create a workflow that listens for updates in a specific Metabase dashboard and synchronizes those changes with a Google Sheets document. This allows for easy sharing and collaboration on data insights with stakeholders who prefer working in spreadsheets.
Alerting on Metrics: Set up a Pipedream workflow that monitors specific metrics within Metabase. If certain thresholds are crossed, actions can be taken automatically, like sending alerts through SMS using Twilio or creating a task in project management tools like Trello.
Authentication#
Name Slug: metabaseMetabase uses OAuth authentication. When you connect your Metabase account, Pipedream will open a popup window where you can sign into Metabase and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Metabase API.
Pipedream requests the following authorization scopes when you connect your account:
- accessToken
POST{{custom_fields.server_address}}/api/sessioncontent-type:application/jsonaccept:application/jsonusername={{custom_fields.username}}&password={{custom_fields.password}} - refreshToken
POST{{custom_fields.server_address}}/api/sessioncontent-type:application/jsonaccept:application/jsonusername={{custom_fields.username}}&password={{custom_fields.password}}
Trusted by 1,000,000+ developers from startups to Fortune 500 companies