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 Notion API

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

Append Block to Parent with Notion API on New Column from Microsoft Azure SQL Database API
Microsoft Azure SQL Database + Notion
 
Try it
Append Block to Parent with Notion API on New or Updated Row from Microsoft Azure SQL Database API
Microsoft Azure SQL Database + Notion
 
Try it
Create Page from Database with Notion API on New Column from Microsoft Azure SQL Database API
Microsoft Azure SQL Database + Notion
 
Try it
Create Page from Database with Notion API on New or Updated Row from Microsoft Azure SQL Database API
Microsoft Azure SQL Database + Notion
 
Try it
Create Page with Notion API on New Column from Microsoft Azure SQL Database API
Microsoft Azure SQL Database + Notion
 
Try it
New Column from the Microsoft Azure SQL Database API

Triggers when a new column is added to a table.

 
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
New Database from the Notion API

Emit new event when a database is created. Note: Databases must be shared with your Pipedream Integtration to trigger event.

 
Try it
New Page in Database from the Notion API

Emit new event when a page in a database is created

 
Try it
Page or Subpage Updated from the Notion API

Emit new event when a page or one of its sub-pages is updated.

 
Try it
Execute SQL Query with the Microsoft Azure SQL Database API

Execute a custom SQL query. See our docs to learn more about working with SQL in Pipedream.

 
Try it
Append Block to Parent with the Notion API

Creates and appends blocks to the specified parent. 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
Create Page with the Notion API

Creates a page from a parent page. The only valid property is title. See the documentation

 
Try it
Create Page from Database with the Notion API

Creates a page from a database. See the docs

 
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
import azure_sql from '@pipedream/azure_sql';

export default defineComponent({
  props: {
    azure_sql,
  },
  async run({ steps, $ }) {
    // Component source code:
    // https://github.com/PipedreamHQ/pipedream/tree/master/components/azure_sql

    const queryObj = {
      query: "SELECT GETDATE()",
      values: [],
    };
    return await this.azure_sql.executeQuery(queryObj);
  },
});

Overview of Notion

Notion's API allows for the creation, reading, updating, and deleting of pages, databases, and their contents within Notion. Using Pipedream's platform, you can build workflows that connect Notion with various other services to automate tasks such as content management, task tracking, and data synchronization. With Pipedream's serverless execution, you can trigger these workflows on a schedule, or by external events from other services, without managing any infrastructure.

Connect Notion

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