Mode

Answer any question, fast. Mode brings SQL, Python, Rstats and custom visualizations together in one analytics platform.

Integrate the Mode API with the Supabase API

Setup the Mode API trigger to run a workflow which integrates with the Supabase API. Pipedream's integration platform allows you to integrate Mode and Supabase remarkably fast. Free for developers.

New Row Added from the Supabase API

Emit new event for every new row added in a table. See documentation here

 
Try it
New Webhook Event (Instant) from the Supabase API

Emit new event for every insert, update, or delete operation in a table. This source requires user configuration using the Supabase website. More information in the README. Also see documentation here

 
Try it
Delete Row with the Supabase API

Deletes row(s) in a database. See the docs here

 
Try it
Insert Row with the Supabase API

Inserts a new row into a database. See the docs here

 
Try it
Remote Procedure Call with the Supabase API

Call a Postgres function in a database. See the docs here

 
Try it
Select Row with the Supabase API

Selects row(s) in a database. See the docs here

 
Try it
Update Row with the Supabase API

Updates row(s) in a database. See the docs here

 
Try it

Overview of Mode

The Mode API provides programmatic access to Mode's analytics platform, allowing you to automate interactions with your Mode workspace. Using Mode with Pipedream, you can create workflows that interact with reports, queries, and spaces, or even manage members and permissions. This can include tasks like triggering a report run, fetching query results, or syncing users from other systems into Mode. By leveraging Pipedream's serverless platform, you can build robust, event-driven automations that integrate Mode with hundreds of other apps without the need for dedicated infrastructure.

Connect Mode

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    mode: {
      type: "app",
      app: "mode",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://app.mode.com/api/account`,
      headers: {
        "Accept": `application/json`,
        "Content-Type": `application/json`,
      },
      auth: {
        username: `${this.mode.$auth.token}`,
        password: `${this.mode.$auth.password}`,
      },
    })
  },
})

Overview of Supabase

Supabase is a real-time backend-as-a-service that provides developers with a suite of tools to quickly build and scale their applications. It offers database storage, authentication, instant APIs, and real-time subscriptions. With the Supabase API, you can perform CRUD operations on your database, manage users, and listen to database changes in real time. When integrated with Pipedream, you can automate workflows that react to these database events, synchronize data across multiple services, or streamline user management processes.

Connect Supabase

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    supabase: {
      type: "app",
      app: "supabase",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.supabase.$auth.subdomain}.supabase.co/rest/v1/`,
      headers: {
        Authorization: `Bearer ${this.supabase.$auth.service_key}`,
        "apikey": `${this.supabase.$auth.service_key}`,
      },
    })
  },
})