Integrate the HTTP / Webhook API with the MySQL API

// To use any npm package on Pipedream, just import it
import axios from "axios"

export default defineComponent({
  async run({ steps, $ }) {
    const { data } = await axios({
      method: "GET",
      url: "https://pokeapi.co/api/v2/pokemon/charizard",
    })
    return data.species
  },
})

import mysql from 'mysql2/promise';
export default defineComponent({
  props: {
    mysql: {
      type: "app",
      app: "mysql",
    }
  },
  async run({steps, $}) {
    
    const { host, port, username, password, database } = this.mysql.$auth
    
    const connection = await mysql.createConnection({
      host,
      port,
      user: username,
      password,
      database,
    });
    
    const [rows] = await connection.execute('SELECT NOW()');
    return rows
  },
})