Integrate the Microsoft Azure SQL Database API with the ServiceNow 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: {
    servicenow: {
      type: "app",
      app: "servicenow",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://${this.servicenow.$auth.instance_name}.service-now.com/api/now/table/incident`,
      headers: {
        Authorization: `Bearer ${this.servicenow.$auth.oauth_access_token}`,
      },
    })
  },
})