Integrate the FogBugz API with the Supabase API

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

Popular Ways to Connect FogBugz with Supabase#

Create Case with FogBugz API on New Row Added from Supabase API

Supabase + FogBugz

Try it

Create Case with FogBugz API on New Webhook Event (Instant) from Supabase API

Supabase + FogBugz

Try it

Delete Row with Supabase API on New Case Event from FogBugz API

FogBugz + Supabase

Try it

Delete Row with Supabase API on New Case in Filter from FogBugz API

FogBugz + Supabase

Try it

Delete Row with Supabase API on New Person Created from FogBugz API

FogBugz + Supabase

Try it

Popular FogBugz and Supabase Triggers#

New Case Event from the FogBugz API

Emit new event instantaneously when something significant happens to a case.

Try it

New Row Added from the Supabase API

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

Try it

New Case in Filter from the FogBugz API

Emit new new event when there's a new case under a specified filter. Note this may not effectively work for filters that generate results too long, or filters with more than 50,000 cases, especially if your FogBugz site is running Ocelot.

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

New Person Created from the FogBugz API

Emit new event when a new person or a user is created in FogBugz. It effectively tracks the addition of new users in the system.

Try it

Popular FogBugz and Supabase Actions#

Create Case with the FogBugz API

Creates a new case on FogBugz. See the documentation

Try it

Delete Row with the Supabase API

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

Try it

List Projects with the FogBugz API

Gets a list of projects in FogBugz. This can be used to quickly view all projects and their details. See the documentation

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

Overview of FogBugz#

The FogBugz API allows you to interact with your FogBugz software development tracking system programmatically. With this API, you can create, read, update, and delete cases; manage projects, areas, and categories; and perform searches to gather data-driven insights. Integrating FogBugz with Pipedream opens up possibilities for automating workflows, syncing data across platforms, and reacting to events within FogBugz in real-time.

Connect FogBugz#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    fogbugz: {
      type: "app",
      app: "fogbugz",
    }
  },
  async run({steps, $}) {
    const data = {
      "cmd": `listPeople`,
      "token": `${this.fogbugz.$auth.api_token}`,
    }
    return await axios($, {
      method: "post",
      url: `https://${this.fogbugz.$auth.your_site}.fogbugz.com/f/api/0/jsonapi`,
      headers: {
        "Content-Type": `application/json`,
      },
      data,
    })
  },
})

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#

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}`,
      },
    })
  },
})