Integrate the PostgreSQL API with the Azure AI Vision 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 { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    azure_ai_vision: {
      type: "app",
      app: "azure_ai_vision",
    }
  },
  async run({steps, $}) {
    const data = {
      "url": `https://images.unsplash.com/photo-1528459199957-0ff28496a7f6`, //e.g. https://images.unsplash.com/photo-1528459199957-0ff28496a7f6
    }    
    return await axios($, {
      method: "POST",
      url: `${this.azure_ai_vision.$auth.endpoint}computervision/imageanalysis:analyze`,
      params: {
        "api-version": `2023-02-01-preview`,
        features: `read`, //e.g. read
      },
      headers: {
        "Ocp-Apim-Subscription-Key": `${auths.azure_ai_vision.subscription_key}`,
      },
      data,      
    })
  },
})