Integrate the Microsoft Azure SQL Database API with the Shopify Developer App API

import sql from "mssql"
export default defineComponent({
  props: {
    azure_sql: {
      type: "app",
      app: "azure_sql",
    }
  },
  async run({steps, $}) {
    const { host, username, password, port, database, encrypt } = this.azure_sql.$auth
    const config = {
      user: username, 
      password, 
      server: host, 
      port, 
      database, 
      authentication: {
          type: 'default'
      },
      options: {
          encrypt
      }
    }
    await sql.connect(config);
    return await sql.query`SELECT GETDATE()`
  },
})

import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    shopify_developer_app: {
      type: "app",
      app: "shopify_developer_app",
    }
  },
  async run({steps, $}) {
    const data = {
      "query": `{  
        shop { 
          id 
          name
          email 
        } 
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://${this.shopify_developer_app.$auth.shop_id}.myshopify.com/admin/api/2024-04/graphql.json`,
      headers: {
        "X-Shopify-Access-Token": `${this.shopify_developer_app.$auth.access_token}`,
        "Content-Type": `application/json`,
      },
      data,
    })
  },
})