Integrate the Pixelbin API with the MySQL API

import { PixelbinConfig, PixelbinClient } from "@pixelbin/admin";

export default defineComponent({
  props: {
    pixelbin: {
      type: "app",
      app: "pixelbin",
    }
  },
  async run({steps, $}) {

    // Creates a Pixelbin config using the API Token
    const config = new PixelbinConfig({
        domain: "https://api.pixelbin.io",
        apiSecret: this.pixelbin.$auth.api_token,
        integrationPlatform: "@PipedreamHQ/pipedream v0.1",
    });

    const pixelbin = new PixelbinClient(config);

    const getData = async function() {
      try {
          // list the assets stored on your organization's Pixelbin Storage
          const explorer = pixelbin.assets.listFilesPaginator({
              onlyFiles: true,
              pageSize: 5,
          });
          if (explorer.hasNext()) {
              return await explorer.next();
          }
      } catch (err) {
          console.log(err);
      }
    };

    //Returns list of assets to use in the Pipedream workflow's downstream steps
    return await getData();
  },
})

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