Firebase Admin SDK

Firebase is Google's mobile platform that helps you quickly develop high-quality apps and grow your business.

Go to site

Integrate the Firebase Admin SDK API with the MySQL API

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

Connect Firebase Admin SDK

const admin = require('firebase-admin')

// Enter values for the following parameters below this code step,
// These get passed to the initializeApp method below.
const { projectId, clientEmail, privateKey } = auths.firebase_admin_sdk

// Before passing the privateKey to the initializeApp constructor,
// we have to replace newline characters with literal newlines
const formattedPrivateKey = privateKey.replace(/\\n/g, '\n')

// See https://firebase.google.com/docs/reference/admin/node/admin.credential.html#cert
if (!admin.apps.length) {
  admin.initializeApp({
    credential: admin.credential.cert({
      projectId,
      clientEmail,
      privateKey: formattedPrivateKey,
    })
  })
}

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)