Integrate the HubSpot API with the MySQL API

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

Popular Ways to Connect HubSpot with MySQL#

Add Contact to List with HubSpot API on New Column from MySQL API

MySQL + HubSpot

Try it

Add Contact to List with HubSpot API on New or Updated Row from MySQL API

MySQL + HubSpot

Try it

Add Contact to List with HubSpot API on New Row (Custom Query) from MySQL API

MySQL + HubSpot

Try it

Add Contact to List with HubSpot API on New Row from MySQL API

MySQL + HubSpot

Try it

Add Contact to List with HubSpot API on New Table from MySQL API

MySQL + HubSpot

Try it

Popular HubSpot and MySQL Triggers#

Company Updated from the HubSpot API

Emit new event each time a company is updated.

Try it

Contact Updated from the HubSpot API

Emit new event each time a contact is 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

Popular HubSpot and MySQL Actions#

Add Contact to List with the HubSpot API

Adds a contact to a specific static list. See the documentation

Try it

Create Row with the MySQL API

Adds a new row. See the docs here

Try it

Batch Create or Update Contact with the HubSpot API

Create or update a batch of contacts by its ID. See the documentation

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

Overview of HubSpot#

The HubSpot API enables developers to integrate into HubSpots CRM, CMS, Conversations, and other features. It allows for automated management of contacts, companies, deals, and marketing campaigns, enabling custom workflows, data synchronization, and task automation. This streamlines operations and boosts customer engagement, with real-time updates for rapid response to market changes.

Connect HubSpot#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    hubspot: {
      type: "app",
      app: "hubspot",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.hubapi.com/integrations/v1/me`,
      headers: {
        Authorization: `Bearer ${this.hubspot.$auth.oauth_access_token}`,
      },
    })
  },
})

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