PostgreSQL

The World's Most Advanced Open Source Relational Database

Go to site

Integrate the PostgreSQL API with the Twilio API

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

Send an SMS

Sends a new SMS message

 
Try it
Make a Phone Call

Make a phone call, passing text that Twilio will speak to the user

 
Try it
POST /Accounts/{AccountSid}/Messages

To send a new outgoing message, make an HTTP POST to your Messages list resource URI

 
Try it
Get Message

Gets a single message specified by the provided Message {SID}.

 
Try it
Get Messages

Gets a list of messages associated with your account. The list includes paging information.

 
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 Twilio

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://api.twilio.com/2010-04-01/Accounts.json`,
  auth: {
    username: `${auths.twilio.Sid}`,
    password: `${auths.twilio.Secret}`,
  },
})

Community Posts

How Our Family Uses SMS and Smart Picture Frames to Connect During Remote Holidays
How Our Family Uses SMS and Smart Picture Frames to Connect During Remote Holidays
Two days before Thanksgiving, I decided to put together a simple way for our family to share pictures, because we couldn’t be together in person. The idea: smart photo frames that everyone could text pictures to. Here’s how I got it working. tldr; A Pipedream workflow parses SMS messages sent to a Twilio phone number, extracting the pictures and then using SendGrid to email them to the dedicated email addresses used by our Pix-Star photo frames.