Integrate the ClassMarker API with the PostgreSQL API

import axios from "axios";
import crypto from "crypto";

export default defineComponent({
  props: {
    classmarker: {
      type: "app",
      app: "classmarker",
    }
  },
  async run({ steps, $ }) {
    const timestamp = Math.floor(Date.now() / 1000);
    const string_to_hash = this.classmarker.$auth.api_key + this.classmarker.$auth.api_secret + timestamp;
    const signature = crypto.createHash('md5').update(string_to_hash).digest('hex');
    const { data } = await axios({
      method: "GET",
      url: "https://api.classmarker.com/v1.json",
      params: {
        api_key: this.classmarker.$auth.api_key,
        signature,
        timestamp
      }
    })
    return data
  },
})

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