Integrate the Bolt IoT API with the MySQL API

The Bolt IoT API lets you harness the power of your Bolt IoT devices, enabling you to control and monitor them remotely through Pipedream. With Pipedream's serverless platform, you can create automated workflows that trigger on specific events, process data, and integrate with countless other services. Whether you're aiming to automate your smart home, set up alerts, or manage device data, Pipedream makes it straightforward to connect Bolt IoT with a world of apps and services for a seamless automation experience.

Connect Bolt IoT#

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    bolt_iot: {
      type: "app",
      app: "bolt_iot",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://cloud.boltiot.com/remote/${this.bolt_iot.$auth.api_key}/getDevices`,
    })
  },
})

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);
  },
});