SilFer Bots

Facebook Messenger bot for sales

Go to site

Integrate the SilFer Bots API with the MySQL API

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

Connect SilFer Bots

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://api.silferbots.co/user/[USER_ID]`,
  headers: {
    "X-SILFER-ACCESS-TOKEN": `${auths.silfer_bots.api_key}`,
  },
})

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)