What do you want to automate

with OKX Wallet and PostgreSQL?

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

export default defineComponent({
  props: {
    okx_wallet: {
      type: "app",
      app: "okx_wallet",
    }
  },
  async run({ steps, $ }) {
    // Pull credentials from $auth
    const apiKey = this.okx_wallet.$auth.api_key;
    const secretKey = this.okx_wallet.$auth.secret_key;
    const passphrase = this.okx_wallet.$auth.passphrase;

    // Hardcoded request parameters
    const method = "GET";
    const requestPath = "/api/v5/account/balance";
    const body = ""; // GET request, no body

    // Function to generate signed headers
    const createSignedHeaders = ({ method, requestPath, body }) => {
      const timestamp = new Date().toISOString(); // UTC ISO timestamp with ms

      // Pre-hash string
      const prehash = timestamp + method.toUpperCase() + requestPath + body;

      // HMAC SHA256 signature, Base64 encoded
      const hmac = crypto.createHmac("sha256", secretKey);
      hmac.update(prehash);
      const signature = hmac.digest("base64");

      return {
        "OK-ACCESS-KEY": apiKey,
        "OK-ACCESS-SIGN": signature,
        "OK-ACCESS-TIMESTAMP": timestamp,
        "OK-ACCESS-PASSPHRASE": passphrase,
        "Content-Type": "application/json",
      };
    };

    // Generate headers
    const headers = createSignedHeaders({ method, requestPath, body });

    // Full URL
    const url = `${this.okx_wallet.$auth.api_url}${requestPath}`;

    // Make request and return reponse to next step
    return await axios($, {
      method,
      url,
      headers,
      data: body || undefined,
    });
  },
})

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