Metabase API Integrations

Build and run workflows using the Metabase API. Use 1000s of source-available triggers and actions across 2,400+ apps. Or write custom code to integrate any app or API in seconds.

Start for free — no credit card required

Watch a demo

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: metabase

Metabase 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:

OAuth Request Configurations:

accessToken
POST{{custom_fields.server_address}}/api/sessioncontent-type: application/jsonaccept: application/json
username={{custom_fields.username}}&password={{custom_fields.password}}
refreshToken
POST{{custom_fields.server_address}}/api/sessioncontent-type: application/jsonaccept: application/json
username={{custom_fields.username}}&password={{custom_fields.password}}

Start for free — no credit card required

Watch a demo

Metabase

Metabase API Integrations

Build and run workflows using the Metabase API. Use 1000s of source-available triggers and actions across 2,400+ apps. Or write custom code to integrate any app or API in seconds.