Microsoft Azure SQL Database

Build apps that scale with managed and intelligent SQL database in the cloud.

Integrate the Microsoft Azure SQL Database API with the Zoom Admin API

Setup the Microsoft Azure SQL Database API trigger to run a workflow which integrates with the Zoom Admin API. Pipedream's integration platform allows you to integrate Microsoft Azure SQL Database and Zoom Admin remarkably fast. Free for developers.

Execute Query with Microsoft Azure SQL Database API on Account Created from Zoom Admin API
Zoom Admin + Microsoft Azure SQL Database
 
Try it
Insert Row with Microsoft Azure SQL Database API on Account Created from Zoom Admin API
Zoom Admin + Microsoft Azure SQL Database
 
Try it
Execute Query with Microsoft Azure SQL Database API on Custom Events from Zoom Admin API
Zoom Admin + Microsoft Azure SQL Database
 
Try it
Execute Query with Microsoft Azure SQL Database API on Meeting Started from Zoom Admin API
Zoom Admin + Microsoft Azure SQL Database
 
Try it
Insert Row with Microsoft Azure SQL Database API on Custom Events from Zoom Admin API
Zoom Admin + Microsoft Azure SQL Database
 
Try it
Account Created from the Zoom Admin API

Emits an event each time a sub-account is created in your master account

 
Try it
Custom Events from the Zoom Admin API

Listen for any events tied to your Zoom account

 
Try it
New Column from the Microsoft Azure SQL Database API

Triggers when a new column is added to a table.

 
Try it
Meeting Started from the Zoom Admin API

Emits an event each time a meeting starts in your Zoom account

 
Try it
New or Updated Row from the Microsoft Azure SQL Database API

Triggers when a new row is added or an existing row is updated.

 
Try it
Execute Query with the Microsoft Azure SQL Database API

Executes a SQL query and returns the results. See the documentation

 
Try it
Insert Row with the Microsoft Azure SQL Database API

Inserts a new row in a table. See the documentation

 
Try it
Add meeting registrant with the Zoom Admin API

Register a participant for a meeting. See the docs here

 
Try it
Add webinar panelist with the Zoom Admin API

Register a panelist for a webinar. See the docs here

 
Try it
Add webinar registrant with the Zoom Admin API

Register a participant for a webinar. See the docs here

 
Try it

Overview of Microsoft Azure SQL Database

The Microsoft Azure SQL Database API allows you to manage and interact with your SQL databases hosted on Azure directly from Pipedream. It provides a serverless way to run SQL queries, manage tables, and handle database management tasks. You can create, read, update, and delete database records, execute stored procedures, and perform a variety of other SQL operations. Leveraging this API on Pipedream enables you to automate workflows, respond to database events in real-time, and integrate with countless other apps and services.

Connect Microsoft Azure SQL Database

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
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()`
  },
})

Overview of Zoom Admin

The Zoom Admin API lets you harness the extensive capabilities of Zoom for automation and integration, right within Pipedream. Automate user management, track Zoom rooms, monitor webinars and meetings, and customize your workflow to respond dynamically to events like new participants or ended meetings. With these APIs and the power of Pipedream, you can streamline administrative tasks, extract valuable insights, and sync Zoom activities with other services.

Connect Zoom Admin

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    zoom_admin: {
      type: "app",
      app: "zoom_admin",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.zoom.us/v2/users/me`,
      headers: {
        Authorization: `Bearer ${this.zoom_admin.$auth.oauth_access_token}`,
      },
    })
  },
})