Integrate the MySQL API with the ShipHero API

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

Start for free — no credit card required

Watch a demo

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Popular Ways to Connect MySQL with ShipHero#

Execute SQL Query with MySQL API on Order Allocated (Instant) from ShipHero API

ShipHero + MySQL

Try it

Execute SQL Query with MySQL API on Order Deallocated (Instant) from ShipHero API

ShipHero + MySQL

Try it

Execute SQL Query with MySQL API on Order Packed Out (Instant) from ShipHero API

ShipHero + MySQL

Try it

Create Row with MySQL API on Order Allocated (Instant) from ShipHero API

ShipHero + MySQL

Try it

Create Row with MySQL API on Order Deallocated (Instant) from ShipHero API

ShipHero + MySQL

Try it

Popular MySQL and ShipHero Triggers#

Order Allocated (Instant) from the ShipHero API

Emit new event when an order is allocated. See the documentation.

Try it

Order Deallocated (Instant) from the ShipHero API

Emit new event when an order is deallocated. See the documentation.

Try it

Order Packed Out (Instant) from the ShipHero API

Emit new event when an order is packed out. See the documentation.

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

Popular MySQL and ShipHero Actions#

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

Get Order with the ShipHero API

Get an order. See the documentation

Try it

Create Row with the MySQL API

Adds a new row. See the docs here

Try it

List Products with the ShipHero API

List products. See the documentation

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#

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 ShipHero#

The ShipHero API enables granular control over warehousing and order fulfillment processes, offering endpoints for managing inventory, orders, returns, and shipping. In Pipedream, you can leverage this API to automate routine tasks, sync data across multiple platforms, and trigger actions based on specific events. This can save time, reduce errors, and increase operational efficiency for e-commerce businesses.

Connect ShipHero#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    shiphero: {
      type: "app",
      app: "shiphero",
    }
  },
  async run({steps, $}) {
    const data = {
      "query": `{
      products {
        request_id
        data(first: 100) {
          edges {
            node {
              id
              sku
              name
            }
          }
        }
      }
    }
    `,
    }
    return await axios($, {
      method: "post",
      url: `https://public-api.shiphero.com/graphql`,
      headers: {
        Authorization: `Bearer ${this.shiphero.$auth.oauth_access_token}`,
        "Content-Type": `application/json`,
      },
      data,
    })
  },
})

Start for free — no credit card required

Watch a demo