PostgreSQL

The World's Most Advanced Open Source Relational Database

Go to site

Integrate the PostgreSQL API with the HTTP / Webhook API

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

HTTP / Webhook Request

Make an HTTP or webhook request and return the response as a step export.

 
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 HTTP / Webhook

return await require("@pipedreamhq/platform").axios(this, {
  url: "http://api.open-notify.org/iss-now.json"
})

Community Posts

A Look at Pipedream
A Look at Pipedream
I'm going to build a workflow that will search Twitter every hour for a keyword. It will take the results, format them nicely, and then email it.
Building a Traffic-Based Workflow in Pipedream
Building a Traffic-Based Workflow in Pipedream
Normally I don't like to blog about stuff that isn't generally available to all, but as it will be available sometime soon, I decided to go ahead anyway. And I built something really cool I want to share so that's another reason to talk about this now!