Aroflo

Field Service Management Software

Go to site

Integrate the Aroflo API with the MySQL API

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

Connect Aroflo

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://api.aroflo.com/`,
  headers: {
    "Accept": `text/json`,
    "Authentication": `HMAC ${auths.aroflo.hmac_key}`,
  },
  params: {
    where: `and|archived|=|false`,
    zone: `users`,
    page: `1`,
  },
})

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)