MySQL
Open-source relational database
Integrate the MySQL API with the IP2WHOIS API
Setup the MySQL API trigger to run a workflow which integrates with the IP2WHOIS API. Pipedream's integration platform allows you to integrate MySQL and IP2WHOIS remarkably fast. Free for developers.
Popular MySQL and IP2WHOIS Triggers#
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
New Row (Custom Query) from the MySQL API
Emit new event when new rows are returned from a custom query. See the docs here
New Table from the MySQL API
Emit new event when a new table is added to a database. See the docs here
Popular MySQL and IP2WHOIS Actions#
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
module.exports = defineComponent({
props: {
mysql: {
type: "app",
app: "mysql",
}
},
async run({steps, $}) {
const mysql = require('mysql2/promise');
const { host, port, username, password, database } = this.mysql.$auth
const connection = await mysql.createConnection({
host,
port,
user: username,
password,
database,
});
const [rows, fields] = await connection.execute('SELECT NOW()');
console.log(rows)
},
})
Connect IP2WHOIS#
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
ip2whois: {
type: "app",
app: "ip2whois",
},
domain: {
type: "string",
default: "greendot.com"
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.ip2whois.com/v2?key={your_license_key}&domain={domain_name}`,
params: {
key: `${this.ip2whois.$auth.api_key}`,
domain: `${this.domain}`,
},
})
},
})