MySQL

Open-source relational database

Go to site

Integrate the MySQL API with the HTTP / Webhook API

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

Connect MySQL

module.exports = defineComponent({
  props: {
    mysql: {
      type: "app",
      app: "mysql",
    }
  },
  async run({steps, $}) {
    const mysql = require('mysql2/promise');
    
    const { host, port, username, password, database } = this.mysql.$auth
    
    const connection = await mysql.createConnection({
      host,
      port,
      user: username,
      password,
      database,
    });
    
    const [rows, fields] = await connection.execute('SELECT NOW()');
    console.log(rows)
  },
})

Connect HTTP / Webhook

export default defineComponent({
  props: {
    http: {
      type: "http_request",
      default: {
        method: "GET",
        url: "http://api.open-notify.org/iss-now.json",
      }
    }
  },
  async run({steps, $}) {
    return await this.http.execute()
  },
})

Community Posts

A Look at Pipedream
A Look at Pipedream
I'm going to build a workflow that will search Twitter every hour for a keyword. It will take the results, format them nicely, and then email it.
Building a Traffic-Based Workflow in Pipedream
Building a Traffic-Based Workflow in Pipedream
Normally I don't like to blog about stuff that isn't generally available to all, but as it will be available sometime soon, I decided to go ahead anyway. And I built something really cool I want to share so that's another reason to talk about this now!