ShipStation

Import, manage and ship your orders with ShipStation

Go to site

Integrate the ShipStation API with the MySQL API

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

Connect ShipStation

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://ssapi.shipstation.com/users/`,
  auth: {
    username: `${auths.shipstation.api_key}`,
    password: `${auths.shipstation.api_secret}`,
  },
})

Connect MySQL

const mysql = require('mysql2/promise');

const { host, port, username, password, database } = auths.mysql

const connection = await mysql.createConnection({
  host,
  port,
  user: username,
  password,
  database,
});

const [rows, fields] = await connection.execute('SELECT NOW()');
console.log(rows)