What do you want to automate

with PostgreSQL and CoinCatch?

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

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

export default defineComponent({
  props: {
    coincatch: {
      type: "app",
      app: "coincatch",
    }
  },
  async run({ steps, $ }) {
    const accessKey = this.coincatch.$auth.access_key;
    const secretKey = this.coincatch.$auth.secret_key;
    const passphrase = this.coincatch.$auth.passphrase;

    // Helper function to generate signed headers
    const createSignedHeaders = ({
      method,
      requestPath,
      queryString = "",
      body = "",
    }) => {
      const timestamp = Date.now().toString();
      const upperMethod = method.toUpperCase();

      // Build content to sign
      let contentToSign = timestamp + upperMethod + requestPath;
      if (queryString) {
        contentToSign += "?" + queryString;
      }
      if (body) {
        contentToSign += body;
      }

      // Generate signature
      const hmac = crypto.createHmac("sha256", secretKey);
      hmac.update(contentToSign);
      const signature = hmac.digest("base64");

      return {
        timestamp,
        method: upperMethod,
        requestPath,
        queryString,
        body,
        contentToSign,
        signature,
        headers: {
          "ACCESS-KEY": accessKey,
          "ACCESS-SIGN": signature,
          "ACCESS-TIMESTAMP": timestamp,
          "ACCESS-PASSPHRASE": passphrase,
        },
      };
    };

    // Call helper to get signed headers + metadata
    const resp = createSignedHeaders({
      method: "GET",
      requestPath: "/api/mix/v1/account/accounts",
      queryString: "productType=umcbl"
    });

    const url = `https://api.coincatch.com${resp.requestPath}${resp.queryString ? "?" + resp.queryString : ""
      }`;

    // Make the API request
    return await axios($, {
      method: resp.method,
      url,
      headers: resp.headers,
      data: resp.body || undefined,
    });

  },
})