Integrate the Gainsight API with the PostgreSQL API

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    gainsight_nxt: {
      type: "app",
      app: "gainsight_nxt",
    }
  },
  async run({steps, $}) {
    const data = {
    
    
    "includeTotal": true,
    "limit": 25,
    "page": 0,
    "orderBy": {
         "ModifiedDate": "desc"
    },
    "select": [
         "Name",
         "SFDCUserName",
         "Email",
         "IsSuperAdmin",
         "ModifiedDate",
         "LicenseType"
    ]
    }
    return await axios($, {
      method: "post",
      url: `${this.gainsight_nxt.$auth.customer_domain}/v1/users/services/list`,
      headers: {
        "content-type": `application/json`,
        "accept": `application/json, text/plain, */*`,
        "accept-language": `en-GB,en-US;q=0.9,en;q=0.8`,
        "accesskey": `${this.gainsight_nxt.$auth.access_key}`,
      },
      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);
  },
})