Integrate the PostgreSQL API with the Verdict as a Service API

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 Vaas from "gdata-vaas";

export default defineComponent({
  props: {
    verdict_as_a_service: {
      type: "app",
      app: "verdict_as_a_service",
    }
  },
  async run({steps, $}) {
// create vaas client
    const vaas = await createVaasWithClientCredentialsGrant(
      CLIENT_ID,
      CLIENT_SECRET,
      TOKEN_URL,
      VAAS_URL
    );
    // request verdict for file
    const verdict = await vaas.forFile(response.data);
    if (verdict === "Malicious") {
      console.log("This was malware.");
    }
  },
})