MySQL

MySQL is an open-source relational database management system.

Integrate the MySQL API with the MongoDB API

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

Create New Document with MongoDB API on New Column from MySQL API
MySQL + MongoDB
 
Try it
Create New Document with MongoDB API on New or Updated Row from MySQL API
MySQL + MongoDB
 
Try it
Create New Document with MongoDB API on New Row (Custom Query) from MySQL API
MySQL + MongoDB
 
Try it
Create New Document with MongoDB API on New Row from MySQL API
MySQL + MongoDB
 
Try it
Create New Document with MongoDB API on New Table from MySQL API
MySQL + MongoDB
 
Try it
New Collection from the MongoDB API

Emit new an event when a new collection is added to a database

 
Try it
New Database from the MongoDB API

Emit new an event when a new database is added

 
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 Document from the MongoDB API

Emit new an event when a new document is added to a collection

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

Adds a new row. See the docs here

 
Try it
Create New Document with the MongoDB API

Create a new document in a collection of your choice. See the docs here

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it
Delete a Document with the MongoDB API

Delete a single document by ID. 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

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 MongoDB

Assuming you want a few paragraph about the MongoDB API:

MongoDB offers a powerful API that allows developers to interact with their
databases in a variety of ways. The API provides methods for performing
standard CRUD (create, read, update, delete) operations, as well as more
specialized methods like bulk write operations and aggregate queries. MongoDB
also offers a rich set of indexing options that allow developers to optimize
their queries for maximum performance. With the MongoDB API, developers can
build a wide variety of applications, from simple data-driven apps to complex
event-driven systems.

Connect MongoDB

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
import mongodb from 'mongodb'

export default defineComponent({
  props: {
    mongodb: {
      type: "app",
      app: "mongodb",
    },
    collection: {
      type: "string"
    },
    filter: {
      type: "object"
    }
  },
  async run({steps, $}) {
    const MongoClient = mongodb.MongoClient
    
    const {
      database,
      hostname,
      username,
      password,
    } = this.mongodb.$auth
    
    const url = `mongodb+srv://${username}:${password}@${hostname}/test?retryWrites=true&w=majority`
    const client = await MongoClient.connect(url, { 
      useNewUrlParser: true, 
      useUnifiedTopology: true 
    })
    
    const db = client.db(database)

    const results = await db.collection(this.collection).find(this.filter).toArray();
    $.export('results', results);
    
    await client.close()
  },
})