Integrate the Exact API with the MySQL API

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

Popular Ways to Connect Exact with MySQL#

Create Row with MySQL API on New Account Created from Exact API

Exact + MySQL

Try it

Create Row with MySQL API on New Contact Created from Exact API

Exact + MySQL

Try it

Delete Row with MySQL API on New Account Created from Exact API

Exact + MySQL

Try it

Delete Row with MySQL API on New Contact Created from Exact API

Exact + MySQL

Try it

Execute Query with MySQL API on New Account Created from Exact API

Exact + MySQL

Try it

Popular Exact and MySQL Triggers#

New Account Created from the Exact API

Emit new event each time a new account is created. See the docs

Try it

New Contact Created from the Exact API

Emit new event each time a new contact is created. See the docs

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

Popular Exact and MySQL Actions#

Create Row with the MySQL API

Adds a new row. See the docs here

Try it

Delete Row with the MySQL API

Delete an existing row. 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

Execute Raw Query with the MySQL API

Find row(s) via a custom raw query. See the documentation

Try it

Execute Stored Procedure with the MySQL API

Execute Stored Procedure. See the docs here

Try it

Overview of Exact#

The Exact API provides a suite of endpoints for interacting with Exact's cloud-based financial software, which includes tools for accounting, CRM, and ERP functionalities. By leveraging this API on Pipedream, you can automate data flows across various business functions, sync financial records, manage customer relationships, and streamline operational processes. Pipedream's serverless execution model allows for crafting intricate workflows that respond in real-time to events, schedule operations, and connect with countless other apps to extend the functionality of Exact's ecosystem.

Connect Exact#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    exact: {
      type: "app",
      app: "exact",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://start.exactonline.${this.exact.$auth.region}/api/v1/current/Me?$select=UserID,Email`,
      headers: {
        Authorization: `Bearer ${this.exact.$auth.oauth_access_token}`,
        "Content-Type": `application/json`,
      },
      params: {
        "$select": `UserID,Email`,
      },
    })
  },
})

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;
  },
});