MySQL

MySQL is an open-source relational database management system.

Integrate the MySQL API with the Namely API

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

Execute Raw Query with MySQL API on New Created User from Namely API
Namely + MySQL
 
Try it
Execute Raw Query with MySQL API on New Updated User from Namely API
Namely + MySQL
 
Try it
Create Row with MySQL API on New Created User from Namely API
Namely + MySQL
 
Try it
Create Row with MySQL API on New Updated User from Namely API
Namely + MySQL
 
Try it
Create User with Namely API on New Column from MySQL API
MySQL + Namely
 
Try it
New Created User from the Namely API

Emit new event for each user created.

 
Try it
New Updated User from the Namely API

Emit new event for each user updated.

 
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
Execute SQL Query with the MySQL API

Execute a custom MySQL query. See our docs to learn more about working with SQL in Pipedream.

 
Try it
Create User with the Namely API

Creates a new user. See docs here

 
Try it
Create Row with the MySQL API

Adds a new row. See the docs here

 
Try it
Get User with the Namely API

Get a user. See docs here

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it

Overview of MySQL

The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.

Connect MySQL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
import mysql from '@pipedream/mysql';

export default defineComponent({
  props: {
    mysql,
  },
  async run({steps, $}) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/mysql

    const queryObj = {
      sql: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    return await this.mysql.executeQuery(queryObj);
  },
});

Overview of Namely

Namely is a Human Resources Information System (HRIS) designed to simplify HR, payroll, benefits, and talent management. By leveraging the Namely API on Pipedream, you can automate employee data synchronization across various platforms, streamline HR operations by triggering workflows based on employee lifecycle events, and even analyze workforce data to gain insights. It's a potent tool for HR professionals looking to integrate their HR tech stack and automate repetitive tasks.

Connect Namely

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    namely: {
      type: "app",
      app: "namely",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.namely.$auth.subdomain}.namely.com/api/v1/profiles/me`,
      headers: {
        Authorization: `Bearer ${this.namely.$auth.oauth_access_token}`,
      },
    })
  },
})