with TimescaleDB and Notion?
Emit new event when a new comment is created in a page or block. See the documentation
Emit new event when a data source is created. See the documentation
Emit new event when a page is created or updated in the selected data source. See the documentation
Emit new event when a page is created or updated in the selected data source. See the documentation
Emit new event when a page is created in the selected data source. See the documentation
Append new and/or existing blocks to the specified parent. See the documentation
Use this action to finalize a mode=multi_part
file upload after all of the parts have been sent successfully. See the documentation
Create a comment in a page or existing discussion thread. See the documentation
Create a database and its initial data source. See the documentation
import { Pool } from 'pg'; //required by sequelize
import { Sequelize } from "sequelize";
export default defineComponent({
props: {
timescaledb: {
type: "app",
app: "timescaledb",
}
},
async run({steps, $}) {
//Creating object with connection to TimescaleDB instance
const sequelize = new Sequelize({
dialect: 'postgres',
protocol: 'postgres',
host: this.timescaledb.$auth.host,
port: this.timescaledb.$auth.port,
username: this.timescaledb.$auth.user,
password: this.timescaledb.$auth.password,
database: this.timescaledb.$auth.database,
dialectOptions: {
ssl: {
require: true,
rejectUnauthorized: this.timescaledb.$auth.ssl_verification_mode === 'verify_identity'
}
}
})
// Test the connection and return the result
try {
await sequelize.authenticate()
const queryInterface = sequelize.getQueryInterface();
const [results, metadata] = await queryInterface.sequelize.query('SELECT 1+1 AS result');
return results;
} catch (error) {
throw new Error(`Unable to connect to the database: ${error}`)
} finally {
await sequelize.close()
}
},
})
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.
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`,
},
})
},
})