Twilio

Twilio is a cloud communications platform for building SMS, Voice & Messaging applications on an API built for global scale.

Integrate the Twilio API with the MySQL API

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

Send SMS with Twilio API on New Column from MySQL API
MySQL + Twilio
 
Try it
Send SMS with Twilio API on New or Updated Row from MySQL API
MySQL + Twilio
 
Try it
Send SMS with Twilio API on New Row (Custom Query) from MySQL API
MySQL + Twilio
 
Try it
Send SMS with Twilio API on New Row from MySQL API
MySQL + Twilio
 
Try it
Send SMS with Twilio API on New Table from MySQL API
MySQL + Twilio
 
Try it
New Incoming SMS (Instant) from the Twilio API

Emit new event every time an SMS is sent to the phone number set. Configures a webhook in Twilio, tied to an incoming phone number.

 
Try it
New Column from the MySQL API

Emit new event when you add a new column to a table. See the docs here

 
Try it
New or Updated Row from the MySQL API

Emit new event when you add or modify a new row in a table. See the docs here

 
Try it
New Row from the MySQL API

Emit new event when you add a new row to a table. See the docs here

 
Try it
New Row (Custom Query) from the MySQL API

Emit new event when new rows are returned from a custom query. See the docs here

 
Try it
Send SMS with the Twilio API

Send a simple text-only SMS. See the docs for more information

 
Try it
Create Row with the MySQL API

Adds a new row. See the docs here

 
Try it
Make a Phone Call with the Twilio API

Make a phone call, passing text that Twilio will speak to the recipient of the call. See the docs for more information

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it
Send MMS with the Twilio API

Send an SMS with text and media files. See the docs for more information

 
Try it

Overview of Twilio

With the Twilio API, you can build telephone applications that make and receive
phone calls, as well astext messaging applications that send and receive text
messages.

Some examples of applications you could build include:

  • A phone call application that allows you to make and receive phone calls over
    the internet
  • A text messaging application that allows you to send and receive text
    messages over the internet
  • A voicemail application that allows you to leave and receive voicemails over
    the internet

Connect Twilio

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    twilio: {
      type: "app",
      app: "twilio",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.twilio.com/2010-04-01/Accounts.json`,
      auth: {
        username: `${this.twilio.$auth.AccountSid}`,
        password: `${this.twilio.$auth.AuthToken}`,
      },
    })
  },
})

Overview of MySQL

MySQL is a powerful database management system used by some of the largest
organizations in the world, including Facebook, Google, and Amazon. MySQL is an
open-source relational database management system (RDBMS), as well as a popular
choice for web applications used by millions of websites.

Some applications that can be built using the MySQL API include:

  • A web application that stores and retrieves data from a MySQL database
  • A desktop application that uses a MySQL database for data storage
  • A mobile application that interacts with a MySQL database

Connect MySQL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
import mysql from 'mysql2/promise';

export default defineComponent({
  props: {
    mysql: {
      type: "app",
      app: "mysql",
    }
  },
  async run({steps, $}) {
    const { host, port, username, password, database, ca, cert, key } = this.mysql.$auth;

    const sslConfig = ca && cert && key ? {
      ssl: {
        rejectUnauthorized: true,
        ca,
        cert,
        key,
      },
    } : {};

    const connectionConfig = {
      host,
      port,
      user: username,
      password,
      database,
      ...sslConfig,
    };

    const connection = await mysql.createConnection(connectionConfig);
    
    const [rows] = await connection.execute('SELECT NOW()');
    return rows;
  },
});

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.