The World's Most Advanced Open Source Relational Database
Emit new event when a new message is posted to one or more channels
Send a message to a public channel and customize the name and avatar of the bot that posts the message. See postMessage or scheduleMessage docs here
Send a message to a private channel and customize the name and avatar of the bot that posts the message. See postMessage or scheduleMessage docs here
Assuming you want a few paragraphs on what you can do with the PostgreSQL API:
The following examples demonstrate some of the things that can be done with the
PostgreSQL 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()
},
})
With the Slack API, you can build all sorts of integrations and applications to
make your work life easier. Here are just a few examples:
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
slack: {
type: "app",
app: "slack",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://slack.com/api/users.profile.get`,
headers: {
Authorization: `Bearer ${this.slack.$auth.oauth_access_token}`,
},
})
},
})