Integrate the ERPNext API with the MySQL API

ERPNext is an open-source enterprise resource planning (ERP) software that integrates core business functions like accounting, inventory, sales, purchase, and HR management into a single system. With the ERPNext API, you can automate these functions by triggering actions in ERPNext or syncing data with other systems. Pipedream can be a powerful partner here, as it allows you to set up complex integrations and workflows without the need for a dedicated backend. By using Pipedream, you can connect ERPNext with numerous other apps to streamline processes, react to events in real-time, and automate data transfers.

Connect ERPNext#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    erpnext: {
      type: "app",
      app: "erpnext",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `${this.erpnext.$auth.base_url}/api/method/frappe.auth.get_logged_user`,
      auth: {
        username: `${this.erpnext.$auth.api_key}`,
        password: `${this.erpnext.$auth.api_secret}`,
      },
    })
  },
})

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#

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
    };
    const { rows } = await this.mysql.executeQuery(queryObj);
    return rows;
  },
});