What do you want to automate

with 3Commas and PostgreSQL?

import crypto from "crypto";
import { axios } from "@pipedream/platform";

// Helper function to generate HMAC SHA256 signature
function generateSignature(secretKey, payload) {
  return crypto
    .createHmac("sha256", secretKey)
    .update(payload)
    .digest("hex");
}

export default defineComponent({
  props: {
    _3commas: {
      type: "app",
      app: "_3commas",
    }
  },
  async run({ steps, $ }) {
    const path = "/public/api/ver1/accounts"; //Set your own URL Path and QueryString
    const queryString = "";
    const payload = queryString && queryString.trim() !== ""
      ? `${path}?${queryString}`
      : path;



    // Generate signature
    const signature = generateSignature(this._3commas.$auth.secret_key, payload);

    // Build headers
    const headers = {
      Apikey: this._3commas.$auth.api_key,
      Signature: signature
    };


    // Make request
    const url = `https://api.3commas.io${payload}`;
    return await axios($, {
      method: "GET",
      url,
      headers,
    });
  },
})

import postgresql from "@pipedream/postgresql"

export default defineComponent({
  props: {
    postgresql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/postgresql

    const queryObj = {
      text: "SELECT NOW()",
      values: [], // Ignored since query does not contain placeholders
    };
    return await this.postgresql.executeQuery(queryObj);
  },
})