with Webvizio and PostgreSQL?
Emit new event when a new project is created. See the documentation
Emit new event when a project is updated. See the documentation
Emit new event when a new column is added to a table. See the documentation
Emit new event when a row is added or modified. See the documentation
Finds a row in a table via a custom query. See the documentation
The Webvizio API provides a platform for website project management, enabling users to manage tasks, collaborate on web development projects, and review website changes in real-time. With Pipedream, you can harness this API to automate feedback loops, sync tasks with other project management tools, and create a seamless integration between your website updates and your project tracking system.
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    webvizio: {
      type: "app",
      app: "webvizio",
    }
  },
  async run({steps, $}) {
    const data = {
      "url": `{{your_webhook_url}}`, //I.E. https://app.webvizio.com/api/v1/webhook
      "event": `{{your_event}}`,   //i.e. task.updated
    }
    return await axios($, {
      method: "POST",
      url: `https://app.webvizio.com/api/v1/webhook`,
      headers: {
        Authorization: `Bearer ${this.webvizio.$auth.api_token}`,
      },
      data,
    })
  },
})
On Pipedream, you can leverage the PostgreSQL app to create workflows that automate database operations, synchronize data across platforms, and react to database events in real-time. Think handling new row entries, updating records from webhooks, or even compiling reports on a set schedule. Pipedream's serverless platform provides a powerful way to connect PostgreSQL with a variety of apps, enabling you to create tailored automation that fits your specific needs.
import postgresql from "@pipedream/postgresql"
export default defineComponent({
  props: {
    postgresql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql
    const queryObj = {
      text: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    return await this.postgresql.executeQuery(queryObj);
  },
})