MySQL

MySQL is an open-source relational database management system.

Integrate the MySQL API with the Bandwidth API

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

Create Row with MySQL API on New Incoming SMS from Bandwidth API
Bandwidth + MySQL
 
Try it
Create Row with MySQL API on New Outgoing SMS from Bandwidth API
Bandwidth + MySQL
 
Try it
Delete Row with MySQL API on New Incoming SMS from Bandwidth API
Bandwidth + MySQL
 
Try it
Delete Row with MySQL API on New Outgoing SMS from Bandwidth API
Bandwidth + MySQL
 
Try it
Execute Query with MySQL API on New Incoming SMS from Bandwidth API
Bandwidth + MySQL
 
Try it
New Incoming SMS from the Bandwidth API

Emits an event each time a message-received event is received at the source url

 
Try it
New Outgoing SMS from the Bandwidth API

Emits an event each time an outbound message status event is received at the source url

 
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
Create Row with the MySQL API

Adds a new row. See the docs here

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it
Execute Query with the MySQL API

Find row(s) via a custom query. See the docs here

 
Try it
Send SMS with the Bandwidth API

Send an SMS message using Bandwidth's Messaging API

 
Try it
Execute Stored Procedure with the MySQL API

Execute Stored Procedure. See the docs here

 
Try it

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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
import mysql from 'mysql2/promise';

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

    const isRejectUnauthorizedUndefined = rejectUnauthorized === undefined;
    const isSslSet = !!(ca && key && cert);

    const connectionConfig = {
      host,
      port,
      user,
      password,
      database,
      ...(isSslSet && {
        ssl: {
          rejectUnauthorized: true,
          ca,
          cert,
          key,
        },
      }),
      ...(!isSslSet && !isRejectUnauthorizedUndefined && {
        ssl: {
          rejectUnauthorized,
        },
      }),
    };

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

Overview of Bandwidth

With the Bandwidth API, you can build a variety of applications and tools for
managing your communication needs. Here are a few examples of what you can
build:

  • A tool for monitoring your bandwidth usage
  • A tool for managing your contact lists
  • A tool for sending and receiving text messages
  • A tool for making and receiving phone calls
  • A tool for recording and storing call data

Connect Bandwidth

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: {
    bandwidth: {
      type: "app",
      app: "bandwidth",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://dashboard.bandwidth.com/api/accounts/${this.bandwidth.$auth.accountId}/applications`,
      auth: {
        username: `${this.bandwidth.$auth.username}`,
        password: `${this.bandwidth.$auth.password}`,
      },
    })
  },
})