MySQL

Open-source relational database

Go to site

Integrate the MySQL API with the IP2WHOIS API

Setup the MySQL API trigger to run a workflow which integrates with the IP2WHOIS API. Pipedream's integration platform allows you to integrate MySQL and IP2WHOIS 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 IP2WHOIS

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    ip2whois: {
      type: "app",
      app: "ip2whois",
    },
    domain: {
      type: "string",
      default: "greendot.com"
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.ip2whois.com/v2?key={your_license_key}&domain={domain_name}`,
      params: {
        key: `${this.ip2whois.$auth.api_key}`,
        domain: `${this.domain}`,
      },
    })
  },
})