Integrate the PostgreSQL API with the HTTP / Webhook API

module.exports = defineComponent({
  props: {
    postgresql: {
      type: "app",
      app: "postgresql",
    }
  },
  async run({steps, $}) {
    const { Client } = require('pg')
    
    const { host, user, password, port, database } = this.postgresql.$auth
    
    const client = new Client({
      host,
      database,
      user,
      password,
      port,
    })
    
    await client.connect()
    this.results = (await client.query("SELECT NOW()")).rows
    await client.end()
  },
})

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