Integrate the Ontraport API with the MySQL API

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

Popular Ways to Connect Ontraport with MySQL#

Create Row with MySQL API on New Contact Created (Instant) from Ontraport API

Ontraport + MySQL

Try it

Create Row with MySQL API on New Form Submitted (Instant) from Ontraport API

Ontraport + MySQL

Try it

Create Row with MySQL API on Product Purchased (Instant) from Ontraport API

Ontraport + MySQL

Try it

Create Row with MySQL API on Tag Added (Instant) from Ontraport API

Ontraport + MySQL

Try it

Create Row with MySQL API on Transaction Created With Product (Instant) from Ontraport API

Ontraport + MySQL

Try it

Popular Ontraport and MySQL Triggers#

New Contact Created (Instant) from the Ontraport API

Emit new event when a new contact is created. See the docs.

Try it

New Form Submitted (Instant) from the Ontraport API

Emit new event when a new form is submitted. See the docs.

Try it

Product Purchased (Instant) from the Ontraport API

Emit new event when a product is purchased. See the docs.

Try it

Tag Added (Instant) from the Ontraport API

Emit new event when a tag is added. See the docs.

Try it

Transaction Created With Product (Instant) from the Ontraport API

Emit new event when a transaction is created with a product. See the docs.

Try it

Popular Ontraport 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 Ontraport#

Ontraport's API offers robust capabilities for automating business processes, managing customer relationships, and streamlining marketing efforts. Use it to create dynamic, serverless workflows on Pipedream that react to events in real-time, sync data between services, or enhance customer interactions. With this API, you can automate tasks such as updating contact information, tracking customer behaviors, and sending targeted communications, all customizable to your specific business needs.

Connect Ontraport#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    ontraport: {
      type: "app",
      app: "ontraport",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.ontraport.com/1/Contacts`,
      headers: {
        "Api-Key": `${this.ontraport.$auth.api_key}`,
        "Api-Appid": `${this.ontraport.$auth.api_appid}`,
      },
    })
  },
})

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