PostgreSQL

The World's Most Advanced Open Source Relational Database

Go to site

Integrate the PostgreSQL API with the Telegram Bot API

Setup the PostgreSQL API trigger to run a workflow which integrates with the Telegram Bot API. Pipedream's integration platform allows you to integrate PostgreSQL and Telegram Bot remarkably fast. Free for developers.

Send Telegram Message

Sends a message using the sendMessage API method: https://core.telegram.org/bots/api#sendmessage

 
Try it

Connect PostgreSQL

const { Client } = require('pg')

const { host, user, password, port, database } = auths.postgresql

const client = new Client({
  host,
  database,
  user,
  password,
  port,
})

await client.connect()
this.results = (await client.query("SELECT NOW()")).rows
await client.end()

Connect Telegram Bot

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://api.telegram.org/bot${auths.telegram_bot_api.token}/getMe`,
})