MySQL

MySQL is an open-source relational database management system.

Integrate the MySQL API with the Ongage API

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

Ongage Find Subscriber with Ongage API on New Column from MySQL API
MySQL + Ongage
 
Try it
Ongage Find Subscriber with Ongage API on New or Updated Row from MySQL API
MySQL + Ongage
 
Try it
Ongage Find Subscriber with Ongage API on New Row (Custom Query) from MySQL API
MySQL + Ongage
 
Try it
Ongage Find Subscriber with Ongage API on New Row from MySQL API
MySQL + Ongage
 
Try it
Ongage Find Subscriber with Ongage API on New Table from MySQL API
MySQL + Ongage
 
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
New Table from the MySQL API

Emit new event when a new table is added to a database. See the docs here

 
Try it
Create Row with the MySQL API

Adds a new row. See the docs here

 
Try it
Ongage Find Subscriber with the Ongage API

Find a list subscriber in Ongage.

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it
Ongage Subscribe with the Ongage API

Subscribe to a list in Ongage.

 
Try it
Execute Query with the MySQL API

Find row(s) via a custom query. 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 Ongage

With the Ongage API, you can build powerful, data-driven marketing automation
tools that make complex campaigns easy to manage, saving both time and money.
Here are some examples of what you can build by leveraging the Ongage API:

  • Create dynamic segments of customers and prospects based on a variety of
    criteria.
  • Create and schedule email campaigns, automated messages, and SMS messages.
  • Monitor the performance of campaigns and optimize ad impressions for more
    effective results.
  • Integrate with third-party services such as Salesforce, HubSpot, and Marketo
    to easily store and track customer and prospect data for better marketing
    decision-making.
  • Automate marketing processes like onboarding and retention, providing a
    seamless experience for customers and prospects.
  • Track results from multiple campaigns and measure ROI using detailed
    analytics and reporting.
  • Build custom dashboards and reporting based on the data collected from
    campaigns.
  • Automate segmentation and targeting to ensure campaigns are always sent to
    the right audience.
  • Create automated triggered campaigns that respond in real-time to customer
    and prospect behavior.
  • Easily sync data between multiple platforms to keep customer and prospect
    data up-to-date.
  • And much more!

Connect Ongage

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    ongage: {
      type: "app",
      app: "ongage",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.ongage.net/api/lists`,
      headers: {
        "x_username": `${this.ongage.$auth.x_username}`,
        "x_password": `${this.ongage.$auth.x_password}`,
        "x_account_code": `${this.ongage.$auth.x_account_code}`,
      },
    })
  },
})